Link to home
Start Free TrialLog in
Avatar of psutton
psutton

asked on

insert an Excel chart into a word Document ??

if you have a chart which is  contained in a specific sheet in the spreadsheet, How do you place the CHART AREA in the word doc ?  What am I trying to accomplish ?  I have stored with in spread sheet sheets chart objects and would like to insert these charts in to a mail merge doc., that is to say chart 1 from sheet1 is placed om page1 of the doc chart2 from sheet will be placed on page 2 of the doc...and so on


Using D 5.01 Pro and Late binding.
None of the server components have been used.
 Paul sutton
Avatar of Epsylon
Epsylon

Just a thought, maybe you could build a macro that does the main part of the job. Then this macro can be called from Delphi...

Look here for info on Excel and Word automation:

http://www.djpate.freeserve.co.uk/Automation.htm


Regards,

Epsylon.
Avatar of psutton

ASKER

Macros are out at least at this time.
Avatar of psutton

ASKER

Adjusted points from 400 to 600
Do it in Word and record it as macro. Then have a look at the macro source. Reimplementing this in Delphi should be easier then.
ASKER CERTIFIED SOLUTION
Avatar of jeurk
jeurk

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of psutton

ASKER

Thanks. Your answer was prety much what I had in mind, I just didn't know how to get the different charts in to word.
email addr is psutton0623@yahoo.com
You're welcome. I sent it.
-Jeurk.