I have developed a spreadsheet in Excel 2003 which attaches to an analysis
services cube, using the analysis services add-in function "cubecellvalue"
plus appropriate mdx statements to build the sheet in the format required.

However in Excel 2007 this only works if I alter the sheet to use the
built-in function "cubevalue", which then does not work in Excel 2003.

My problem is that I have users who need to share spreadsheets, and they are
using a mixture of versions. Do you think it is possible for me to create
and distribute a function of my own called "cubevalue" in Excel 2003 which
would then make the sheets compatible with Excel 2007 ? Or does Microsoft
have a compatibility aid that I am not aware of which would avoid this
problem ?

Suggest change

> If Excel.Version > 12 Then

to

If Val(Application.Version) >= 12 Then

Regards,
Peter T

"Mike Fogleman" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Perhaps check the version number of Excel to set-up the sheet and run the
> appropriate code with logic like this:
>
> If Excel.Version > 12 Then
> alter sheet to run built-in cube
> Else
> run add-in cube
> End If
>
> Mike F
> "Quiller38" <(E-Mail Removed)> wrote in message
> news:FF49CA99-AAE8-4339-8073-(E-Mail Removed)...
> >I have developed a spreadsheet in Excel 2003 which attaches to an
analysis
> > services cube, using the analysis services add-in function
"cubecellvalue"
> > plus appropriate mdx statements to build the sheet in the format
required.
> >
> > However in Excel 2007 this only works if I alter the sheet to use the
> > built-in function "cubevalue", which then does not work in Excel 2003.
> >
> > My problem is that I have users who need to share spreadsheets, and they
> > are
> > using a mixture of versions. Do you think it is possible for me to
create
> > and distribute a function of my own called "cubevalue" in Excel 2003
which
> > would then make the sheets compatible with Excel 2007 ? Or does
Microsoft
> > have a compatibility aid that I am not aware of which would avoid this
> > problem ?
>
>

Okay thanks chaps, I will go down the route of testing for version and then
use a macro to change the formulas depending on which version it is in.