Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
AJL AJL is offline
external usenet poster
 
Posts: 18
Default VBA problem going from Office 2000 to Office XP

I inheirited an Excel document that has VBA embedded in it. The document and
VBA scripts were created in Office 2000. We now use Office XP. When the
document is opened, a script runs that formats some of the cells in a few
worksheets. When I open the document in XP I get an error stating that there
were some format errors. If I save the document in XP and reopen it, the
error goes away. Can anyone explain why this happens? Is it possible that
the calculations being done in the document are no longer valid because of
upgrading to XP? Is there a way to get a list of what changed from 2000 to
XP (ie dll's moved, VBA libraries restructured, etc.)

Thank you in advance,

AJL
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
free pre-installed Office interfers with Office 2000 professional. Troyshill Excel Discussion (Misc queries) 1 July 20th 08 05:54 PM
Can I run setup Office 2003 for office 2000 installed? FramB100 Excel Worksheet Functions 1 July 16th 06 09:34 PM
Office 2000/Office 2003 Excel not printing landscape vise versa BAHTTEXT in English text Setting up and Configuration of Excel 1 April 17th 06 01:37 PM
HOW CAN I READ SPREADSHEETS CREATED BY OFFICE 2000 ON OFFICE 2003. BOLOMO3 Excel Worksheet Functions 1 March 31st 05 01:40 AM
Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003) Sage Solutions Group Excel Programming 0 August 20th 04 08:58 PM


All times are GMT +1. The time now is 04:24 PM.

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"