View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default How to determin a Excel file has Macro

Hi

I have never seen code like that. But try opening a few small Excel files in
Notepad -there are some very distinct ascii words in files that contain macros. So maybe
this can be done, and if "lot of files" is a big lot then maybe it's worth the effort.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Winston Lee" wrote in message
...
Hi All:
I have a lot of Excel files. I hope to demarcate
the Excel files that have macro. Is there any tools or how
to program ?


Thanks
Best Regards