Recent content by Osmar Morais

Thank you very much for your answer. I already had solved but just today I saw your reply.

Thanks Fabio and Cringer, both gave me the solution I needed by setting the READ-ONLY attribute in the ROW-ENTRY of the browse. Works perfectly. It was easier than it looked at first . Well done!

Thanks for your tip but in this case all cells of this column would be affected and I need to block or allow each cell individually, because for some colors would not have all sizes.

I need to create a cross-reference application in which the lines will be the colors and the columns will be the size of a particular textile product. The problem is that can not exist an item (SKU) for all the cells, and in these cases, I would like to block those cells to avoid improper...

I would like to know if there any way to generate a *.EXE file for a Openedge program? We have the compiler that generates a *.r file, but we don´t have a kind of link-edition for this.

Thanks everybody. I´ve tryied some alternatives and the code below solve my problem. DEF VAR cDirIN AS CHAR NO-UNDO INIT "c:\temp". OUTPUT TO value(SESSION:TEMP-DIRECTORY + "Command.ftp"). PUT UNFORMAT "open " + es-instal.host-ftp SKIP. PUT UNFORMAT...

I´m needing a piece of Openedge code to locate a file on a Windows FTP server and download it in Windows platform. I can do it with Windows Explorer but I´d like to reference it commands like OS-COMMAND or OS-COPY. Thanks in advance for any help!

I´m trying to execute de command: "RAR a zipfile sourcefile" using the OS-COMMAND, but I´m not managing because returns error messages, maybe I´m not using the correct sintaxe. Someone could help me?

After some tests I got this code that works: hExcel:ActiveWorkbook:PivotCaches:ADD(1,"Plan1!R15C3:R18C5"):CreatePivotTable("","Mytable"). hExcel:ActiveSheet:PivotTables("Mytable"):AddFields("fr","33333"). hExcel:ActiveSheet:PivotTables("Mytable"):PivotFields("8888"):ORIENTATION = 4. Replace...

I found the code below in Progress Knowledgebase site. I tryed it but didn´t work. Maybe can work for you. The URL is http://progresscustomersupport-survey.force.com/OpenEdgeKB/articles/Article/P19744 DEFINE VARIABLE hExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE hWorkbook AS COM-HANDLE...

I´m trying to import text file on Excel with "QueryTables" command but I´m having problem with "TextFileColumnDataTypes" parameter to define the fields types I´m listing below the command. Except for the last line the rest fo command is executing properly, but, imports characters fields...

You cannot believe but even I try to set the field type as TEXT even so Excel cuts the left zeroes. I used the command ASSIGN chWS:Columns("B:B"):NumberFormat = "@" before the execution of the importation. Sorry, but I think this should be a very specific difficult. Thanks a lot.

Thank you again but as I´m using "EXPORT" command text fields already being exported with double quote (example "0000835"); I tried concatening the field value with CHR(160) too, but this character (CHR(160)) affect the cell value in the worksheet avoiding operations like "PROCV" or others...

Thanks for your help. I found some examples and I changed to "QueryTables" but then I had the same problem: Excel is cutting some zeroes to the left of character field (for example "0008105" is imported as "8105"). I should use a parameter "TextFileColumnDataTypes" to define the fields types bu...

I´m trying to import data from text files to Excel and I need to define some columns as "text" others as "date", and son on, but, for one of the parameters (the 11º, FiledInfo) I´m not managing to adjust the syntax for OpenEdge COM Object. I listed below the command generated for Excel macro...