New keyword Usage

John Pennington · August 7th, 2006, 03:13 PM

Wrox,
Can someone tellme why this is invalid?

Dim JPGraphChart As Chart
Set JPGraphChart = New Chart

I have referenced the Graph 11 Library. Chart appears to be a ligitimate class. But I keep getting an "invaid use of New" error.

John P

John Pennington
 
United Parcel Service
w(404) 828 6934
c (770) 714 5975

prabodh_mishra · August 8th, 2006, 06:51 AM

Graph 11 Library is not creatable. It can only hold already created object. You can use Excel.Chart or word.chart instead.

John Pennington · August 8th, 2006, 09:42 AM

Ok, still doesn't work.

Dim JPGraphChart As Excel.Chart
Set JPGraphChart = New Excel.Chart

keeps giving me "Class does not support automation or does not support expected interface."

What does it take to create a chart in vb and export it as a file???

John Pennington
 
United Parcel Service
w(404) 828 6934
c (770) 714 5975

gbianchi · August 8th, 2006, 09:53 AM

did you try google for the solution??

try this link...

http://www.vb123.com/toolshed/99_vbchart/vbchart1.htm

maybe it will help you...

HTH

Gonzalo

prabodh_mishra · August 8th, 2006, 10:39 PM

    Dim exApp As Excel.Application
    Dim exWb As Excel.Workbook
    Dim JPGraphCharts As Excel.Charts
    Dim JPGraphChart As Excel.Chart

    Set exApp = New Excel.Application
    Set exWb = exApp.Workbooks.Add()

    Set JPGraphChart = Workbooks.Item(1).Charts.Add()
    exApp.Visible = True

Now you have a chart1 in your excel application....

Cheers
Prabodh