Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. SuperKoopa

    Attachmate Session/Scratch Pad Interaction

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

    Search entire row for specified text

    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!
  3. SuperKoopa

    Search entire row for specified text

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

    Pull a Segment of HTML Body Text

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

    Pull a Segment of HTML Body Text

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

    Pull a Segment of HTML Body Text

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

    Extract Several Columns of Data to Excel

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

    Extract Several Columns of Data to Excel

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

    Extract Several Columns of Data to Excel

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

    Extract Several Columns of Data to Excel

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

    Extract Several Columns of Data to Excel

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

    Extract Several Columns of Data to Excel

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

    Pull a Segment of HTML Body Text

    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)...
  14. SuperKoopa

    Pull a Segment of HTML Body Text

    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]
  15. SuperKoopa

    Pull a Segment of HTML Body Text

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

    Extract Several Columns of Data to Excel

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

    Attachmate Data Validation

    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!
  18. SuperKoopa

    Attachmate Data Validation

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

    Excel VBA: Open Attachmate Session if not already open

    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!
  20. SuperKoopa

    Excel VBA: Open Attachmate Session if not already open

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

Part and Inventory Search

Back
Top