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.
Skip,
FIGS PH 00000000000 AMOUNT HISTORY 11-26-12
NAME J SMITh INV-LN xxx-xxx-xxxxxxxxx DUE 08-15-09 TYPE 19
BR 18 MAN A P-TYPE 0 INT .0176000 FIRST PB xxx,xxx.xx 2ND PB .00
HUD .00 NET 2095.95 SF .00000000...
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...
Good Afternoon!
Here's what I'm trying to accomplish:
There is an Attachmate screen with 5 columns of data on each page. There are several pages navigated to using F8. Each colomn of data has several rows of data that must remain in line. Example:
12/12/12
11/15/11
123
00.
YES
447.24...
...
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!
Hello, I am hoping to get some help on a report Im trying to generate from Attachmate. I need a macro to navigate to enter an account number based off of cell A1 on the active workbook (Sheet1), then naviagte a screen (GEM1, check to see if a specific entry code (Z12) exists in location (10, 20...
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.