VBA - Inserting a reference / checking

C

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
 
B

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)
 
C

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top