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.
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.