Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create Move Macro for Closed Workbook | Excel Discussion (Misc queries) | |||
Create a reference to a workbook which is already open | Excel Programming | |||
Create a macro to move info from one column to another | Excel Programming | |||
Create Macro - move selected rows to new spread sheet | Excel Programming | |||
Macro to move, create formulas and loop | Excel Programming |