Recent content by iSPOK

Hi Christa, you may have already solved this problem already, however I thought this may help you in the future, having read some of the comments I know its not easy to understand how CSS works and displays information.. this is how I get around the problem being a CSS usre my self....... its...

Am not sure if this answers your question,,however you can try ..Sess0.Screen.GetString(1,28, 1,30, xBlock) Sess0.Screen.Copy Sess0.Screen.Paste

this depends on what your doing with,,IAPS,, are you just switching to that screen or you now need to put the data from excel into it.....or you now need to copy this screen as well, and put the data somewhere??

sorry my mistake,, try this SPOKScreen_Obj.GetString(1,1,24,80)

first of all, when the input dialog box pups up, enter the row number you want it to start from,, eg. 1, however if the first row is labled, then type 2 end then click the ok button..... Note: it will start from cell A1. LastExcelRow = Excel_Sheet.Cells(Cells.Rows.Count...

'Excel Object Dim Excel_Obj As Object, Excel_Sheet As Object Set Excel_Obj = GetObject(, "excel.application") Set Excel_Sheet = Excel_Obj.Workbooks("your file name.xls").Worksheets(1) your file name.xls. = what ever name you call the excel document.... Worksheets(1) = is the worksheet...

' Global variable declarations Global g_HostSettleTime% Global g_szPassword$ Sub Main() '-------------------------------------------------------------------------------- Dim Sessions As Object Dim System As Object Set System = CreateObject("EXTRA.System") ' Gets the system object If (System...

Do you have the script?, and are you trying to capture in a static position or your trying to capture data that could be any where on the screen??

Skie Please help,,, You code works, with only one small issue. Any date the I capture, will only default to the 15th /mm/yyyy, is there a way to make it work for the rest of the conditions, in the code...??

Hi Skie Thanks for your responce.... I will try insertimg that code into the VB edito in excel.... just to clarify how the dates work... Any day 2-7 goes to 15 of the previous month. Any day 9-14 goes to 01 of the previous month. Any day 16-21 goes to 08 of the current month. Any day 23-31 goes...

Hi skip... Thanks for taking a look at this.... Its a bit of a mind boggle.... Here is what am attempting to do, for the 4 reporting periods,, 01, 08, 15 and 22nd... Its goes somthing like this..say I pick a date of 02/02/07..then I would need to go back 2 reporting periods, so I should get a...

Please help.......... I have a what seems an improbable tast, and am not a natural programer and I will be very greatfull if any one with the know how could help.. I am attempting to write a piece of code that can look at any date and do the following: I have 4 reporting periods 01/mm/yyyy...

TA7EDDY.. Here is one I got from the forum, I've played with it and it seems to work like a dream...... Sub ScreenCapture() '-------------------------------------------------------------------------------- Dim Sessions As Object Dim System As Object Set System =...

calculus... Thanks for the sample search......perfect.. Now I need to find a script that if there is no "B10331" on first page it will move to the next page....But not all records have the "B10331"... So now the search will need to look for "PROD TOTAL" at the bottom of the page...(This...

Calculas.... Thanks for the pointer... can you give me an example script, for doing this from my code....cheers