It's obviously been a long time. This project had gotten shelved and was finally revived. Just wanted to make sure I thanked you properly for the link. I was able to get everything I needed.
And thanks to the UT message archive so that I could come back to it when needed.
..........Rich
>It should be an .xlsm file if it has vba code.
>
>Bill Sutton
>
>
>>Thanks. I had actually seen this link and it didn't work for me. Since you recommended it, I took a closer look and found that I was opening an XLS spreadsheet the didn't have workbook.vbproject.
>>
>>I opened an XLSX file and found the property. I'll see if this code gets me what I need.
>>
>>Thanks again............Rich
>>
>>>Hey Rich
>>>
>>>I think this will help you out.
>>>
>>>
http://www.rondebruin.nl/win/s9/win002.htm>>>
>>>
>>>Bill Sutton
>>>
>>>
>>>
>>>>>>Hi All:
>>>>>>
>>>>>>We have inherited the support of a couple of dozen Excel spreadsheets. These all have a bunch of VBA methods.
>>>>>>
>>>>>>Is there some way we can open the spreadhseets and extract the method code so that we can build a big code database that can be searched
>>>>>>
>>>>>>For example ..... Which methods in which spreadsheets reference a particular drive mapping???
>>>>>> Which methods in which spreadsheets use a specific DSN
>>>>>> etc.
>>>>>>
>>>>>>How can we accumulate the VBA code to do those kinds of searches?
>>>>>>
>>>>>
>>>>>I was sure I'd written something about this, but I can't find it. Regardless, check out the Modules collection in VBA.
>>>>>
>>>>>Tamar
>>>>Thanks for the advice. If you have any pointers or links on how to use this it would help a great deal. So far I've tried
>>>>oXl = CREATEOBJECT('excel.application')
>>>>oWb = oXl.wookbooks.open(GETFILE())
>>>>? oXl.modules.count --> 0
>>>>? oXl.application.modules.count --> 0
>>>>? oWb.modules.count --> 0
>>>>? oWb.application.modules.count --> 0
>>>>
>>>>
>>>>Google hasn't been especially useful for me either.
>>>>
>>>>Anything use can provide will be useful.
>>>>
>>>>Thanks so much.........Rich