Search results for query: *

Hello... I have a Microsoft Word Document containing many form fields. It also contains a couple of Combo Boxes. I want the user to only be able to select the data in the Combo Boxes and not enter in anything else. I am able to lock the combo box so they can't enter in anything free-form...

Thanks so much for your help...The statement I ended up using was: =IF(SUM(R[-7]C:R[-1]C), SUM(R[-7]C:R[-1]C), "") Everything seems to be working the way it should now!!

Hello... I am using an R1C1 reference to determine the Totals of a few rows. However, if the total of the R1C1 reference comes to 0, I would like to display a Null value instead of the 0. Is this possible? My current statement is below... args := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG ( args...

Does anyone have any sample code of hiding a column using OLE2. I am using the following code, but it doesn't seem to be working... args := OLE2.CREATE_ARGLIST OLE2.ADD_ARG ( args, 'A:A' ); column:=OLE2.GET_OBJ_PROPERTY(worksheet, 'Columns', args ); OLE2.DESTROY_ARGLIST ( args )...

Hello... Does anyone have any example OLE2 code that moves an Excel spreadsheet. I am trying to create a report that inserts a new spreadsheet for every new location. What is currently happening, is the new sheet is put in front of the old sheet, and I would like it to insert the sheet after...

Does anyone know if it is possible to create a Matrix Report in Excel, using OLE2 from Forms 6i? Any help you could offer me would me much appreciated. Thanks In Advance!!

Hello... I am using an OLE2 Package from Froms 6i to insert some data into Excel. Recently, my PC was upgraded from Windows 2000 to Windows XP and now for some reason my form is failing before it inserts the data into Excel. Does anyone know of any bugs with Windows XP when using OLE2? Your...

Hello... Does anyone have any example code of using relative references in a range? Is it possible? The code I have been using various forms of is listed below, but it doesn't seem to work? args := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG ( args, 'RC:RC[23]' ); range := OLE2.GET_OBJ_PROPERTY (...

Hello... Could anyone help me out in adding an Excel Page Break, using OLE2? I am having some trouble doing this and would appreciate any help you could give me. Thanks In Advance...

Hello... Does anyone have any sample code of putting a Carriage Return, in the Header of an Excel File, using OLE2? I have been playing around with this for a while and am having no luck. Your help is much appreciated...

Thank You soooo much...I must be having one of those days!!

Hello...Can anyone help me figure out why the following Formula reference does not work? It does not put anything into the cell... args := OLE2.CREATE_ARGLIST; OLE2.ADD_ARG ( args, v_can_ctr + 7 ); OLE2.ADD_ARG ( args, 10 ); cell := OLE2.GET_OBJ_PROPERTY ( worksheet, 'Cells', args )...

Never mind...I figured out what was causing my problem. I needed to take out the last OLE2.RELEASE_OBJ ( cell ); line and everything now works fine. Thanks Anyway!!

Hello... I have the following code, and for some reason, the Loop will not end. Excel is made visible, but my 'Message 6' that I have marked (which I only receive one time), is the last message I never receive 'Message 7'. I have condensed my code as best I could....Can anyone help me to...

Hello... I want to send an e-mail, with an attachment, from Forms using OLE2. I can get the e-mail to send fine (I have shown the code below), but am having trouble trying to figure out how to attach a document to the e-mail. Can anyone give me some help in adding an attachment to the code...

Hello... I have a report that I would like to calculate the percentage of the total. I am listing Vendors that have a certain Classification, their dollar amount for a specific month, and would like to determine the % of the Grand Total for the classification, for each vendor. I was...

Hello... Is it possible to create subtotals in Excel, using OLE2? If so, does anyone have any sample code? Thanks!!

Hello... Does anyone have an example of how to Merge 2 cells together using OLE2? Thanks In Advance!!

Hello... I am back again. Thanks for your help. I got the above to work in my form, but now I was hoping you could help me a little bit more. From here, I would like to take the vendor information in the record group and insert it into Excel. Do you have any sample code you could help me...

Hello... Does anyone have any example code of populating a record group with the information selected by a checkbox? I have a form where a user will enter in a vendor's name. From there, another form will appear displaying the vendor id and vendor name of all vendors in our system that...