Activate Range for Workbooks Already Open

Posted to microsoft.public.excel.programming

shorticake shorticake is offline

external usenet poster

Posts: 13

Activate Range for Workbooks Already Open

Could anyone help me with code to search through the file names of workbooks
I already have open, and for each file that meets my search criteria make a
specific worksheet and range active?

Thanks

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
Access Named range value with multiple workbooks open	[email protected][_2_]	Excel Programming	3	December 15th 06 01:25 AM
Windows().Activate vs Workbooks().Activate	Gary''s Student	Excel Programming	4	November 6th 06 02:01 PM
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed	Frank Jones	Excel Programming	2	June 15th 04 03:21 AM
Excel VBA - Activate Open Workbooks to format	exceller	Excel Programming	2	June 10th 04 12:14 PM
Use Array to activate workbooks	Stuart[_5_]	Excel Programming	3	December 2nd 03 08:17 PM

All times are GMT +1. The time now is 04:12 AM.

Menu

About Us