Search results

  1. L

    script connect to sql database

    they think is an upgrade b/c they only know sql ...... anyway they already made the decision and now I have to find out what to do ... any solution or food for thought?
  2. L

    script connect to sql database

    My company decided to upgrade from progress database to sql database while keeping the progress code. So how should I change scripts that run over the night? If I need to re-write the scripts anyone have any idea of how to connect to sql database and run progress code? Here is an example of...
  3. L

    Create excel macro

    Thx alot mosfin I'll give it a try and see I have one more question Is there anyway I can copy a macro from one excel to another?
  4. L

    Create excel macro

    After I export a report into an excel file, I need to create a macro inside that excel file so that someone can use it to approve it. (After reviewing it, they will use a shortcut key like "Ctrl + M" and in the top of the excel file will said approved date - today's day). Can anyone please show...
  5. L

    Excel - Wrap within Cell

    chWorkSheet:Range("D8"):VerticalAlignment = -4130. should wrap around and adjust the row height
  6. L

    Excel questions

    Got an error message : "Error occur while accessing component property/method: sheets. Execption occurred" I found the proper command to create underlined font 16 header for everysheet now chExcelAppl:ActiveSheet:PageSetup:LeftHeader = "&""-,Regular""&16&USUMMARY REPORT". THX ALOT FOR ALL...
  7. L

    Excel questions

    Unfortunealy, the template is setted by others and I asked my boss and I cannot change it. I tried to copy for the templete but I copy most of the details except the heading (column width and row height also) maybe you can take a look of the code: DEFINE VAR chExcelAppl AS COM-HANDLE...
  8. L

    Excel questions

    YES! Thats exectly what I want. Never think about doing it in the template side ... Thank you very much Sphipp
  9. L

    Excel questions

    Thank you for the answer: rainlysh: I don't know if line count is going to work in excel because if you change the setting of the printer, the cell you going to use will be different unless I force a page break (if any in excel). I want to try to use heading in excel but I'm still looking for...
  10. L

    Excel questions

    1. I would like to put a heading on top of each page. How can I find out if the next line is in the next page in excel and what row is it? Or is it any other way I can put the heading? 2. I'm having trouble with borders. I would like to set 2 different thickness of the line for two boxes. Can...
Back
Top