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...
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...
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...
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...
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...
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...
Hi again,
This is what i got so far:
****************************************************************
'--------------------------------------------------------------------------------
' This macro was created by the Macro Recorder.
' Session Document: "C:\Program...
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...
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.