realitybend
07-11-2008, 01:14 PM
I need to run a macro in the from a workbook. The macro I need to run is in another workbook (The active workbook). However, I don't know its name. The things I know are that it's the active workbook, and that the macro's name is "Update_Graph".
Here's the code I experimented with, which obviously doesn't work because of the quotes.
Application.Run _
"'" & File.Name & "'!Update_Graph"
Here's the code I experimented with, which obviously doesn't work because of the quotes.
Application.Run _
"'" & File.Name & "'!Update_Graph"