rrenis
07-11-2007, 11:29 AM
Hi all - Can anyone please advise how to acheive the following please? I can run a macro contained within a sheet by using the following...
Run "'A Workbook.xls'!MyMacro"
Unfortunately I need to refer to the workbook as a String. So I would need something like...
Run "'myWorkbook'!MyMacro"
But this doesn't work :banghead:
Can anyone please help out?
Cheers,
rrenis
Run "'A Workbook.xls'!MyMacro"
Unfortunately I need to refer to the workbook as a String. So I would need something like...
Run "'myWorkbook'!MyMacro"
But this doesn't work :banghead:
Can anyone please help out?
Cheers,
rrenis