Recent content by SuperKoopa

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...