Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Determine name of macro contained in each excel file in a folder
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="John, post: 7402419"] OK, I got rained out tonight so a few extra minutes to play with this. I checked the reference noted below, and did get further (at first it was a compile error I think). But now I get an error on this line (of Chip's example): Set VBProj = ActiveWorkbook.VBProject which says Programmatic access to Visual Basic Project is not trusted. If I try to step again on this line of code the error changes to: Method 'VBProject' of object '_Workbook' failed FWIW, I'm on WinXP and Excel 2007. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Programming
Determine name of macro contained in each excel file in a folder
Top