Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Macros from 2000 to XP 2002
I have a question and a problem concerning macros in
conversion from Excel 2000 into Excel XP 2002. The macros worked fine in Excel 2000 and for the most part most of my macros are working perfectly with the exception of one set of macros. I receive the error message of: run time error '-2147417878 (80010108)': Method 'Close' of object 'Window' failed. The VBA debugger is pointing to a line of code highlighted in yellow as follows: Activewindow.Close savechanges:=False It appears that in the old Excel 2000 when more than one file was open it appeared that only one Microsoft Excel block appears on the task bar. In Excel XP when more than one file is open it creates another Excel block in the task bar window unless there is not enough room then you will see 7 Microsoft Excel with a drop down arrow if there are seven files open at the same time. But if only two files are open you will see two Excel blocks. The macro is running from one file which opens up another file to then copy and paste special add to the file that the macro is running from. The active window should be the file that the macro opened and it seems that the macro is not recognizing this command. Is there any facility to convert macros from Excel 2000 into the current VBA code in Excel XP 2002? It would be helpful that if there are some lines of code that are not longer consistent that there is some type of conversion that can be done. Please help. Best regards, Don H. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macros in Excel 2002 | Excel Worksheet Functions | |||
Excel 2000 to 2002 - #NAME? | Excel Discussion (Misc queries) | |||
Excel 2000 to 2002 - #NAME? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) | |||
Excel 2000-2002 compability | Excel Programming |