Solved: Using a String to Run a Macro

[rrenis]

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

[VBA]Run "'A Workbook.xls'!MyMacro"[/VBA]

Unfortunately I need to refer to the workbook as a String. So I would need something like...

[VBA]Run "'myWorkbook'!MyMacro"[/VBA]

But this doesn't work

Can anyone please help out?

Cheers,
rrenis

[mvidas]

You can use the & symbol to concatenate strings, like
[vba]Application.Run "'" & myWorkbook & "'!MyMacro"[/vba]if myWorkbook is a workbook type variable, use myWorkbook.Name instead

[rrenis]

Thanks - not at work at the moment but I'll try it tomorrow and let you know how it goes!!

[rrenis]

Hi mvidas

Thanks for your help - just tried it and it works perfectly! Thank you.

Cheers,
rrenis