Create new workbook and move the Macro without reference to old wb
 

I have a "model" workbook that I use to create a new workbook for each member
in an organization. The Model workbook has one macro that is used to
validate the input data that the members will compile. However, the macro
points to the original macro using a "D:\...." reference instead of just a
reference to "ValidateData" in the new workbook. How can I make sure that
the reference to the macro in the copied workbook just points to the
"ValidateData" macro in the newly created workbook and not the macro in the
original workbook?

Thanks for the help!
--
Steve

Create new workbook and move the Macro without reference to old wb
 

Various ways which depends on how you are calling the macro code,

try ThisWorkbook

or post code

--

Regards,
Nigel




"sbweid" wrote in message
...
I have a "model" workbook that I use to create a new workbook for each
member
in an organization. The Model workbook has one macro that is used to
validate the input data that the members will compile. However, the macro
points to the original macro using a "D:\...." reference instead of just a
reference to "ValidateData" in the new workbook. How can I make sure that
the reference to the macro in the copied workbook just points to the
"ValidateData" macro in the newly created workbook and not the macro in
the
original workbook?

Thanks for the help!
--
Steve