ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Need to scan xls files and identify if they use macros...wanna use (https://www.excelbanter.com/excel-programming/365125-re-need-scan-xls-files-identify-if-they-use-macros-wanna-use.html)

martin1

Need to scan xls files and identify if they use macros...wanna use
 
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.




martin1

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.





All times are GMT +1. The time now is 04:01 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com