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

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

• nikm

  Public Sub MyBatch()

  Call Sub1

  Call NameOfSub2

  Call Sub3

  Call .....

  End Sub

  
  
  

• Marzullo

  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

  
  

• dsula

  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.

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