Frank,
One way is to use Visual Basic for Applications (I would say that wouldn't I) to draw and then re-draw the sections in the spreadsheet. This could either be done by creating a drawing object and then updating it in a For...Next or Do...While loop or creating a chart and changing the the ranges that the chart points at within the loop. The latter solution is probably simpler and requires less work. If I get time I'll create something to demo it.
Another way that doesn't involve VBA is to export the individual charts as bitmaps and load them into a movie making package. Corel PhotoPaint will do it or JASC Animation Shop or Microsoft GIF animator etc etc.
Regards
Tim Wynn
*************************************************
Dr Tim Wynn
TRACS International
Falcon House
Union Grove Lane
Aberdeen
UK
AB10 6XU
[log in to unmask]
Tel: +44(0)1224 321213
Fax: +44(0)1224 321214
www.tracs.com
*************************************************
-----Original Message-----
From: Peel, Frank FJ [mailto:[log in to unmask]]
Sent: 29 October 2002 18:26
To: [log in to unmask]
Subject: Animating structural simulations produced as Excel graphs
Colleagues,
Another Excel-related question for you, if you're not sick of this
already.... I am producing a set of simple spreadsheets which forward model
structural geological processes, with the aim of using these as teaching
tools. The first completed spreadsheet takes an initial salt and sediment
geometry, and produces a set of plots (10 in this case) showing the
progressive development of the salt withdrawal basins and the sediment
geometries within them in cross-section view. The simulation changes as the
starting geometry, sedimentation rate, etc. are changed. The plots are in
the form of Excel charts.
My question is, does anyone know of an easy way of automatically creating
the output as a movie or as an animated chart, rather than a series of
separate sections?
Regards
Frank Peel
Principal structural geologist, BHP Billiton Petroleum
EOM
NOTICE - This message and any attached files may contain information that is
confidential and/or subject of legal privilege intended only for use by the
intended recipient. If you are not the intended recipient or the person
responsible for delivering the message to the intended recipient, be advised
that you have received this message in error and that any dissemination,
copying or use of this message or attachment is strictly forbidden, as is
the disclosure of the information therein. If you have received this
message in error please notify the sender immediately and delete the
message.
|