Application.run

  • Thread starter Thread starter J cs via OfficeKB.com
  • Start date Start date
J

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.
 
If your macro name is Joe then just use

call joe
or just
joe

--
Don Guillett
SalesAid Software
(e-mail address removed)
J cs via OfficeKB.com said:
Newbie question: I am trying to call a module within the current workbook
Click to expand...
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.
 
Back
Top