Loading .bas files and running macro

[JoeS01]

I have a number of workbooks that I wish to run using the same macro stored in c:\temp\myMacro.bas

Is it possible with VBA code to insert a new macro , import the .bas file for the macro, and then run the macro for each of the workbooks?

I have tried recording this process, without any luck.

All suggestions greatly appreciated

 

[tactps]

If you put the macro into your personal workbook, you can run it on any file (as long as it is working on "activeworkbook".

 

[JoeS01]

Thanks for this quick response, tactps. I am not sure what you mean.
what is a personal workbook?

Can you please give me some more details on how to set it up?
Each of the workbooks I wish to run will be a single worksheet of data initially, and the macro adds additional worksheets containing the results

 

[tactps]

From the Tools menu, choose "Macro", and "Record Macro".
In the drop-down list, choose "Personal Macro Workbook".
Click on OK, and then stop recording.

This will create a personal macro if you don't have any.

Press Alt-F11 to bring up VBA.
In the left pane, choose "VBA Project (Personal.xls)"
Then double-click on module1.

Import your macro.
Exit Excel.

When you next open Excel, the personal macro will be available.

 

[JoeS01]

Excellent - many thanks for this tactps - works very nicley. Previously I was importing my macro to every file I needed processing, then running each sequentially. Keeping track of changes to the macro was a nightmare.

This way, I only need the one macro - goes like a train now

 

[tactps]

Yep - it's a good tip. I have stacks of them.

Cheers