Search results

mrobles, You hit the nail on the head. The format is indeed: chWorkSheet:Protect(true, true, true, true) except.... what each "true" stands for is not correct chWorkSheet:Protect("test1234", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE). first one is password sixth one is what I was looking for...

Hi, I am trying to protect an excel sheet but allowing columns to be formatted. recording a macro in excel gets me: ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True _ , AllowFormattingColumns:=True Doing various permutations to get the Progress code has...

Thanks ... That's perfect... Been a long day missed that on the original reply. It works perfectly. I will add that to my growing list of interactions to Excel from Progress. Henry

I am assuming Cells (3,1) is Looking at the 3rd row and first column?? I tried that and get weird numbers which I am not sure have any relationship as it point to variety of cells and the same number shows up. MESSAGE chWorkSheet:Cells(14,1) skip...

I need to interrogate the results of a formula generated earlier on the same row. What is the format to check a specific cell? DId enough experimentation and have had no luck at the specifics. If formula generates say 200.00 in cell "A3"... if chWorkSheet:???? = 200 then.... Can someone help...

I have a program that sends more than 100 characters into a 40 character Excel field. In Excel you can format the cell to be word Wrap and the 100 characters will wrap into 3 lines. In a Progress routine I can do the same. However when you are using Excel directly if you use <alt> enter it...

I am using Progress to load a template and load data from a Progress database. Since adding a service pack to Excel 2003, the addins that were loaded as default before no longer are activate when I start the program. It looks like I need to load and activate specific addins now to have the...

FYI: I gave up trying to load Progress 9.1d directly onto Vista 64. I will try later when I have more time. However, I downloaded Microsoft's FREE Virtual PC 2007 and installed that on VISTA 64. Once installed, I installed Windows XP in a virtual machine on VISTA 64 and so far evrything...

Thanks for reply but that was the first place I looked... Unfortunately I could not find "Application Experience Lookup Service" on VISTA 64.. I did some experimenting on services similar but so far no luck. I wondering if anyone actually has accomplished this install on Vista 64 and what...

Hi... I am building an additional machine for development and decided to try Vista 64 for a head start on client migration. I have tried to load Progress 9.1D on Vista 64 and it keeps stopping me saying the process _isdel.exe is being used by some other process. I noticed another thread re...