Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Differences from older versions of EXCEL/VBA

  Asked By: Leona    Date: Nov 18    Category: MS Office    Views: 772
  

Does anyone maintain a list of differences between various versions
of EXCEL? For example, is there a list of VBA functions in Excel
2003 that won't work on Excel 97?

At the request of a couple of users, I just took an application of
mine and made it work in Excel 97. Here are three of the things I
had to do:

1. Excel 97 does not have the ROUND() function in VBA. I replaced
ROUND() with INT(), and looked at the remainder to see whether I
needed to round up.

2. I use a button to create a COMMENT on a sheet. The COMMENT
overlaps a chart. The default in Excel 97 seems to be that the
chart covers the COMMENT. (the default in later versions seems to
be that the COMMENT covers the chart.) I had to explicitly move the
COMMENT to the front.

3. Excel 97 doesn't allow several of the PasteSpecial options. I
had to use simpler choices and then adjust.

If there is a maintained list anywhere, I'd be glad to contribute to
it.

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on Differences from older versions of EXCEL/VBA Or get search suggestion and latest updates.




Tagged: