Differences in References from 97 to XP

[Chris]

I need to know the difference between the Global
Declaration for variables in XP and 97 and the difference
in IsNull.

What do I use instead in XP?

Thanks for your help

-Chris

 

[Tim Ferguson]

I need to know the difference between the Global
Declaration for variables in XP and 97 and the difference
in IsNull.

I don't see any difference. What do you think has changed?

Tim F

 

[Chris]

-----Original Message-----


I don't see any difference. What do you think has changed?

Tim F

.

I am using an app called Office Converter and it does it
says Office XP does not recognize the words GLOBAL and
ISNULL which was written in 97

-Chris

 

[Tim Ferguson]

I am using an app called Office Converter and it does it
says Office XP does not recognize the words GLOBAL and
ISNULL which was written in 97

This code seems to do exactly what I expect in a module in Excel 2002,

Option Explicit

Global g_varAny As Variant

Public Sub Test()

If IsNull(g_varAny) Then g_varAny = 3

End Sub

It seems that the Global keyword has been superceded by Public but it still
works; and I can't think of what might be wrong with IsNull().

You might ask the supplier?

Tim F