General discussion

Locked

Test if an excel file contains macro

By bam86_be ·
I want to check the .xls files in our network to see who uses macro in excel. Is it a way to check an excel file for macro in a scripting environment ?

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by bschaettle In reply to Test if an excel file con ...

I would try looking at "ActiveWorkbook.VBProject" and it's associated properties.

Collapse -

by bam86_be In reply to

Poster rated this answer.

Collapse -

by bam86_be In reply to Test if an excel file con ...

This is working but... As I wanted to run it on a file server without Excel installed...
But I'll do it run from a desktop.
Thanks.

Collapse -

by bam86_be In reply to Test if an excel file con ...

This question was closed by the author

Back to Software Forum
4 total posts (Page 1 of 1)  

Related Discussions

Related Forums