Thread: Help with a Macro to list all filenames and mod dates in a folder
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
techmoney techmoney is offline
external usenet poster
  
Posts: 2
Default Help with a Macro to list all filenames and mod dates in a folder
Can someone please show me how I can write a script to list all files
in a particular folder.

Example:

C:\Rosters\Nov 2004\

AAA.xls
BBB.doc
CCC.csv


I would like to have a list of the files on column A of a Excel
Spreadsheet...with Modified Date to. The number of files in the
folder will be dynamic

Thanks in advance!
Reply With QuoteReply With Quote