Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How can I search for Excel files that contain VBA code, are there any efficient ways to do this?

The way I'm thinking of would be to use vbscript and recursively search through the directory, open the excel file, and then search for VBA code... is there a better way?

I'm searching alot of files and would like to maximize my efficiency.

Update:

Okay the Answer for this question is listed here at Stackoverflow

share|improve this question
    
Why not search for .xlsm files? –  soandos Aug 29 '12 at 19:50
    
You should have asked this at Stack OverFlow instead as you require a programming solution. –  brettdj Aug 29 '12 at 22:55
    
Yah it's Excel 2003 Files. –  Ben_Coding Aug 30 '12 at 17:19
    
See : siddharthrout.wordpress.com/2012/04/12/… –  Ben_Coding Aug 30 '12 at 17:25
1  
blog.stackoverflow.com/2011/07/… –  pnuts Sep 4 '12 at 3:33
show 1 more comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.