When i declare an enumerated type (Enum ... End enum) under VBA for office 97, an error occures. The language does not seem to know this keyword whereas VBA for office 2000 knows it. How can i do to make VBA knows this keyword ?

Thanx

Upgrade to Office 2000

____________________________
Eggheads unite! You have nothing to lose but your yolks.

I can't, this macro is made for some friends that are not under the same version of office (only 97 and 2000).

lol...sry...I guess that really wasnt that much help, eh?

I am not sure cause I don't have Office 97 (installed), how many Enum types are you declaring? you could try to use public variables to somehow take the place of the Enum types...


Just curious, have you run into any other compatibility issues with developing for both platforms?


____________________________
Eggheads unite! You have nothing to lose but your yolks.

I'm using the source code to menage the registry that is available at http://www.andreavb.com/tip080001.html.

it works properly under W2k and office 2k but not under office 97... whereas it is made for VB5-6, W95-98-NT...

I've tried creating some public const, but it really don't work !

Other macro run perfectly under the both platforms ! I've seen another source code ! I'll try this because it uses public const and not enum type !

Thanx

Oh...OK...I C...

We discussed the pros/cons of Office VBA in several other topics, I guess this is another con.

Another possible solution could be to put your registry functions, that wont work in VBA, in a DLL or EXE using VB5/6 (since we know this code will work there) and call it from your Office app...

____________________________
Eggheads unite! You have nothing to lose but your yolks.