| || |
Connecting to Excel
User Aidy Rutter (AidyR@TrustMarque.com) posted:
Trying to connect to excel through Robot
' Open up Excel
Set objExcel = CreateObject("Excel.Application")
Set objWorkBook = objExcel.Workbooks.Add
Set objWorkSheet = objWorkBook.WorkSheets("Sheet 1") rem: runtime
'Write the value to the cell
objWorkSheet.Range("A1").Value = 100000
I'm getting a run-time error (see above on the third line of code)
Can anyone please help me out here?
Re: Connecting to Excel
User Crunk John (ext3jpc) (firstname.lastname@example.org) posted:
Take the space out of the worksheet name, it should be Sheet1 with no space
and your code will work.