LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.programming
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





 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Test if file exists Daniel Bonallack Excel Discussion (Misc queries) 2 May 4th 09 04:19 PM
How can I programmatically check in Excel 2002 if a sheet exists? RangerTom Excel Programming 2 March 13th 06 08:33 PM
How to test if a DLL (library) exists ExcelMonkey Excel Programming 2 August 7th 05 08:14 PM
How to test if an Excel spreadsheet exists in VBScript? JP Excel Programming 3 January 19th 05 09:45 PM
Excel VBA - How do I programmatically change source code in another file? Lisa Norgaard Excel Programming 1 July 14th 04 04:09 PM


All times are GMT +1. The time now is 10:17 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"