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 strongm 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
Feb 20, 2004
4
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
  • Locked
  • Solved
Combine two working macros into one for MS Word 1
Replies
7
Views
508
strongm
strongm
remeng
  • Locked
  • Question
Excel VBA to Pass Var between file macros after var changes
Replies
13
Views
297
mikrom
mikrom
remeng
  • Locked
  • Question
If obsolete - deactivate all but one macro
Replies
6
Views
191
mintjulep
M
thanhthanh12
  • Locked
  • Question
How compare 2 macros in vba word
Replies
3
Views
179
mintjulep
M
dgillz
  • Locked
  • Question
Back coloring an entire row if a duplicate is found in a dynamic range 1
Replies
18
Views
328
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top