Search results for query: *

No one? I think that might be a bug of office.. In Access: For Each w In srcWorkbook.Worksheets 'w.Cells.Replace What:="NULL", Replacement:=Null, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False w.Copy , oXL.ActiveWorkbook.Worksheets(i) oXL.Visible = True...

OK, I revised my code into following, in Access: For Each w In srcworkbook.Worksheets w.Cells.Replace What:="NULL", Replacement:=Null, LookAt:=xlPart, _ SearchOrder:=xlByRows, MatchCase:=False i = i + 1...

Are you sure? I add watch to debug it, after the code 'w.copy...', I'm able to see the 'oXL.activeworkbook' object... would you please explain a little bit in detail?

Hi, I'm trying to use VBA in access to open an excel spreadsheet, replace some content, and copy to another spreadsheet. The repace code works fine in Excel, but if I put it in access, I got "Subscript out of range", Here is the code: Set oXL = CreateObject("Excel.Application")...

Thanks gizzy17. way to go.. I have another question. How to joint more than two hold files together to get a report? Use the above sample, I need to generate another report like: Week-Ending Type1 Type2 Type3 Type4 Received 06Jul07 20 10 5 7 56 13Jul07...

I have a table like: Table 1 POL-ID EFF-DATE TYP-IND I need to generate a report like : Week-Ending Type1 Type2 Type3 Type4 06Jul07 20 10 5 7 13Jul07 15 17 12 4 20Jul07 18 19 1 12 27Jul07 5 10 11 20 Total...

The JCL above is for Focus - the environment installed in our mainframe. We also have Webfocus environment installed, it connects to the same DB2 tables. Actually, I don't really know how to convert above code into webfocus code..

offline(batch mode JCL) in full, works in JCL, doesn't work in online(using IExplorer) TSO SQL SET SSID DB0A SET SQLENGINE = DB2 SET WIDTH = 999 SET PANEL = 999 SET NODATA = ' ' -READ INPUTP &STRDT.I10 -READ INPUTP &ENDDT.I10 -READ INPUTP &PAYOTYP.A1 -READ INREGN &RGN.A5 -RUN -* SQL DB2...

Works great!! Where can I find a list of function I can use in webfocus, like the TRUNCATE? I'm using webfocus 7.1.

Thanks. I think I got it work.

I have no problem do it on batch, use SQL to create a hold file. Anyway how to do it online? SQL DB2 SELECT A.POL_ID, A.CO_ID, A.CVG_NUM, B.CLI_ID, C.CLI_FIRST_NM, C.CLI_LAST_NM FROM TABLE1 A, TABLE2 B, TABLE3 C WHERE A.CO_ID = B.CO_ID AND...

have trouble to convert a batch report(MVS) to online format. In batch JCL I have 3 SQL hold files, it's running fine. I tried to convert it to online(so user can use web to get report instead of submit a JCL), it complains the SQL hold files...has following error 0 NUMBER OF RECORDS IN TABLE=...

Another Q. I need to joint two table together. It's one to multiple situation. I need to select one record based on some criteria, say for example, based on an effective day would be one to one, how could I do that? Another one, I need to accept PARM from client input, I need to format the...

Newbies to webfocus. I need to joint two table together. Table 1 K 05 key-01 k 05 key-02 k 05 key-03 05 data-01 05 data-02 05 data-03 05 data-04 Table 2 K 05 t2-key-01 K 05 t2-key-02 k 05 t2-key-03 k 05 t2-key-04 k 05 t2-key-05 05 t2-data-01 05...