Posted to microsoft.public.excel.programming

Stuart[_5_] Stuart[_5_] is offline

external usenet poster

Posts: 413

Loop through all Open workbooks

User has opened workbooks - I've no idea as to their names
nor how many.
With ActiveWorkbook will deal with one of them.
How do I get at the others, please?

Regards.

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.700 / Virus Database: 457 - Release Date: 06/06/2004

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
Loop through open workbooks	Bob Phillips[_6_]	Excel Programming	2	April 28th 04 09:28 AM
IF wokkbook1 is open, open workbook2 Loop	Fio[_2_]	Excel Programming	1	March 5th 04 01:10 PM
loop through workbooks	Keith Willshaw	Excel Programming	2	September 19th 03 12:48 PM
loop through workbooks	Ron de Bruin	Excel Programming	1	September 18th 03 02:53 PM
Can I have a loop to open a set of workbooks get some data, close it one a time.	wellie	Excel Programming	2	July 9th 03 04:58 AM

All times are GMT +1. The time now is 09:52 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us