Good Morning,
I'm familiar with copying a selection from a session to external programs, but I was curious to know if anyone would know how to copy a selection (or a fixed area) to the attachmate scratch pad using a macro.
Example: Lets say I need (18,50, 10) copied for the next 3 pages...
Hey Skip thank you very much! That works perfectly! Do you know how I can account for when the text doesn't exist? I thought maybe I coulda just put an Else ActiveSheet.Range("A1") = "No" statement. Sorry! As always I appreciate your help!
Hello Tek-Tips!
I've learned so much here, its been really great! I had what hopefully is a quick question.
So I several attachmate screens full of paragraphs of text. This text may or may not contain a certain value. I need each row ( rows 3 to 22) to be "scanned" for this text which is...
Would you happen to know hot to account for the situation of the "NAME" doesnt exist in the HTML code?
(Here's the code again):
CaseInf = appIE.document.Body.innerHTML
FName = InStr(1, CaseInf, "NAME</B></I><BR><B>")
iStart = InStr(FName, CaseInf, "<B>") + 3
iLength = InStr(iStart, CaseInf...
Okay I got it!
I had to adjust a few things but I've tested it with names of different lengths and its rendering the results perectly based off of your code. Here's the code:
CaseInf = appIE.document.Body.innerHTML
FName = InStr(1, CaseInf, "NAME</B></I><BR><B>")
iStart = InStr(FName, CaseInf...
Sorry for the delay, super busy lately on other projects. As for this issue unfortunately it hasn't but we're getting closer. I know it can't be easy without having all the info in front of you so I appreciate your patience.
So we are getting feedback from the site, however it includes HTML...
Would you happen to know how to have the column in the range automatically move to the next excel column as attachmate columns are extracted until there is no more data? Similar to the one for the rows, rw = rw + 1? I'm not sure how to do this...
Ahhh! Thank you! So now I have the 1st column formatting properly. After text to columns it takes up excel columns A-E, which is perfect. Now the next column in Attachmate gets placed in F, which is great, but it wont do text to columns since I don't know how to account for the 'next' column in...
Yeah sorry, I was already in the process of typing by the time you had responded. Had no idea of your request until I had submitted. But as you request sir, the actual screen itself. Understandably, the format is the same, but confidential information redacted.
GOODNESS! That didn't format at ALL like I typed it.
So on this particular screen there are 5 columns of data with 15 rows. Each of these columns appear on a fixed area of the page and each row in each column contains 13 spaces of data or reserved space for data. So they would be positioned...
So on this particular screen there are 5 columns of data with 15 rows. Each of these columns appear on a fixed area of the page and each row in each column contains 13 spaces of data or reserved space for data. So they would be positioned like this:
POSITION ON PAGE:'Column 1...
Thank you guys for your assistance.
I've tried severeal variations of the starting point provided but was unable to produce any text from the source. The character that is produced with the sample code provided results in a symbol that is equivilent to the websites "BREAK" (or RETURN)...
Thanks for your response PH,
Inevitably a silly question: What would I Dim iStart and iLength As?
I'm not a saavy with all this as I like to think. [glasses]
Hello there,
I am trying to pull specific lines of data from the body text of a secured website. I've done some tinkering and have just one issue that hopefully there are many ways to resolve and perhaps someone can help me.
So, the snippet of source code looks like this:
<TD vAlign=top...
...objWorkBook = objExcel.ActiveWorkbook
'THE CODE ABOVE IS JUST WHAT I COPY/PASTE TO USE WHEN TESTING A SNIPPET OF CODE FROM A BROADER PROJECT
'***************
'PULL FIGURES
'***************
With objWorkBook.Sheets("Sheet1")
acol = .Cells(, "A").Column
Do
lRow = .Cells(4, acol) + 4
For...
Amazing! Thank you very much for your help. I feel like I'm learning more and more as I go. I had to scrap this project so I was unable to test it, but I've taken several of you suggestions and applied them elsewhere and improved other projects. Thank you Skip!
...I got frustrated and now Im left with the code below that doesnt do anything. Please help if you can, I really appreciate it. Thank you1
**********************************************************************************************************...
Thanks for the quick reply, and I hate to trouble you futher, but how would I plug that into what I already have? I appreciate your guidance, you're pretty much a genius!
Hello,
I have yet another question for a different situation. I would like to create a button in excel that opens an an Attachmate Session and then sendkeys, however, if a session is already open I would like it just to bring that existing Attachmate session forward as the active window. Right...
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.