View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
cheesey_toastie cheesey_toastie is offline
external usenet poster
 
Posts: 20
Default VBA - Inserting a reference / checking

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