Search results

Thanks for all the comments. I will change properly for to have my code better tan before Also I want tell you, that I did only one procedure.p and put all my other 6 procedures inside him. With this option I colud achieve work my procedure and open my Excel with the correct information. I...

And this my other procedure that I am trying bring and fill the cells: DEFINE VARIABLE chExcel AS COM-HANDLE. DEFINE VARIABLE chWorkbook AS COM-HANDLE. DEFINE VARIABLE chWorksheet AS COM-HANDLE. DEF INPUT PARAMETER ficha AS INT NO-UNDO. CREATE "Excel.Application" chExcel. chExcel:VISIBLE =...

I did it. Now doesn't show error message, just don't put the data in Excel. My code is: DEFINE VARIABLE chExcel AS COM-HANDLE. DEFINE VARIABLE chWorkbook AS COM-HANDLE. DEFINE VARIABLE chWorksheet AS COM-HANDLE. DEFINE VARIABLE registro AS CHAR FORMAT "X(316)". DEFINE VARIABLE ubicacion AS...

Cringer, excuse me, but How do that?

Hi guys. I have a little problem when I try to send data to Excel. At beginning I did a program, and declared global variables because I was calling to different procedures that were inside of my program .w and without problems, but now all these procedures I have to use them as .p. The issue...

Good idea. I will try to do it first in Excel and after I'll see the methods Cheers

Rob. I have designed an ID in Excel. I attached the example. I want eliminate all the margin, and of this way the ID appears in all the paper Thanks

Hi guys. I have a problem trying print in Excel. I need print an ID I have worked with the next codes: chWorksheet:pageSetup:TopMargin = chExcel:CentimetersToPoints(0). chWorksheet:pageSetup:LeftMargin = chExcel:CentimetersToPoints(0). chWorksheet:pageSetup:RightMargin =...

Hi Rob. Looking for in the MSDN page. I found that: It is required that "&G" be a part of the LeftHeader property string in order for the image to show up in the left header. And my problem was resolved thanks to you. Finally my code is: chWorkSheet:PageSetup:LeftHeaderPicture:FILENAME =...

Hi Rob. Thanks for reply. I tried with your code: chWorkSheet:PageSetup:LeftHeaderPicture:FILENAME = "C:\nom_v10\cam_carm\Iconos\Fondo_OCEANIC.JPG". but not inserted the image. Other idea? Cheers

Hi all Somebody can suggest me a solution please: I want insert an image in the header of Excel, but I don't know how do it. I am using this line to insert a text: chWorkSheet:PageSetup:LeftHeader = "Hola". and without problems. But with images, how could be? the versión of my Excel is 2010...

Hi Guys, sorry for not give enough information I have windows vista business of 32 bits. The version of Progress is 9.1 C Regards

good afternoon gentlemans I have a doubt. I want open a file of PDF at the momento of push a button, but I don't know the sintaxis for do it. I want to do an application, that first find some employee, when all information about this employee is in my form(for example a date of some course or...

Hi, I have a doubt about how I can order the sheets in excel at the moment of generate it. I create the sheets with the next sentences: chWorkSheet = chExcelApplication:Sheets:ADD(). chWorkSheet = chExcelApplication:Sheets:ITEM(1). but the excel sheets begin to be created from right to...

Hi, somebody can tell me How can query the tables SYSATTACHTBLS, SYSBIGINTSTAT, SYSCALCTABLE, SYSCHARSTAT, SYSCOLAUTH, SYSCOLSTAT??? Thanks

HI, I NEED TO KNOW HOW I CAN DO A QUERY WITH A FIELD CALCULATED. I HAVE MY BROWSE, AND I DID A FIELD CALCULATED, AND I HAVE OTHER WINDOW, I´AM TRY DO A QUERY FOR CAN OPEN THE OTHER WINDOW ACCORDING WITH THE VALUES OF THE BROWSE. MY CODE IS: ON CHOOSE OF BTN-PCONTABLE DO: FIND M_polizas...

Thanks for you answer. Is done Bye

Hello, someone know how to validate a screen. What I want to do is that to the moment to press a button my procedure is executed in case it is proved, but them finds that there throws myself a box of text that says to me that did not find records. This is the code that I have in my button...

Hi I have a doubt. I am trying to show the information of an invoice, only that an invoice can come from different companies, and what I want is that there appears only a company that is called IPC and this one has a related field that calls cve_empresa, but on having showed it in the browse...

Thank you, for your help, this it was the mistake. See you