Looping through Excel Workbooks collection

		Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
Looping through Excel Workbooks collection

Excel VBA Discuss using VBA for Excel programming.

Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

April 14th, 2004, 12:21 PM

clickco

Registered User

Join Date: Apr 2004

Posts: 3

Thanks: 0

Thanked 0 Times in 0 Posts

Looping through Excel Workbooks collection

Does anyone know how to code the following:
I need to loop through a specified Excel workbooks' worksheets to check for the existence of a range called "data". The complication is that there may be more than 1 range exiting in any one workbook as it may exist on several sheets...

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ident Open Workbooks in Multiple Excel Instances	DaveTheOgre	Pro VB Databases	0	November 12th, 2008 03:33 AM
two workbooks--matching values within	kwik10z	Excel VBA	0	November 29th, 2007 11:51 AM
excel workbooks.open bug	smiler_00	Pro VB 6	0	May 9th, 2007 05:24 AM
Opening Workbooks With Macros	RollingWoodFarm	Excel VBA	1	February 11th, 2007 05:48 AM
Looping through all records in excel?	dhl365	Pro VB 6	1	July 26th, 2005 03:39 PM