Filenames with spaces and macro's

[RyanD]

I'm trying to run a macro located in a different workbook. The name of the workbook has spaces in it.

I am using the code:

Application.Run(ActiveWorkbook.Name & "!MacroName")

The code works if i take the spaces out of the workbook filename. How do i make it work with the spaces still there?

Thanks,

Ryan

 

[Juan Pablo González]

Maybe use the ' character before and after the ActiveWorkbook.Name. That should "tell" Excel that the name has spaces.

 

[Juan Pablo González]

Now that I think of it, why are you using Application.Run to run macros that are inside the Active workbook ?

 

[RyanD]

I have 2 workbooks (a) and (b).

My VB code is in (a), however, (b) is currently the ActiveWorkBook. I need to run a macro in Module1 of workbook (b). I am using:

ActiveWorkbook.Application.Run("MacroName")
also tried
ActiveWorkbook.Application.Run("Module1.MacroName")

but this doesn't work. What is the right code to run the macro?

Thanks,

Ryan