Recent content by vdennis

My 4Gl software uses Crystal Reports to create letters / forms / stuff like that. In this case the letters are dumped into a holding directory, then progress reads thru the list and sends the files out as a PDF attachment going back to the customer record for the email address to use. For us...

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...

Ok, this is a test for each customer: end.

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...

What I was referring to how you were able to place your sample code in a scroll-box. I'll have to look for that file. We are running 2010 excel, any may be upgrading later this year. Hope they don't make too many changes before 6/30/2017. (My supposed start of retirement.) I am still testing...

Thanks so much. Was able to use the code and after some changes to yours and mine got it working. It is too bad that a lot of the calls that can be made to Excel are un-documented. In my program, depending if you want to merge the sheets or not, is being written for our purchasing department to...

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...

And the answer is : ... Normal excel def in place, handle and all.... def iSheets as integer. assign iSheets = hWorkBook:count. Worked great, but..... we only see 13 sheets and there are 27! Still could work just fine but was surprised by that .

Thanks for the quick response, but in the case no. Not knowing how many sheets need to be examined is the issue. What I did find was a VB bit of code; ?activeworkbook.Sheets.Count So now I just have to plug in the com-handle stuff and this should solve that part. Once I know how many sheets are...

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...

The command we are using is : C:\Progress\OE111\bin\prowin32.exe -db nxt.db -H xxxxxxxx -S 12345 -U sysprogress -P xxxxx -rr -p C:\NxT\staging\sitegui\supam\saonlineack_v2.r exit This is run from a batch file which is called from windows task manager. Runs every 15 minutes.

Cecil, Just tried it out and it works perfectly for the job in mind. We run both GUI and CHAR programs, so I am hoping that it will also work in the CHAR side, but for the life of me I don't know why unless we just needed to get some for of listing. (We run InFor SX here, but have done tons of...

Thanks for the code. I think is exactly what I want. I have to drop pics into an excel sheet at fixed points next to the product number. If I determine the ratio, I can force that with the AddImage handle.

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...

And the winner is..... -rr I could not use the _progress.exe, as that brought up the 'dos' version of progress, and I needed to make calls to window based programs like Excel, Word, and Crystal Reports. Also using the -rr option allows for numerous exit points without having to worry of having...