Norman,

WorkbookMain = ActiveWorkbook.Name

This is in a module of the .XLA. Set_CCRF_Names is the macro name on Sheet13

Application.Run WorkbookMain & "!Sheet13.Set_CCRF_Names"


--
Trefor


"Norman Jones" wrote:

Hi Trefor,

Many thanks for the prompt reply. I have used this to run a macro from
an XLS to a macro in an XLA, but not the other way round, but
normally in a Module not a worksheet.

When I run this as you describe I get an error 1004 saying the macro
can not be found.

The suggested syntax works for me. Check that the workbook name is correct
and is not missing any spaces / does not include any extraneous spaces.

Note also that the suggested syntax wraps the workbook name in single
quotes. This is to allow for possible spaces in the name.

If the problem persists, paste the relevant code line in your response and
confiirm where the code is housed.


---
Regards,
Norman