Search results for query: *

Hi, not sure why this is not adding. Substract, divide and multiply all work but does not add, instead it puts the numbers together Trim(Sess0.Screen.GetString(12, 59, 10)) + Trim(Sess0.Screen.GetString(14, 39, 12)) thanks!

I like to open an Excel file and Attachmate mainframe using notepad. Is this possible? Thanks

Code below extracts the data for the first account # that is in column A but does not continue the loop to goto next account #. Column A has the accounts numbers and column D would be the data that is extracted from mainframe into excel Sub Extract() Dim Sessions, System As Object, Sess0 As...

Hi, Trying to write a vba code in excel where when in Mainframe the max date from location (8,54,8) to bottom of page is found then go into that record by entering "E" at location (x,02). Hope i made sense. Thanks

Hi, im running a code but i only want it to run on a specific screen in mainframe or a message box appears "Not correct screen". Need a code to run only in screen T900 please...thanks

Hi, im looking for a code that does this In Sheet "Temp", find last value in column E and clear everything after from columns E to M Thanks

instead of writing the same code (Sess0.Screen.SendKeys ("<Pf7>")) 20 times. Need shorter code to do this? this code goes to previous pages in Mainframe

Hi , i have payments in report that went nsf and i would like to remove those 2 rows. For example A B C Date Type Amount 1/31/2008 PA 487.00- 2/29/2008 PA 487.00- 3/31/2008 PA 487.00- 3/31/2008 NF 487.00...

Getting this error mesage but not sure y. Can someone please help. Im trying to scrape multiple row payments from Attachmate and input it into column E but i keep getting this error message Global variable declarations Global g_HostSettleTime% Global g_szPassword$ Sub Main()...

Hi, how can i combine these 2 statements so i get 2 results in one line ts.WriteLine Sess0.Screen.GetString(4, 11, 1) ts.WriteLine Sess0.Screen.GetString(4, 18, 5) Thanks

Hello everyone, im having an issue with auto scroll up to extract date from Attachmate. So basically, when im on a payment screen, it shows the bottom of the page first and then extracts only that screen. I would like it to scrape date start from top of page and works its way down to bottom...

Hi, how can i make this so it doesnt open another excel sheet but uses the one thats already open. For example, this macro is in workbook book1 and i want it to use the data in cell b3 from this same workbook to input data into Attachmate. Thanks Dim xlApp As Object, xlSheet As...

cant figure this one out, i keep getting this error ' Global variable declarations Global g_HostSettleTime% Global g_szPassword$ Sub Main() '-------------------------------------------------------------------------------- ' Get the main system object Dim Sessions As Object Dim System...

Hello everyone, im new at this and i like some help extracting data from Attachmate. So basically i have an account # in excel in cell "I2". When i press the extract button, in mainframe from T750 screen, it automatically enters the account # and moves to another screeen. From this screen at...