Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Excel files and Macro problems
Whenever I copy an Excel file and later try to use the Macro's. They always
point back to the original file and I get an error about opening the same file twice. Is there a way to program an update to the macros on the new file or to save the file without referrencing the original macro's file? Thanks, Jesse |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copying Excel files and Macro problems
If you are using macros across several workbooks, then it might be time to
consider putting the macros in an add-in. Or, until your code is fully debugged, put all of the macros into a blank workbook with a name similar to the main macro. Make sure that any toolbar or custom menu used to call (start execution of) the macros is attached to the new workbook, hide the workbook window, then save the workbook from the VBE (Visual Basic Editor). Delete the custom toolbar from the Excel toolbars area before re-opening the workbook with the macros in it, otherwise the existing toolbar buttons will still point to the original workbook with data and macros in it. You may have some editing work to do to make sure that your macros still reference the correct workbook when running. (Just a quick suggestion, without knowing more details.) -- Hope this helps, Bill wrote in message om... Whenever I copy an Excel file and later try to use the Macro's. They always point back to the original file and I get an error about opening the same file twice. Is there a way to program an update to the macros on the new file or to save the file without referrencing the original macro's file? Thanks, Jesse |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problems copying Large Amounts of Data in Excel 2007 | Excel Discussion (Misc queries) | |||
Copying Multiple files in one file Macro - Liz | New Users to Excel | |||
Problems when copying Excel into Word | Excel Discussion (Misc queries) | |||
Problems Copying Graphs from Excel to Word | Charts and Charting in Excel | |||
alignment problems when copying excel graphs to word | Excel Discussion (Misc queries) |