View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Patrick Molloy Patrick Molloy is offline
external usenet poster
 
Posts: 1,049
Default 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