I have a working macro that does stuff to a file, saves and then closes it. The macro is saved in my PERSONAL excel file, so it can be run on any excel file. Can somebody show me another macro or some other way to execute my existing macro on every file in a folder instead of having to manually execute it for each individual file?
Something like "For each file file in MyFolder, run MyMacro"
What is a Form List Box? (skip if you know this)
The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm),
I will briefly cover:
1) An overvie…