Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > BOOK: Excel 2000/2002 VBA Programmer's Reference
Password Reminder
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Excel 2000/2002 VBA Programmer's Reference
This is the forum to discuss the Wrox book Excel 2000 VBA: Programmers Reference by John Green, Stephen Bullen, Felipe Martins, Brian Johnson; ISBN: 9780764544019
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Excel 2000/2002 VBA Programmer's Reference section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Display Modes
  #1 (permalink)  
Old March 21st, 2007, 09:54 AM
Registered User
Join Date: Sep 2006
Location: , , USA.
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Using ADO with non-standard data sources - Ch. 20

Hi all, I was wondering if someone can help me with this question. I can successfully use the ADO method in the book to search through a massive amount of spreadsheets in distributed folders to look for information on the sheets. However, I noticed that the code example heavily depends on knowing at least the sheet names ahead of time.

Is there a method for getting the sheet names similar to getting a list of table names when the sheet names are unknown?

I have to search through the list to find every instance of a workbook with a particular string subset in the sheet names.

For example, if I were looking for 'xyz' in the sheet names, I would get the sheet names and do a string test 'intPos = InSt(sheetname, "xyz")' for each sheet, and if intPos is greater than zero, it found it. But, I need to get the collection of sheet names without the hassle of creating a new instance of excel opening each and every book to get the names.

Thanks for any help! :)
Brian Mize
Reply With Quote

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
SQL Express & Ch 20 Nick Y BOOK: Ivor Horton's Beginning Visual C++ 2005 1 August 2nd, 2007 05:16 PM
Joining data from multiple data sources ClaesR BOOK: Professional SQL Server 2005 Reporting Services ISBN: 0-7645-8497-9 0 August 28th, 2006 09:30 AM
News:XD++ MFC Library Standard Edition V8.20 is re kellyonlyone Visual C++ 0 June 27th, 2006 11:12 PM
TCPSend/ Receive system.dll problem (ch 20) dingke BOOK: Professional C#, 2nd and 3rd Editions 0 March 10th, 2004 04:42 PM

All times are GMT -4. The time now is 02:54 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.