When i use Early Bound setup on my Office 2003 and move
the VBA to the Client's system - using Office XP, the
Excel 11.0 Object Library does not change to Excel 10.0
(which is on their PC).

Q - I understand that this is to do with setting up Late
Bound - by why does Word work fine amd Excel not?

Q - I have in the Declarations:
Private oXL as Object
Private oWB as Object
Private oWS as Object

then... ' Create Excel Objects
Set oXL = CreateObject("Excel.Application")
Set oWB = CreateObject("Excel.Workbook")
Set oWS = CreateObject("Excel.Worksheet")

but it stops with an Active-X error on the second Set.
Why?

Q - using the above, is it going to create a new instance
of Excel each time?

....thanks