If we set a reference to say an Office 10 object library and then
distribute the application,

(1) is the reference a property of our machine or our workbook ?,
(2) Do our customers have to set the same reference for our Excel app
to work ?
(3) is there any way of setting the reference programmatically ?

TIA Charles

1. Workbook
2. You set it once for the workbook. It stays with the workbook. Just make
sure the referenced library has been installed on the target machine.
3. Yes, check my web site for an example: "Add Reference"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Charles Jordan" wrote in message
om...
If we set a reference to say an Office 10 object library and then
distribute the application,

(1) is the reference a property of our machine or our workbook ?,
(2) Do our customers have to set the same reference for our Excel app
to work ?
(3) is there any way of setting the reference programmatically ?

TIA Charles

"Rob van Gelder" wrote in message ...
1. Workbook
2. You set it once for the workbook. It stays with the workbook. Just make
sure the referenced library has been installed on the target machine.
3. Yes, check my web site for an example: "Add Reference"

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"Charles Jordan" wrote in message
om...
If we set a reference to say an Office 10 object library and then
distribute the application,

(1) is the reference a property of our machine or our workbook ?,
(2) Do our customers have to set the same reference for our Excel app
to work ?
(3) is there any way of setting the reference programmatically ?

TIA Charles

Thanks Rob, but if some one unknown to us in Taipeh is buying our
software, how do we "Just make sure the referenced library has been
installed on the target machine" ....?. What instructions do we give
him ? We do tell him to:

(A)install Excel and then
(B) install our software (which *does* include the
code

AddIns("XBaddin").Installed = True
Thanks Charles