Jump to content


Photo
- - - - -

Excel


10 replies to this topic

#1 SteveHoughton

SteveHoughton

    Member

  • Members
  • PipPip
  • 42 posts
  • Gender:Male
  • Location:Kent UK

Posted 30 July 2007 - 12:29 PM

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

#2 andykay

andykay

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 204 posts
  • Gender:Male
  • Location:Cyberspace...looking for work

Posted 30 July 2007 - 05:21 PM

Hi Steve,

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


AK

Attached Files


THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!

#3 SteveHoughton

SteveHoughton

    Member

  • Members
  • PipPip
  • 42 posts
  • Gender:Male
  • Location:Kent UK

Posted 30 July 2007 - 09:32 PM

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

#4 andykay

andykay

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 204 posts
  • Gender:Male
  • Location:Cyberspace...looking for work

Posted 31 July 2007 - 12:18 AM

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
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!

#5 SteveHoughton

SteveHoughton

    Member

  • Members
  • PipPip
  • 42 posts
  • Gender:Male
  • Location:Kent UK

Posted 31 July 2007 - 12:48 PM

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

#6 andykay

andykay

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 204 posts
  • Gender:Male
  • Location:Cyberspace...looking for work

Posted 31 July 2007 - 04:41 PM

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



Do you mean the TEXT colour?

AK
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!

#7 SteveHoughton

SteveHoughton

    Member

  • Members
  • PipPip
  • 42 posts
  • Gender:Male
  • Location:Kent UK

Posted 31 July 2007 - 08:09 PM

Andy

Yes I did mean the text colour..

Steve

#8 andykay

andykay

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 204 posts
  • Gender:Male
  • Location:Cyberspace...looking for work

Posted 31 July 2007 - 10:29 PM

Andy

Yes I did mean the text colour..

Steve


The solution has been Emailed to you.

Enjoy, :)

AK
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!

#9 Steve Houghton

Steve Houghton

    Advanced

  • Validating
  • PipPipPip
  • 52 posts
  • Gender:Male
  • Location:United Kingdom

Posted 01 August 2007 - 05:41 PM

Andy

Thanks for that - worked very well indeed..

Steve

#10 Donald Miller

Donald Miller

    ProIV Guru

  • Members
  • PipPipPipPipPip
  • 205 posts
  • Gender:Male
  • Location:Cupar, Fife, Scotland
  • Interests:Motorcycling, Running, Cooking

Posted 02 August 2007 - 09:09 AM

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
Half of what he said meant something else, and the other half didn't mean anytthing at all

#11 Ivan Gomez

Ivan Gomez

    Member

  • Members
  • PipPip
  • 20 posts

Posted 02 August 2007 - 02:09 PM

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!



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users