Application.run
 

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.

--
Message posted via http://www.officekb.com

If your macro name is Joe then just use

call joe
or just
joe

--
Don Guillett
SalesAid Software

"J cs via OfficeKB.com" wrote in message
...
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.

--
Message posted via http://www.officekb.com

So simple....thanks a bunch!

--
Message posted via http://www.officekb.com

glad to help

--
Don Guillett
SalesAid Software

"J cs via OfficeKB.com" wrote in message
...
So simple....thanks a bunch!

--
Message posted via http://www.officekb.com