Search results for query: *

could you check is there any modification in the below code the macro is not writing in text documnet this is what i have written. is there any alternate way to do checking the amount field. if it is more than 10 it is writing the whole particular row. code is here if...

how do i enter inputbox like fiscal year and perid exampleUserInput = InputBox ("FISCAL YR 2009 PER 08 " but it changes year and period is it somthing "FISCAL YR (YR) PER (n+1)

could you please help me how do save it in particular folder already open the active workbook.

is it possible before run macro can i give any warning massge like make sure is it in c:\test.xls if so, plese how to do it, Set wbExcel = appExcel.Workbooks.Open("c:\test.xls

open excel sheet. but the cursor is in excel how do i have the cursor in active screen here is the code. is that anything need to modify in this code Set System = CreateObject("EXTRA.System") Set Sessions = System.Sessions Set Sess0 = System.ActiveSession Set MyScreen =...

thanks for your all help. i am tryting to do from screens to printer. i copied the code from this website and modified little bit. it is not printing anything. blank paper only. could yo help me please!!!! Sub Main() '----------------------------------------------------------- ' Get the main...

after sheet 1 how to add 10 sheets the below code i tried it gives error no such property or method. but i declard as object Set xl_sheet_1 = xl_wb.Sheets("Sheet1") xl_sheet_1.Add After:=xl_sheet_1(xl_sheet_1.Count), Count:=10

i have error in LINE .Cells(j,"A").Value = Name - OBEJCT ERROR COULD YOU HELP ME WHY IT IS COMING? j = 2 Do For i = 8 To 22 Name = Trim(Sess.Screen.GetString(i, 12, 10)) Account = Trim(Sess.Screen.GetString(i, 34, 19)) j = j + 1 With...

i have 5 screens. each screen has ctiy details city and city name in sess.screen(5,12,5,23) and name and acccount number 8 to 22 first screen grab all informaton into excel first sheet. i did it. after that i am struggling with that second screen more than one city name how to open the second...