I am trying to extract data from an Excel document through to my EXTRA! X-treme application (to put in an array and run through a loop).
I currently have the code:
Dim obj as object Dim objWorkbook as object Set obj = CreateObject("Excel.Application") obj.visible = True obj.workbooks.open "F:\actuarial\Shared\Product_Support\ALBA\Incident_1840\Testing.xls" obj.WorkSheets("Testing").Cells(15,"A").Value = 10
Which I have effectively copied from other posts on this forum.
My code opens Excel and the desired file correctly however fails on the final line due to an "Object Error". The Excel document only has 1 tab named "Testing". The only thing I can think of is that my EXTRA! X-treme application is opened via a remote desktop.
Any help would be greatly appreciated!