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.