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 2002/03 vba changelog

....does such a list of changes exist, particularly breaking changes?

Case in point is that the Value property for a Range was changed from
"plain" to "parameterized" (by XLRangeValueDataType) in recent Excel's, and
constructs like "obRange.Value(1, 1)" which worked in excel 97/2000 now fail
in 2002/2003 with a compile error because "(1, 1)" is now parsed as
parameters for the Value property instead of indexes into the Value array.

There are workarounds, of course, like using .Cells(1, 1).Value, or using
Value2 which hasn't changed in recent versions. Yet, as just an occasional
Excel user, I am still ticked off that an .xls which works fine in 97/2000
had to be changed many years after the fact in order to accommodate a
trivial, but compatibility-breaking, object change.

Worse, I have some other old .xls's and, short of such a "breaking changes
log" which I haven't found yet, I can't be sure what else may be broken - or
different - now. It was lucky in a sense that the Value change caused a
compile error in this case, which was relatively easy to track down. Should,
for example, Value be parameterized with two arguments in the next version
of Excel, the old code might well compile again, but do something entirely
bogus, and then _that_ would be funny to figure out.

Thanks,
Liviu


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
Excel 2002: How is the Excel 2007 file format open in Excel 2002 ? Mr. Low Excel Discussion (Misc queries) 2 August 29th 07 11:46 PM
Outlook 2002 calendar dates exported to Excel 2002 sort incorrectl scampbell Excel Worksheet Functions 0 February 22nd 06 06:31 PM
Access 2002 VB Module controlling Excel 2002 spreadsheet -Run-time Mblackmore Excel Programming 0 May 12th 05 07:56 PM
Can you print labels using Excel 2002 in a Word 2002 mail merge? Individual_ Excel Discussion (Misc queries) 3 December 17th 04 08:39 PM
Excel 2002 files attached to Outlook 2002 EMails change size AJStadlin Excel Programming 1 October 15th 03 12:12 AM


All times are GMT +1. The time now is 04:12 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"