View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default 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