Re: Extracting txt information from a mapped drive to import to excel

Tech-Archive recommends: Fix windows errors by optimizing your registry


"Deathvalley" <Deathvalley@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0D9CF479-9341-4C48-87C3-A7D639C021C9@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Re: Advanced HTML DOM Issue
    ... > I want to help the lazy user toward that structure so that if they ... > never cap, or worse, keep the caps lock on, then it will be entered ... Also I would like to avoid server load ... And on top of that it will disconcert the user if you do this while he's typing. ...
    (alt.html)
  • Re: TEST yes problems again
    ... it all up in WordPad, as plain text. ... But I'd call your ISP or get a Usenet server list and ping away, ... This is what I do while I'm typing them now, PLUS, I do this with ALL ... 'programs' lists that comes up after you click "start") document ...
    (alt.support.chronic-pain)
  • Re: new server and problems with mdw file
    ... What server OS on the new server? ... It was looking like an environmental (network) issue from the beginning. ... It's acting as if the share folder is "shared" but only limited to one user ... - create an excel file, save it, and delete it. ...
    (microsoft.public.access.security)
  • Re: Word 2007 - shared files - Excel as datasource
    ... The folder on the server containing the word and excel files is marked as ... Many persons could open word docs and perform merge process to create new ... can access the word docs and/or the excel file at a time. ... not finding the recipient I had typed in to the query. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: No synchronize with making a replika with msacces wizard.
    ... Er, what, exactly, did you think you were accomplishing with this? ... If the users are going to have access to the server to edit those ... Why are you making multiple replicas on the same server in the first ...
    (microsoft.public.access.replication)