DIFFERENCE EXCEL 97 VB and VBA in LATER VERSIONS

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Keebellah

Hans
Thread Starter
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
:rolleyes:
Does anyboy have a list of non-supported commands of vb(a) code?
The reason I ask this is that I have a series of Excel sheets with quite a lot of VBA code which I know is Not supported in excel 97.
The sollution is simple, have the people upgrade but, it's not that simple for them so I want to use my sheets in Excel 97.
Most macro's run without a hitch but I want to write relevant error code with version checking to avoid error screens and halted macro code.
Anybody a list?

Thanks (y)
 
Joined
Sep 4, 2003
Messages
4,916
Can you provide some code sample that don't work in the earlier versions?

Regards,
Rollin
 
Joined
Oct 26, 2005
Messages
354
VBA for XL 97 (and Mac versions of XL) is based on VB5, whereas 2000 to 2003 VBA is based on VB6.

Some (or all) aspects of ActiveX will be missing, as well as some Pivot Table support. There's more, but I don't have time to examine all of them. :)
 

Keebellah

Hans
Thread Starter
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
Hi Rollin,
I'll be logging into the system where Excel 97 is being used this weekend. I'll make a screen shot of the error en attach the module (code), myabe the whole sheet with code but I'll have to clear some data.
I'll be getting back 'round Sunday
 
Joined
Jul 25, 2004
Messages
5,458
We'd really need to see the code. :) you should develop your applications in the lowest version which will be used by your users.

sent via mobile. :)
 

Keebellah

Hans
Thread Starter
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
Firefytr,
I'll get the code ready to send by Sunday, well, I agree if I was developping something for them in particular, the thing is I had this ready for our own team and the other party liked it so that's why I want to see which part of the code is not "understood" by Excel 97, I checked th addins in Excel as well as the object libs in the VBA module but that seems to be Ok.
Code follows asap.
 

Keebellah

Hans
Thread Starter
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
Firefytr,
Well, I solved the problem. The formula I used was xl1 = round(lastrow/200,0) and that was it.
Excel 97 did not recognize round(value,0) as a valid function but did accept Worksheet.function.round(value,0)
I don't know if this is due to Excel 2000 and up and non existen in 97 but that was the issue.
That's why I didn't send the code.
Thanks for giving it your attention.
 

Keebellah

Hans
Thread Starter
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
It's solved I forgot to add solved when I posted my reply.
(y)
 
Joined
Jul 25, 2004
Messages
5,458
With Excel 97 being based on VB5, those types of functions were not part of the Application object, or could not be assumed to be. So using the WorksheetFunction object is generally the better way to go with something like that. Glad it was fairly simple! :)
 

Keebellah

Hans
Thread Starter
Trusted Advisor
Joined
Mar 27, 2008
Messages
6,639
Thanks Zack, that's what you get when you learn by doing and not by book.
I'll keep the offer in mind and will send you my sheet soon.
Just trying to fill it with some data and translate the messages to English.
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Members online

Top