Search results

  1. vdennis

    Smtpmail And Ssl Issues

    Most sites are now requiring SSL and I don't see where anyone has had any dealings with the issue. A change at Verizon now requires SSL or that the return (from) email address be that of the user's account. GMail, and others will let you get be with the alternate, but require SSL or TSL (?) on a...
  2. vdennis

    Report Manager For Gui Applications

    Has anyone had any luck or know of a report manager that will support GUI applications? What I am looking for is the same interface that we have with the CHUI version of the report wizard in creating a stored job, but instead of running on the UNIX box, run locally. We are having more and more...
  3. vdennis

    Question Create Copy Of Excel Sheet

    I am trying to copy an excel sheet in a workbook and then rename it. I recorded the excel macro which is what I usually do and can usually slug my way until I can get it to work. But what is happening is that a new 'book1' is also being created with the copy command. So I was wondering it anyone...
  4. vdennis

    Excel Sheet Counting

    Good afternoon all. I am trying to figure out how to read the sheet tab name in a workbook where the number of sheets may vary. What I want to do is to 'trim' the names so in a case if I am looking for "JULY16", and the sheet name it "JULY16 " (notice the space,) it wont crash the program. Yes...
  5. vdennis

    Question Resetting Pic Size In Excel

    Good day all. I have a program that creates an excel sheet and added pictures based on the product. (Product image.) My problem is that the images do vary in size and I need to be able to do a 'reset' on the images, like using the reset in Excel's tools. Or, if I could determine the dimensions...
  6. vdennis

    Question Editor Left 'open' When Program Is Run

    I am trying to use a batch file to run a progress program. The program starts and runs just time, but when it is completed the 'editor' window pops up, forcing me close to close it before the batch process continues. I had done this once before, but my boss has told me that the file I used...
  7. vdennis

    d-calendar.w question

    SX 5.5, running on Windows Server 2008. Yea, I know. We need to upgrade. Working on that issue. But here is the problem. From a dialog window, I have a button that calls the d-calendar.w program. When you press the button, it locks up progress and forces you to exit Progress completely. Funny...
  8. vdennis

    Enlarging display using editor

    Was wondering if anyone has had any luck trying to enlarge the display window box when running a procedure? We run a lot of Q&D's and having to scroll from one side to another is a real pain. Because of what we are doing, we can't run these on the UNIX side and change the column size. Thanks...
  9. vdennis

    Prodataset and Crystal Reports

    Using KB # P110632/p as a reference, I was wondering if anyone has had any luck using option 2? And if so, a sample of using 'ADODB'. What is not shown are well explained is using the SetDataSource method. I am also going to try and search here again, but did not have any luck the first try...
  10. vdennis

    Height and width of an image

    Hi all. I am trying to figure out how to determine the height and width of an image. I have an excel worksheet that I load pictures into at exact points, so I am having to use the AddPicture method. Works fine is the image is 'square' say 50 by 50. But we have some that are not and therefore the...
  11. vdennis

    Question Virtual server os-getenv problem

    Hi all. We are changing to all virtual servers for our progress application (SX). The requirement is that I need to pull the 'userprofile' but the result within Progress does not match what is displayed at the command prompt. Using the OS-GET('userprofile') the result is along the lines of...
  12. vdennis

    Sort Excel using color

    Good afternoon all. I have used the sorting method for a single sort, but now I have need to sort first by CellColor, (or lack thereof,) and then product number. The following short code works for descending product number. hWorksheet:range("A2:Z051834"):sort( hWorkSheet:range("G2"), 1, ...
  13. vdennis

    Question Web Services Question

    I have been given the task to start looking into using a web service. Our goal is to pass some information, like customer name and company, and have an QR image returned. My first question is this: Is using a WDSL file the only option? Can this data being passed up to the service be an HTML...
  14. vdennis

    Question on Excel and passwords.

    Hey gang. Has anyone had any luck with being able to pass a password when opening or saving an excel file? I am having progress create an excel file that at the end of the process it is proteced, (working) and set a password for it. Trying to avoid having the user set the password before...
  15. vdennis

    Answered A remarkable problem

    We have an include that has the following: {pv-mail.i &to = "cMailTo" &subject = "cMailSubject" &message = "cMailMessage" &attach = "cMailAttach" &comstream = "/*"} Here is the problem: the "/*" part makes everything...
  16. vdennis

    FIND function in Excel

    As anyone had any luck converting the FIND function in excel to 4GL? What I need is to search a column for a value and if found return the ROW number . Thanks for taking the time to read this. -Dennis-
  17. vdennis

    Progress or Status Bar

    I know I saw this somewhere, butI am trying to develope a status or progress bar to show when a program is running, to let the user know about where they are in the process. Is there anything out there already? Thanks in advance -Dennis-
  18. vdennis

    SMTPMAIL.P update for new exchange servers

    We have been using smtpmail for over a year now in our UNIX system with no problems. But as we are up-grading our exchange servers to 2010, a problem showed up where we would get an 'invalid domain' error message. The problem, in short, has to do with the LocalHost value. This is set in the...
  19. vdennis

    SMTPmail problem

    We are in the process of adding a new exchange server and when running test on the unix side I am now getting the 501.5.5.4 invalid domain name error. When I run the exact same code on my local, windows box it works fine. I doubled check the 'connection with the following code: def var hSocket...
  20. vdennis

    Outlook Global Address List Question

    I was wondering if anyone knew how to access the global address list from OutLook? The following progam, (pulled form this website) works find in getting the Contact Address List, but I need the global list: DEFINE VARIABLE houtlook AS Com-handle NO-UNDO. DEFINE VARIABLE hnamespace AS Com-handle...
Top