Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine if Macros exist?

Status
Not open for further replies.
mikeyc1204

mikeyc1204

Programmer
Joined
Feb 20, 2004
Messages
4
Location
US
I'm looking to put together a VBA procedure that will loop through all xls files in a directory and determine if any macros exist. Is this possible?

Thanks!
 
Sort by date Sort by votes
I have a string array that contains the path and file name of each workbook in the directory.

So basically.. nothing.

Is there a way to determine if a workbook object contains a macro without opening it?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Question Question
Ecel Macros not working with V 2505
Replies
4
Views
174
remeng
remeng
remeng
  • Locked
  • Solved
Combine two working macros into one for MS Word
Replies
7
Views
2K
strongm
strongm
remeng
  • Locked
  • Question Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
1K
mikrom
mikrom
remeng
  • Locked
  • Question Question
If obsolete - deactivate all but one macro
Replies
6
Views
820
mintjulep
M
thanhthanh12
  • Locked
  • Question Question
How compare 2 macros in vba word
Replies
3
Views
589
mintjulep
M

Part and Inventory Search

Sponsor

Back
Top