Recent content by Elite237

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