VBA Macro Versions
 

I am rather new to using Excel macros, but I have recently made an Excel
sheet with a VBA macro in Excel 2003. Some of our network users are still on
2000 or 2002 versions of Excel. Therefore they received compile errors when
they try to use the macro. Is there any way to make this VBA macro work on
their versions? Is there some sort of controls update that they can do to
make this macro work, or is this macro going to only work on Excel 2003 and
there is nothing I can do about it?

Thanks for the assistance,
ACFalcon

VBA Macro Versions
 

You must write your code to work on the earliest version on which
it will run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ACFalcon" wrote in message
...
I am rather new to using Excel macros, but I have recently made
an Excel
sheet with a VBA macro in Excel 2003. Some of our network
users are still on
2000 or 2002 versions of Excel. Therefore they received
compile errors when
they try to use the macro. Is there any way to make this VBA
macro work on
their versions? Is there some sort of controls update that
they can do to
make this macro work, or is this macro going to only work on
Excel 2003 and
there is nothing I can do about it?

Thanks for the assistance,
ACFalcon

VBA Macro Versions
 

This does not always work as the underlying object model has changed. Is this
not your experience? (See post titled Code to different object models,
9/8/05).
--
John



"Chip Pearson" wrote:

You must write your code to work on the earliest version on which
it will run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ACFalcon" wrote in message
...
I am rather new to using Excel macros, but I have recently made
an Excel
sheet with a VBA macro in Excel 2003. Some of our network
users are still on
2000 or 2002 versions of Excel. Therefore they received
compile errors when
they try to use the macro. Is there any way to make this VBA
macro work on
their versions? Is there some sort of controls update that
they can do to
make this macro work, or is this macro going to only work on
Excel 2003 and
there is nothing I can do about it?

Thanks for the assistance,
ACFalcon

VBA Macro Versions
 

This seems atypical. Put up some sample code that works in xl2000 and
errors in xl2002.

--
Regards,
Tom Ogilvy

"Wboson" wrote in message
...
This does not always work as the underlying object model has changed. Is
this
not your experience? (See post titled Code to different object models,
9/8/05).
--
John



"Chip Pearson" wrote:

You must write your code to work on the earliest version on which
it will run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ACFalcon" wrote in message
...
I am rather new to using Excel macros, but I have recently made
an Excel
sheet with a VBA macro in Excel 2003. Some of our network
users are still on
2000 or 2002 versions of Excel. Therefore they received
compile errors when
they try to use the macro. Is there any way to make this VBA
macro work on
their versions? Is there some sort of controls update that
they can do to
make this macro work, or is this macro going to only work on
Excel 2003 and
there is nothing I can do about it?

Thanks for the assistance,
ACFalcon

VBA Macro Versions
 

I've not experienced code that works in an earlier version but
bombs in a later version. Can you provide some examples?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Wboson" wrote in message
...
This does not always work as the underlying object model has
changed. Is this
not your experience? (See post titled Code to different object
models,
9/8/05).
--
John



"Chip Pearson" wrote:

You must write your code to work on the earliest version on
which
it will run.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"ACFalcon" wrote in
message
...
I am rather new to using Excel macros, but I have recently
made
an Excel
sheet with a VBA macro in Excel 2003. Some of our network
users are still on
2000 or 2002 versions of Excel. Therefore they received
compile errors when
they try to use the macro. Is there any way to make this
VBA
macro work on
their versions? Is there some sort of controls update that
they can do to
make this macro work, or is this macro going to only work on
Excel 2003 and
there is nothing I can do about it?

Thanks for the assistance,
ACFalcon

VBA Macro Versions
 

IIRC, there was one transition (don't remember the versions involved) where a
VBA function that was written without a type declaration, so defaulted to
Variant, would not compile in the newer version -- had to add the "As Variant"
to the end of the function line, i.e.

Function XXX() 'in original version

had to be changed to

Function XXX() As Variant


On Fri, 9 Sep 2005 13:26:55 -0500, "Chip Pearson" wrote:

I've not experienced code that works in an earlier version but
bombs in a later version. Can you provide some examples?