MIssing References
Set oXL = CreateObject("Excel.Application")
Set oWB = oXL.Workbooks. Add
Set oWS = oWB.Activesheet
'or
Set oWS = oWB.Worksheets.Add
Patrick Molloy
Microsoft Excel MVP
"RJ" wrote in message
...
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 set as Object
then... ' Create Excel Objects
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
|