Hamish_Crerar


Hi folks,

I've written several Subs on different worksheets in Excel but I'd like to set up a batch file to run them all.

Is there a command that allows a "stack" of subs to be run one after the after

I am sure there must be.

Beats me.

Hamish.




Re: Dear DMan1 could you just be a little more explicit about how I name the Sub1?

DMan1


Public Sub MyBatch()

Call Sub1

Call NameOfSub2

Call Sub3

Call .....

End Sub







Re: Dear DMan1 could you just be a little more explicit about how I name the Sub1?

Hamish_Crerar

Hi DMan1,

I am going to set up a Blank Excel Worksheet qnd in the VBA section I will write your code.

The macro wil have to include the names and locations of the files/workbooks and the names of the macros within them.

This is where I am a bit lost.

Lets say the workbook is C:\datafiles\process01 and at has a macro in it called SetUpFields01 then how does your code pan out.

The next file is 02 in the same location.

I appreciate your help. Thanks.

Hamish






Re: Dear DMan1 could you just be a little more explicit about how I name the Sub1?

magicalclick

I don't know exactly how this will work. But I would open up the workbook and copy the macro sheet to thisworkbook and then run the macro like thisworkbook.Application.Run("myMacroSheet.myMacro1")

Press F1 on Run to see other example and documentation.