Posted to microsoft.public.excel.programming

Craig[_24_] Craig[_24_] is offline

external usenet poster

Posts: 39

Excel macro to open files within a folder

I'm trying to create a macro to open all of the files within a certain
folder. For example, it would open all of the .xls files in
C:\Timesheets. I'm lost on how to do this. I'm able to get a single
file open if I have the file name, but the file names are going to
vary. Also is it possible to only open certain files within a specific
folder based on parameters of the filename (like all files starting
with 07*****.xls)?

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
How do you set Excel 2007 to open files in a specific folder?	Opening to a specific folder	Excel Discussion (Misc queries)	2	August 12th 07 02:58 AM
can't open excel files from common folder	dsdproduction	Excel Discussion (Misc queries)	4	July 5th 07 08:34 PM
Can't Open Certain Excel Files in Folder	Charles A C	Excel Discussion (Misc queries)	2	March 23rd 07 12:02 AM
Open Excel files in a folder	Tom Ogilvy	Excel Programming	0	August 20th 03 04:59 PM
Open Excel files in a folder	Bob Phillips[_5_]	Excel Programming	0	August 20th 03 04:47 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us