Hi Skip,
I have tried the above with the code:
Dim oXL As Object
Dim oWB As Object
'instantiate the oXL Excel Application object
Set oXL = CreateObject("Excel.Application")
oXL.Visible = True
'instantiate the oWB Excel Workbook object
Set oWB =...
Hi Skip,
Not sure whether this will help but...
The Excel application opens with "- \\Remote" afterwards as show in the attachment. Maybe something extra needs to be added to the code to account for this?
Thanks...
Hi Skip,
I appreciate your help but it seems like we're still having no luck!
Unsure as to why this isn't working. I hope this isn't too much of a challenge!
Please find the attached screenshot.
Thanks...
Hi Skip,
I have tried the above and the sheet name is exactly the same, to the point of copying it over!
Unfortunately I cannot code my process in Excel VBA as the program, EXTRA! X-treme is opened via a remote desktop. For example, we run an application which opens a temporary remote...
Hello!
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")...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.