I have installed the ms PIA for ofc XP, and followed the article
http://support.microsoft.com/kb/247412/
trying to paste into a worksheet
However I got late binding not allowed errors
....
webOCWraooer,Co py // get the desired data into clapboard
'Create a new workbook in Excel
Dim oExcel As Object
Dim oBook As Object
Set oExcel = CreateObject("E xcel.Applicatio n")
Set oBook = oExcel.Workbook s.Add ' < option strict on disallows late
binding>
'Paste the data
oBook.Worksheet s(1).Range("A1" ).Select ' < option strict on disallows
late binding>
oBook.Worksheet s(1).Paste ' < option strict on disallows late binding>
so I tried
....
Dim oExcel As Excel.Applicati on
Dim oBook As Excel.Workbook
oExcel = New Excel.Applicati on
oBook = oExcel.Workbook s.Add ' so far so good
'Paste the data
oBook.Worksheet s(1).Range("A1" ).Select() ' oops late binding
error
oBook.Worksheet s(1).Paste() ' same as above
How do get around the last two?
I tried
oSheet As Excel.Worksheet s
Dim oRange As Excel.Range
oSheet = oBook.ActiveShe ets(1)
but that did not help
please Help