Posted 30 July 2007 - 12:29 PM
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?
Posted 31 July 2007 - 12:18 AM
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.
Posted 02 August 2007 - 09:09 AM
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.
Posted 02 August 2007 - 02:09 PM
To colorize a cell, like in the attached file, use the PATTERNS command.
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!
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users