Application.run

[J cs via OfficeKB.com]

Newbie question: I am trying to call a module within the current workbook but the following code is incorrect. I need to use activeworkbook.name becuase the file can be saved as a differenct filename and I don't want the macro to not run because the filename can't be found. I am guessing I am missing parenthesis or quotes somewhere.

Application.Run ActiveWorkbook.Name!CopyFromRow

Thanks in advance for the help.

 

[Don Guillett]

If your macro name is Joe then just use

call joe
or just
joe

--
Don Guillett
SalesAid Software
(e-mail address removed)

Newbie question: I am trying to call a module within the current workbook

but the following code is incorrect. I need to use activeworkbook.name
becuase the file can be saved as a differenct filename and I don't want the
macro to not run because the filename can't be found. I am guessing I am
missing parenthesis or quotes somewhere.

 

[J cs via OfficeKB.com]

So simple....thanks a bunch!

 

[Don Guillett]

glad to help