Posted to microsoft.public.excel.programming

ianripping[_8_] ianripping[_8_] is offline

external usenet poster

Posts: 1

Opening multiple workbooks

Currently I have a mcro that opens up one workbook: -

Sub Macro1()
Workbooks.Open Filename:="C:\Data\Book2.xls"
End Sub

Can I make this Macro open all .xls files in the current Directory: -
Like

Sub Macro1()
Workbooks.Open Filename:="C:\Data\*.xls"
End Sub

Any ideas

--
Message posted from http://www.ExcelForum.com

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
Opening multiple excel workbooks at once	Bill	Excel Discussion (Misc queries)	0	March 6th 10 01:12 AM
Opening multiple workbooks in Excel	bdigs	Excel Discussion (Misc queries)	3	February 21st 08 02:35 AM
Opening Multiple Workbooks	SJT	Excel Discussion (Misc queries)	1	June 6th 06 06:32 PM
Opening multiple workbooks in separate screens	CS043	New Users to Excel	3	January 10th 06 02:39 PM
Opening Multiple Workbooks	MISMitch	Excel Programming	1	August 25th 03 05:29 PM

All times are GMT +1. The time now is 06:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us