HiTek Software Home
 
Title Can not run excel macro created in Personal Macro Workbook
Date Updated 09/26/2001
Versions affected 4.0 and later
OS affected All
Description User tries to run an excel macro which is saved in the personal macro workbook.  Following message is received:
The macro 'macroname' cannot be found.
Causes Macro cannot be found in workbook.  A macro created in the Personal Macro Workbook has to be referenced using:
personal.xls!macroname
Solution Example: 
Your personal workbook macro name is 'test'.  
In the Automize Excel Dialog, for the macro name enter:
personal.xls!test
Output Log none
Debug Log

-