10 replies to this topic

[SteveHoughton]

Hi Guys

In the past year or so I have done a lot of work on creating Excel spreadsheet froms within Pro-IV using DDE commands. I am revisiting the code as I want to create cells with specific colours rather than apply a colour style, eg background colour in cyan and font colour in black.

Has anybody done any work on this?

Thanks

Steve

[andykay]

Hi Steve,

To colorize a cell, like in the attached file, use the PATTERNS command.


AK

Attached Files

•  Book1.xls   27KB   162 downloads

[SteveHoughton]

Andy

Here are some of the pattern colours I could find - do you havce a complete list?

1 Black
15 Gray
2 White
7 Magenta
3 Red
46 Orange
44 Gold
6 Yellow
8 Cyan
4 Green
5 Blue
24 Purple

Many thanks

Steve

[andykay]

You've obviously found where I found out how to do it from because those are exactly the same referenece's / notes I have listed in my Global's logic.

If I recall, I believe that when I was first experimenting I wrote an update that would change the color of cell to that of the row number. But, either it didn't work, or I didn't list the numbers of the colors as notes in my Global because according to the Global's notes...I'm limited to the colors you've found, too.


Sorry,

AK

[SteveHoughton]

Andy

Here are a few more background colours

9 Brown
10 Dark Green
11 Dark Blue
12 Dark Green
13 Mauve
14 Petrol Blue

I am still trying to change the foreground colour - the work goes on....

Thanks

Steve

[andykay]

I am still trying to change the foreground colour - the work goes on....

Do you mean the TEXT colour?

AK

[SteveHoughton]

Andy

Yes I did mean the text colour..

Steve

[andykay]

Andy

Yes I did mean the text colour..

Steve

The solution has been Emailed to you.

Enjoy,

AK

[Steve Houghton]

Andy

Thanks for that - worked very well indeed..

Steve

[Donald Miller]

Hi Andy

Any chance you could post it so that any others that are interested can benefit from the knowledge. If you have emailed it to Steve does that mean it is NOT copyrighted code (and can therefore be posted without recrimination)?

It's maybe not something a lot of people do - but with a little more information - it might be something to be considered. I've got some new customers that use Excel so may require it in the future. Any information prior to the event may allow a quicker turnaround to be managed.

Thanks

[Ivan Gomez]

Hi Steve,

To colorize a cell, like in the attached file, use the PATTERNS command.


AK

Hi Andy,

I'm working with PROIV (5.5 VIP) and EXCEL. I'm doing a MASTER - DETAIL - SUBDETAIL list. I read your comment and I would like to give to my excel document a defined structure, something like the file 'xls' you posted with your message. Could you give me any informations about how to stablish the structure with DDE commands???? Thanks a lot!