Recent content by shawwallace

sKIP THANKS A LOT. HERE IT IS copy from excel 14c,14d,14e,14f,14g.14h to screen Supplier Account 10,7, 5 ( 10th row, 7th column 5 total string) Supplierunit 10,15,5 Supplier quantity 10,23,7 Supplierpartnumer 10,33,3 Product...

sKIP THE code which i provided could you see where is the problem it is not coping from excel. i have posted the code earlier posting from excel to Extra!

thanks skip i got it

MY SCREEN.AREA IS CORRECT WHAT IT BELOW> EACH PAGE THE BELOW ONE HAS DIFFERET POSTION MAY BE FIRST PAGE SHOWING 11,18 SECOND PAGE SHOWING 12,18 TOTAL 15.00 14.00 00 SO CAN I MENTION LIKE THIS Set MyArea = MyScreen.Area(11,18,11,116,1) '(19,18,19,116,1)

Hi! thank you very much for your help. the below code does it have any correction from vt session if it is more than two rows in excel that mean 14 and 15 press enter to next screen ( how do i write this codeas condition) copy from excel 14c,14d,14e,14f,14g.14h to screen Supplier Account...

Hi! thank you very much for your help. the below code does it have any correction from vt session if it is more than two rows in excel that mean 14 and 15 press enter to next screen ( how do i write this codeas condition) copy from excel 14c,14d,14e,14f,14g.14h to screen Supplier Account...

this is staring point from excel to Extra! is it any corrections in that code Sub Main Dim appExcel As Object Dim wbExcel As Object Dim aSheet As Object Dim Sessions as Object Dim System as Object Dim AccountNum As String Dim Sess0 as Object Set...

I need only example not anything

Skip i just starting now. so just how to grab from excel to Extra! and then i will develop then and there. could yu provide that one. thanks

yes skip if if it is no record found it writes into text file as no records found is it right MyScreen.SENDKEYS "<Home>*<EraseEOF><Tab>UT<Enter>") MyScreen.WAITFORSTRING("ACCOUNTS") if IF InStr(1,UCASE(Myscreen.GETSTRING(24,2,5,)),"NO RECORD/S FOUND") THEN Print #1, "NO RECORDS FOUND"...

i have standard excel template file user enters the datas. is it posssible can i transfer from excel to Extra! please provide the code . I did search here. But it is confusing. could you provide the code please thanks

In that case if i wait for string "acctonts" how do save it without open the text file. please explain in detail regard this thanks

skip sorry i forgot to tell you. i ahve open and close stattments which has open a text file and close text file

Skip thanks for your help. waht i am trying to do from vt session if the datas are there it print out otherwise it will print no records found the above code two separate statements/

from vt session i have some records showing in that, i have to grab the thing and print or if it is no records found that also print how do write the bothe in one. the below code could anybody modify this thansk in advance MyScreen.SENDKEYS "<Home>*<EraseEOF><Tab>UT<Enter>")...