Search results for query: *

That was it! It works perfect. You're the man Skip. Thanks for the help, I couldn't have done it myself.

Honestly, because I dont know how to yet. I will have to research it. Thank you for the tip.

With does exist in Extra. Unfortunately, I tried that code earlier, and again now, and there is still a syntax error.

It says "WITH syntax error" on the first line, "syntax error" on the next 3 lines, and "illegal statement" on End With.

No luck, and I tried with it just about every combination of parentheses, quotes, brackets and spaces. Still a syntax error.

Thanks for helping me out Skip, Here are a few things that I have tried and the errors received. "No such property or method" line ".Offset(0,0)..." StartLine = Sess0.Screen.GetString (4,19,9) Middle = Sess0.Screen.GetString (4,31,2) FinishLine = Sess0.Screen.GetString...

Its just a working code. I keep testing everything I can think of. ' Send info to Excel Dim xlApp As Object, xlSheet As Object Set xlApp = Getobject("C:\Users\jay3120\Desktop\Excel Test.xlsx") Set xlSheet = xlApp.activesheet StartLine =...

Do you think I might have to Activate the Window or Sheet first in order to get .ActiveCell to work? If so, how would I do this?

I receive a syntax error when I try that. I have found out that .Offset does work though. I also combined that with .Select successfully which will solve my last step of selecting the next row. xlSheet.Cells(5303, "A").Offset(1).Select Now I just need something like .ActiveCell that will...

Thank you for your response Skip, Unfortunately, The much larger portion of the macro is already in Attachmate VB rather than Excel VB, so I'm stickin with Attachmate. Yes the StartLine, Middle, and FinishLine are always in the same row/column. I am simply taking 3 pieces of data from a single...

Hello, I am running a macro in Attachmate Extra that has a small part where it needs to send 3 pieces of data to an Excel spreadsheet. I have successfully created code to send the data to the already open Excel file. The problem I am running into is that I need to send the info to the currently...