Get File names using VBA

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Keith Emery (anonymous_at_discussions.microsoft.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 08:54:12 -0700

Simplest thing is to use DOS!

DIR > myfile.txt

then open with Word
>-----Original Message-----
>Excel 2k
>
>Hi
>
>I have a folder that has over 200 documents in. I would
>like to get a list of these document names into a word
>document without manually copying and pasting each
>individual file name. Can anyone supply with with the
code?
>.
>

Relevant Pages

  • Re: Upgraded Hard Drive, Now Outlook 2003 wont receive messages
    ... I haven't done the DOS option yet. ... I unhid the "protected operating system files" in ... you check off the appropriate box under Folder Options, ... Even after copying the Windows/Installer file from the old disk, ...
    (microsoft.public.outlook.installation)
  • Re: In the mad and crazy world of home computing . . . (ShowFolder[1]. - Delete Problem)
    ... >>> file in question is not in a temporary internet folder. ... >> If worse comes to worse delete it in DOS... ... Boot with the above diskette which will allow you to access the NTFS ... will not need the disk and any handy startup disk will do. ...
    (microsoft.public.win2000.file_system)
  • Re: reply
    ... neither the listed name or command line ... > folder temporarily by using attrib.exe: ... > In DOS (you may have to restart into DOS to lock this ... > that the trojan is suspected of running at WinME ...
    (microsoft.public.security.virus)
  • Re: Creating an Unattended Install folder on the Hardrive
    ... >I want to create an unattended installation folder on my harddrive that I ... But when I try to boot into DOS and run winnt then I ... > run setup from dos using Winnt.exe? ...
    (microsoft.public.windowsxp.setup_deployment)
  • Creating an Unattended Install folder on the Hardrive
    ... I want to create an unattended installation folder on my harddrive that I ... So then I create the unattend file using the Install from CD option and then ... But when I try to boot into DOS and run winnt then I ...
    (microsoft.public.windowsxp.setup_deployment)