Posted to microsoft.public.excel.programming

Graham Whitehead Graham Whitehead is offline

external usenet poster

Posts: 72

Get names of all workbooks in a directory

I have done this previously but I am unable to remember how I did it.
Basically I have a load of excel workbooks in one directory and I want to
create a loop to get the names of each workbook so that I can store them and
use them all later on. If anyone can help with this one I would be very
gratefull. 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
Changing directory names	Norman Jones	Excel Programming	1	October 18th 05 12:48 PM
Changing directory names	Bob Phillips[_6_]	Excel Programming	0	October 18th 05 10:43 AM
Getting file names in a directory	John	Excel Programming	2	March 8th 05 03:38 PM
Creating a macro that lists directory names within a directory....	Andy	Excel Programming	4	November 28th 04 06:13 AM
Aquiring Directory names	aking1987[_6_]	Excel Programming	1	November 16th 04 01:45 PM

All times are GMT +1. The time now is 01:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us