Hi Guys,

I'm looking for some help with regards to Excel Macros and Multiple Workbooks.


First of all I would like to know how I can record a Macro, and use it again and again on multiple workbooks, on multiple systems.

Basically I will be working on 20 workbooks on one PC, reformatting them (i.e. removing certain fields and replacing .'s with /'s) and thats it. I will then be going onto another PC with the same 20 workbooks and reformatting them.

I will be doing this across multiple locations so ideally would like to be able to save my macros on a USB Pen Drive and transport them around.



Secondly I would like to know how I can run the one macro on all 20 workbooks at the same time in a batch.




Your help will be much appreciated.

Thanks
Dave Hunter