VBA - Inserting a reference / checking

[cheesey_toastie]

Hi

We have a spreadsheet with macros embedded we distribute to our
customers. Some of our users are not on the current version of Excel.
Short of using older VBA references for some object libraries is there
any way to query those available and insert the correct reference via a
macro (which we can run on opening the spreadsheet). Talking users
through the VBE interface is not an option!!

TIA

Cheesey

[Bob Phillips]

Develop your macros in the lowest version of Excel that the users will have,
and that will obviate any version problems.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cheesey_toastie" <[email protected]> wrote in message
news:[email protected]...
> Hi
>
> We have a spreadsheet with macros embedded we distribute to our
> customers. Some of our users are not on the current version of Excel.
> Short of using older VBA references for some object libraries is there
> any way to query those available and insert the correct reference via a
> macro (which we can run on opening the spreadsheet). Talking users
> through the VBE interface is not an option!!
>
> TIA
>
> Cheesey
>

[cheesey_toastie]

Bob you are of course completely correct! I was trying to avoid that.
I was just interested if it was possible to set the references via code
as I have a similar problem when exporting modules to other
spreadsheets.