Thread
:
Create new workbook and move the Macro without reference to old wb
View Single Post
#
2
Posted to microsoft.public.excel.programming
Nigel[_2_]
external usenet poster
Posts: 735
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
Reply With Quote
Nigel[_2_]
View Public Profile
Find all posts by Nigel[_2_]