Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros incompatible for different versions?
Hello all!
A quick qn. I have Excel 2003 in my PC and I built menu bars, with toolbar attached to the menu bars, in a certain workbook. The toolbars are in turn assigned to specific macros. (some of thes macros were recorded in personal.xls). I copied the workbook (along with the personal.xls, which stores som macros as mentioned above) and the *.xlb file from my PC to a second P that has Excel 2002 loaded in it. Here is where I copied the personal.xls and the Excel11.xlb file to i the new PC . C:\Documents and Settings\aiyer\Applicatio Data\Microsoft\Excel\XLSTART But now when I try to execute the macros in the new PC, I am getting message 'multiple personal.xls files are open'. There is only one personal.xls file (copied from my PC) in the new P and it is still giving me the error. The same thing I tried in another PC, where Excel 2003 is loaded and i works just fine. (I have Excel 2003 in my PC as mentioned earlier). Am I missing anything here? Would appreciate your help guys. Thanks a bunch. Regds, Arun. Vtec corp -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macros incompatible for different versions?
When you set up a menu or toolbar buttons to execute code, the full name and
path of the workbook containing that code is part of the macro's "name". Sounds like the path to the personal.xls file is different on the new system than the old. You'll have to get the file open, then see if Edit/Links, and point to the new personal.xls file will work. (I don't know if it will or not.) If not, you'll have to get into the customize mode for the toolbar, right-click on each of the controls that call your subs, then Assign Macro, and change the path&name of the macro to point to the new location. On Tue, 17 Aug 2004 17:15:20 -0500, aiyer wrote: Hello all! A quick qn. I have Excel 2003 in my PC and I built menu bars, with toolbars attached to the menu bars, in a certain workbook. The toolbars are in turn assigned to specific macros. (some of these macros were recorded in personal.xls). I copied the workbook (along with the personal.xls, which stores some macros as mentioned above) and the *.xlb file from my PC to a second PC that has Excel 2002 loaded in it. Here is where I copied the personal.xls and the Excel11.xlb file to in the new PC . C:\Documents and Settings\aiyer\Application Data\Microsoft\Excel\XLSTART But now when I try to execute the macros in the new PC, I am getting a message 'multiple personal.xls files are open'. There is only one personal.xls file (copied from my PC) in the new PC and it is still giving me the error. The same thing I tried in another PC, where Excel 2003 is loaded and it works just fine. (I have Excel 2003 in my PC as mentioned earlier). Am I missing anything here? Would appreciate your help guys. Thanks a bunch. Regds, Arun. Vtec corp. --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incompatible "allow users to edit range" in earlier Excel versions | Excel Discussion (Misc queries) | |||
Macros incompatible for different versions? | Excel Programming | |||
Macros incompatible for different versions? | Excel Programming | |||
How to make the macros work for different Excel versions? | Excel Programming | |||
Macros not working in different versions! | Excel Programming |