Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.


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
1… – pnuts Sep 4 '12 at 3:33

You must log in to answer this question.

Browse other questions tagged .