Application.run does not work !!!!

[KoolYute]

EXCEL 2003
WINDOWS XP SP2
---------------------


Hi,

I am trying to run a macro in another workbook using variable name but it will not work.
Works when I specify the fie name but I have 25 files so the variable would help.


Here is a sample:
The first one works with the full name but the second will not work.

1. Application.Run ("'Smith John - Call Adherence Reporting 2013_SD.xls'!Master_Module")
2. Application.Run (Wb2.Name & "!" & ".Master_Module")

Thanks in advance,

BJ.

 

[Norie]

Are you sure Wb2.Name is returning what you need?

 

[daverunt]

Hi,

This may just be a typo for this post or your problem.
There's a full stop in front of .Master_Module on the second.

Other than that I can only think it is path related.

Application.Run (Wb2.Name & "!" & "[COLOR=#ff0000].[/COLOR]Master_Module")

 

[RoryA]

You need:

Application.Run "'" & Wb2.Name & "'!Master_Module"

if you may have spaces in the file name.