Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macros in Excel 2002 Somewhere In Excel 2002 Excel Worksheet Functions 1 August 26th 07 12:16 PM
Excel 2000 to 2002 - #NAME? Paulo Freixieiro Excel Discussion (Misc queries) 6 September 7th 05 01:33 PM
Excel 2000 to 2002 - #NAME? Paulo Freixieiro Excel Discussion (Misc queries) 1 September 7th 05 01:12 AM
How do I update Excel 2000 macros to work in Excel 2002? BobPetrich Excel Discussion (Misc queries) 3 January 4th 05 04:06 PM
Excel 2000-2002 compability Chrissy[_4_] Excel Programming 5 August 3rd 03 04:24 AM


All times are GMT +1. The time now is 03:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"