Extracting txt information from a mapped drive to import to excel

[Guest]

Hello:

I'm trying to figure out a way I can take the file names shown in a mapped
server export them to a an excel file.

For example.
Mapped drive U:\folderA\ contains 100+ plus .Doc files. I'm trying to find
a way to take all of file names and import them to an excel file so I can use
Access to search the names and bounce them off of another table to run a
report.

Earlier I post a simliar question and Alice provided the "dir >
filelist.txt" function which works great. My problem is this only works for
for files currently on my C: drive. (I'm unable to use the Dos comand to get
to a mapped directory..)

If there is another way or does anybody body have a suggestion on
accomplishing this task?

Thanks.

 

[Pegasus \(MVP\)]

Hello:

I'm trying to figure out a way I can take the file names shown in a mapped
server export them to a an excel file.

For example.
Mapped drive U:\folderA\ contains 100+ plus .Doc files. I'm trying to find
a way to take all of file names and import them to an excel file so I can use
Access to search the names and bounce them off of another table to run a
report.

Earlier I post a simliar question and Alice provided the "dir >
filelist.txt" function which works great. My problem is this only works for
for files currently on my C: drive. (I'm unable to use the Dos comand to get
to a mapped directory..)

If there is another way or does anybody body have a suggestion on
accomplishing this task?

Thanks.

Instead of typing
dir > filelist.txt you should type
dir "U:\FolderA" > c:\filelist.txt or perhaps
dir /b /on "U:\FolderA" > c:\filelist.txt

 

[Guest]

Thank you.

This site rocks...

Instead of typing
dir > filelist.txt you should type
dir "U:\FolderA" > c:\filelist.txt or perhaps
dir /b /on "U:\FolderA" > c:\filelist.txt