DDE Link with Excel (OpenInsight Specific) [Revelation On-Line Wiki]

Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community

At 08 MAR 1999 07:19:38PM David Schranz wrote:

OpenInsight Specific

I wish to create a DDELink with Excel, pass variables and automatically display a pie chart/bar chart in Excel.

Example :

Variable 1 =Males'

Variable 1 =Females'

Variable 2 =1000'

Variable 2 =1540'

I would pass the 2 variables to Excel showing the number of males against females graphically.

Any Suggestions ?

]dschranz@dakarsoftware.com<

At 09 MAR 1999 08:00AM amcauley@sprezzatura.com onmouseover=window.status=why not click here to send me email?;return(true)", [url=http://www.sprezzatura.com" onMouseOver=window.status=Why not click here to visit our web site?';return(true)]Sprezzatura Group[/url] wrote:

use DDEDATA to fill the range then use DDECOMMAND to launch a macro to plot the graph and copy it into the clipboard then paste elsewhere.

We've got an app which uses this technique to produce a 30 page report in WinWord combining Excel Pies, tables and graphs in the language of the user.

Quite a bit of work (50 days in total) but the results look great.

amcauley@sprezzatura.com

Sprezzatura Ltd

World Leaders in all things RevSoft

View this thread on the forum...