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