Posted to microsoft.public.excel.programming

techmoney

external usenet poster

Posts: 2

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
can not scroll on Edit links very long list of filenames	Louw Rademeyer SARS	Excel Discussion (Misc queries)	1	March 19th 09 12:48 PM
Macro for creating dynamic filenames	Brian Beck	Excel Discussion (Misc queries)	6	July 27th 06 08:24 PM
List all filenames & tab names	Deeds	Excel Worksheet Functions	5	May 18th 06 11:16 PM
Folder and filenames?	Mark[_45_]	Excel Programming	6	July 1st 04 03:49 AM
List out FileNames.xls with K4 Blank	JMay	Excel Programming	4	December 7th 03 04:35 PM

All times are GMT +1. The time now is 01:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us