Call macro.bas macro

[Chrisjd2]

Hi,

Is there a way I can call a macro from a file.

I.e I've got a folder with all my macros saved as .bas. Now I want to create 1 macro within my excel spreadsheet that calls up these.

Something like this..

Sub Callup_Macro

Call "C:Main.bas"
Call "C:Main1.bas

End sub

Cheers
Chris

 

[RoryA]

You can only call macros that are stored in a workbook. You could use code to load the code into a workbook but it's much simpler to just store the code in a workbook in the first place.