How to programmatically test whether VBA code exists in an Excel file
Paul,
The "property" only exists because Excel (or some app that understands
Excel's file format) reads the binary and checks those records.
Unless you do this yourself (or one of the other suggestion in that thread),
you have to leave it to Excel to do the hard work, then work through Excel.
NickHK
"Paul Martin" wrote in message
oups.com...
Hi Nick
If not through VBA, do you have any idea by what means I can access
this property?
Regards
Paul
NickHK wrote:
Paul,
Yes. If you want to test a couple of bytes for the presence of VBA code,
you'll need to understand how Excel reads/writes such information in its
format.
Good luck.
NickHK
"Paul Martin" wrote in message
ups.com...
Hi Nick
I'm not sure I understand your reply. Are you referring to reading
the
Open Source PDF?
Regards
Paul
NickHK wrote:
Paul,
Unless you read through the Excel file format and understand where
such
VBA
records are, you are stuck with the suggestions in that thread.
Anyone else can come up with a different approach....
NickHK
|