Thread: Need to scan xls files and identify if they use macros...wanna use
View Single Post
  #2   Report Post  
Posted to microsoft.public.vb.com,microsoft.public.vb.database,microsoft.public.excel.misc,microsoft.public.excel.programming
martin1 martin1 is offline
external usenet poster
  
Posts: 2
Default Need to scan xls files and identify if they use macros...wanna
I figure out how.
Sorry

martin

"martin1" wrote:

sorry for not answer this question.

I want to post new question, can yuo tell me where to post new question? i
follow these 3 steps and still don't know where to post question.

Thanks,


"Jim Hicks" wrote:

I was given a project to scan all of the Excel files on our network and
generate a report listing the
files and wether they use Macros. I was thinking of using VB6 to scann all
dirs/subdirs...easy part.
Question: -- How do I quickly scan an excel file and determine if it
has/uses Macros using VB6.
I appreciate you taking the time to read this and any help anybody can
provide. Thanks.



Reply With QuoteReply With Quote