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!

  • Congratulations strongm 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. link99sbc

    sort by matching column

    I have a spreedsheet with data in 7500 Rows and columns A-M I want to sort it by matching col C and D. In other words if C and D match move the row to the top. If they don't match, move the row to the bottom.
  2. link99sbc

    Can screen scraping be done on a web screen?

    I don't think so. It's like a regular web site. I tried to use the mouse to copy something and when I right click the mouse it just says Silverlite. No menu pops up. It's a secure site and you have to log in and has several screens to go through before you find the one you want. This is...
  3. link99sbc

    How to copy from one session, paste in another

    Here is an example ' Global variable declarations Global g_HostSettleTime% Global g_szPassword$ Sub Main() '-------------------------------------------------------------------------------- ' Get the main system object Dim Sessions As Object Dim System As Object Set System =...
  4. link99sbc

    Can screen scraping be done on a web screen?

    We are linked to another departments terminal to retrieve data. They are going to a new web based system. I don't know if macros can work on a web site. Any ideas?
  5. link99sbc

    Compile error on End Sub

    Thanks for the help Skip This only works in attachmate! When you copy something, it is put in a buffer. When you copyappend, it is added to the buffer as a seperate item. If I copy something then copyappend 3 more items, I have 4 items in the buffer. Then I paste the first item, then...
  6. link99sbc

    Compile error on End Sub

    Quote: from 1-4 lines > line 10,67 numbers are at 10,69,10,77 > line 11,67 numbers are at 11,69,11,77 > line 12,67 numbers are at 12,69,12,77 > line 13,67 numbers are at 13,69,13,77 There are not always 4 lines of numbers on this particular screen. Quote: "Then I go to line 21,12 and...
  7. link99sbc

    Compile error on End Sub

    Well I'm just learning. I don't have experience with If Statements and reviewing some posts on here I was trying to make something work. I have a screen that has > 5326547 > 65479895 > 6587961 > 8567421 The screen could...
  8. link99sbc

    Compile error on End Sub

    ----------------------------------------------------------------- ' Global variable declarations Global g_HostSettleTime% Global g_szPassword$ Sub Main() '-------------------------------------------------------------------------------- ' Get the main system object Dim Sessions As Object Dim...
  9. link99sbc

    Compile error on End Sub

    Shell "Notepad c:\My Documents\Print.txt" Sess0.Screen.WaitHostQuiet(g_HostSettleTime) Sendkeys "%{tab}" Dim Sys As Object, Sess As Object, MyScreen As Object, MyArea As Object Sess0.Screen.Sendkeys("<PF10>")...
  10. link99sbc

    Compile error on End Sub

    What would cause a compile error on End Sub??????
  11. link99sbc

    IF Statements help

    Thanks Zach but this is going to be more complicated than I thought. I found out that on certain accounts (I don't know which ones but not all accounts) the programmers for our system made a popup screen. When putting an M on the first morbil and pressing enter, a screen pops up with a message...
  12. link99sbc

    IF Statements help

    Also there are other Morbils on the Morbil screen that I am not concerned with. Only if they exist at 10,68;11,68;12,68 and so on.
  13. link99sbc

    IF Statements help

    The screen with Morbils shows there are other screens present. I type an M on the first Morbile and hit enter which brings up the screen for that morbil. Copy the screen then PF3 back to the morbile screen then past the copied screen in the file. Put M on the second morbile press enter which...
  14. link99sbc

    IF Statements help

    I have no experience with If Statements. But I think I need one to accomplish this task unless there is another way to do it. I have a specific screen that has "Morbiles" which is a > that is underlined. Placing the cursor on it and typing "M" and press enter brings up another screen that I...
  15. link99sbc

    macro to print host file to text file

    play with this! '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' MACRO NAME: CAPTUR32.EBM (update of 16-bit CAPTURE.EBM - using OLE Automation) ' WRITTEN BY: Attachmate Automation Support 'DATE WRITTEN: 2/29/96 ' DESCRIPTION: This macro grabs an entire screen of...
  16. link99sbc

    macro to print host file to text file

    '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ' MACRO NAME: PRTSCR32.EBM (update of 16-bit PRINTSCR.EBM - using OLE Automation) ' WRITTEN BY: Attachmate Automation Support 'DATE WRITTEN: 2/29/96 ' DESCRIPTION: This macro prints the host screen for the Active Session...
  17. link99sbc

    Help with Loop Extra to Excel

    The problem is probably Do Until (MyScreen.WaitForCursor(3, 11)) maybe shoud be Do Until (MyScreen.WaitForCursor(3, 2))
  18. link99sbc

    attachmate 7

    Usually you have to open an old macro in attachmate 7 macro editor and save it which usually automatically converts the old macro to the new format. Usually takes care of the problem. And attachmate has been known to change the path to the macros so check the folder path on your tool bar buttons...
  19. link99sbc

    Excel: split 1 spreadsheet into numerous sheets

    Sub Split() Dim NumbLines: NumbLines = 100 'or whatever Sheets("Sheet1").Select Sheets.Add Sheets("Sheet1").Select Rows("1:" & NumbLines).Select Selection.Cut Sheets("Sheet" & Sheets.Count).Select Rows("1:1").Select Selection.Insert Shift:=xlDown Sheets("Sheet1").Select Selection.Delete...
  20. link99sbc

    Reflection

    probably pretty close to Excel VBA SendKeys Method See AlsoApplies ToExampleSpecificsSends keystrokes to the active application. expression.SendKeys(Keys, Wait) expression Optional. An expression that returns an Application object. Keys Required Variant. The key or key combination you...

Part and Inventory Search

Back
Top