Running Macro in Newly Saved file

[Dannyh1]

Hi,

I currently have a sheet where I trigger to run a macro in another workbook at a specific time. This currently works OK.

I need the same code to run with a slight variation.

I tried to Save As the workbook from where the code is ran:

From:

GETMIXERINFO.xls

To

GETMIXERINFO 2MNTHS.xls

I kept the names of the macro's the same, but when I come to trigger the code in GETMIXERINFO 2MNTHS.xls, it says:

The macro 'GETMIXERINFO 2MNTHS.xls!Run1st' cannot be found.

I can see the macro Run1st is definatley in the workbook GETMIXERINFO 2MNTHS.xls.

Advice appreciated!

Thanks.

 

[ravi4ever]

You should prefix and suffix ' (apostrophe) with the filename..

Application.Run ("'" & FileName & "'!MacroName1")

 

[Dannyh1]

I'm a tool! Thank you very much