Automating Chart Creation on Excel

[Carol Torres]

Hi I'm a beginner in VB, and I'm facing the following issue: I have a program that exports the data I need to Excel (version 2002 - XP), and I need that once Excel recognizes that new data have been posted on a sheet, to automatically create a chart. Can anybody give me some suggestions about how can I do that?

Thanks in advanced for your help.

[Iouri]

Create the chart in Excel using Chart wizard for the range where you will post your data. Now enter data (using VB) to the Excel sheet and the chart is automatically there

Iouri Boutchkine
iouri@hotsheet.com

[Bennie Veenstra]

I have an application that uses excel and creates a chart automaticly. However I can't get it done to insert a pagebreak between two charts.
Who can supply me with the code to insert a pagebreak in excle using Visual Basic 6.0 SP5?