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

    Help Getting Excel Data Into Attachmate session/emulator

    I will try out this and see if it is successful. Thank you for the input.
  2. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Skip, So I was able to find out that the attachmate application/emulator that I am using has a 24x80 grid/space; by that there are 24 rows by 80 columns. My data from excel would go to the following rows/columns. 1.) 4x20 2.) 4x46 3.) 5x71 4.) 17x50 5.) 21x30 etc, etc........ So my questions...
  3. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    I will do that as soon as I can. Thanks for your input and patience. Have a good day.
  4. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Skip, What are the EXACT screen MESSAGES for complete, done, invalid for both INQUIRY & UPDATE? I will get the EXACT messages for you tomorrow if you want the exact ones. Is there an UPDATE (add,change,delete) field or a separate UPDATE transaction? In other words, how does an UPDATE occur...
  5. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Hi, I am using Excel 2007 and use of Structured Table Reference is doable for me. My issue is linking the two applications together so that the repetitiveness of entering the same type of data can be automated as much as it can via a macro. This code below worked in getting my attachmate...
  6. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Skip, My concern is how I should go about in mapping the data to attachmate? The way our attachmate work and how it relates to the data in the columns are as followed: 1. I would enter a lookup id (in my case, the loan number from the spreadsheet) into the loan number field of attachmate in the...
  7. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Skip, Thank you for your input, as i will certainly try this tomorrow. As far as the code: Sess0.Screen.PutString MyRange.Value, 24, 6 Is this valid for my use? Because i got this from another post, it did open my test excel file but no input/scraping was done. Are these referencing to...
  8. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Attached are images of what i am doing in excel and what i am using as far as attachmate is concern. Please any help will suffice as i am a newbie to VBA and codes. ************************************************* http://www.mediafire.com/?40a051k0qixjnsj...
  9. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Hi again, This is what i got so far: **************************************************************** '-------------------------------------------------------------------------------- ' This macro was created by the Macro Recorder. ' Session Document: "C:\Program...
  10. RussellWhy

    Help Getting Excel Data Into Attachmate session/emulator

    Hi, Anyone out there who could help me with creating a macro that opens an Excel file and then copy the data within a record that resides on row 1, 2, 3, etc where the data are in A2 through H2 (See first img as an example)and then paste it in to the Attachmate session ( I am providing an image...

Part and Inventory Search

Back
Top