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
You are currently viewing the BOOK: Excel 2000/2002 VBA Programmer's Reference section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
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.
Using ADO with non-standard data sources - Ch. 20
Linear Mode
