file name with path

[22strider]

Hello Friends

What DOS Prompt command should be used for displaying file names with their paths?

For my project I need to list all the files in the main directory and the subdirectories along with their paths.

Thanks for your time

Rajesh

 

[srizki]

=cell("filename")

 

[22strider]

Hello Sohail

is that for DOS prompt?

thanks
Rajesh

 

[srizki]

Hello Sohail

is that for DOS prompt?

thanks
Rajesh

no for excel forum it is for Excel.

 

[srizki]

Displays or sets a search path for executable files.
PATH [[drive:]path[;...]]
PATH ;
Type PATH ; to clear all search-path settings and direct Windows to search
only in the current directory.
Type PATH without parameters to display the current path.
Examples
path=c:\windows\command
This is where a lot of DOS commands are stored in Window 95; if you are not able to do a dos command, type this command in, allowing all commands you type in, such as "deltree", to be loaded from this directory. However, if you have another file in another directory such as C:\DOS it will no longer look there.

 

[22strider]

thanks for your response; I was looking for some help on DOS prompt.

 

[Bill C]

If you type tree at the prompt and press [enter] DOS will show all the folders and paths for the current DOS directory.

Bill C

 

[EXCESSPOTENTIAL]

What about if you just want part of the filename in a cell. I have

=Cell("filename")

But if want to capture just part of the name

J

 

[srizki]

What about if you just want part of the filename in a cell. I have

=Cell("filename")

But if want to capture just part of the name

J

See Noorie's answer

http://www.mrexcel.com/forum/showthread.php?t=473517