View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Paul Martin Paul Martin is offline
external usenet poster
 
Posts: 114
Default How to programmatically test whether VBA code exists in an Excel file

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