View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Donald Hohler Donald Hohler is offline
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.