Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Inserting a reference / checking
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" wrote in message oups.com... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA - Inserting a reference / checking
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking formula type (reference to other worksheet or not) | Excel Discussion (Misc queries) | |||
Checking the existence of a reference workbook | Excel Programming | |||
Checking/Setting a reference on open | Excel Programming | |||
Checking time and inserting a value in a different cell | Excel Discussion (Misc queries) | |||
Disabling Circular Reference Checking | Excel Programming |