S
stringrazor
I need to inventory all MS Office files (DOC, XLS, etc - different
versions, whatever is out there) and determine which have embedded
macros as a prelude to a large-scale workstation upgrade to XP & Office
2003 SP1 (and determining the impact of the upgrade on the critical
macro applications). Is there a way from a WSH Script (has to run on NT
- the pre-upgrade OS) to tell if an Office file contains a macro? I
found the DSO info and sample DSOFILE VB.NET app as well as a TechNet
article that seems to suggest I can access the DSO object from a WSH
VBScript. When load a simple XLS containing both a recorded macro and
VBA script into the DSO sample app, I see a bunch of document
properties but nothing like "hasmacro=1". Does such a property exist
and can it be accessed via WSH VBScript?
versions, whatever is out there) and determine which have embedded
macros as a prelude to a large-scale workstation upgrade to XP & Office
2003 SP1 (and determining the impact of the upgrade on the critical
macro applications). Is there a way from a WSH Script (has to run on NT
- the pre-upgrade OS) to tell if an Office file contains a macro? I
found the DSO info and sample DSOFILE VB.NET app as well as a TechNet
article that seems to suggest I can access the DSO object from a WSH
VBScript. When load a simple XLS containing both a recorded macro and
VBA script into the DSO sample app, I see a bunch of document
properties but nothing like "hasmacro=1". Does such a property exist
and can it be accessed via WSH VBScript?