Search results for query: *

thanks Skip

i am trying to browse select open the file i have error in appExcel line object value set to nothing. could you help me Set appExcel = CreateObject("Excel.Application") appExcel = Application.GetOpenFilename(FileFilter:="Excel Files (*.xls), *.xls", Title:="Please select a file")...

thansk Skip i am trying to have last month this functionhas given 1 i need to have month MMM ie jan Month(DateSerial(1, Month(Now), 1)) - 1 how do it do it. thanks

i am trying to check if this month do something or lastmonth do somehting this is the code i provide here. but when i have messagbox here it is not displaying anything x = MyScreen.SendKeys("F CurrentMonthName <ENTER>") MsgBox x if x then Call Found elseif MyScreen.SendKeys("F LastMonthEnd...

then missing. sorry i realized. thanks

could tell me what is the syntax error in the below. thanks in advance. if MyScreen.SendKeys("F"CurrentMonthName "<ENTER>")

i did call procedure. it wokrs great. thank Skip

vzchin exit do will do the same page repeat. it wont end

thanks skip

after End of List i need to go to next screen and do something how do i do that? in if statment instead of exit sub how do i insert call funciton here if Ucase(Sess.Screen.GetString(24, 8, 11)) = "END OF LIST" then exit sub else Sess.Screen.SendKeys ("<PF8>") end if Call...

thansk vzachin

it works great. thanks

i have 6 pages. each page has 6 to 23 rows picking correctly. but last page not picking up before picking it come out from the loop. could you help me what is wrong in the below code. Do For i = 6 To 23 a = Trim(Sess.Screen.GetString(i, 11, 6)) b =...

thank you so much winblows. sorry for delay i have still problem with this line .00 ¦< 39.21 ¦< 37.43- ¦< 1.78 ¦< <<<<<<<<<<<<<<<<<<<<<<<<<<<<<<¦< curr_line =...

Hi! i dont get response. could you help me how do i find out 1.80 below. thanks! 00 39.23 37.23 1.80 <<<<<<<<<<

Hi! this is the first time i am coming to this website. i am writing macro grab from Attachmate to txt. total 10 pages first page copies whole . i did that each page has turn another side using pf11 that another page has only the below .00 39.23 37.23 1.80 <<<<<<<<<< i need only pick up 1.80 -...