Graph

[Former Member]

Hai To All,

How to create graph in form which is same as sales analysis report.

Regards,

Anitha

[Former Member · Accepted solution]

Hi Anitha

I think this is an chart created in the temporary Excel workbook and then pastted how an OLE object in SBO form.

Search gg for "excel chart visual basic into application" words.

Bye

Sierdna.

P.S. An example for Word document.

Imports System.IO 
...
Dim sXlsFile As String = Application.StartupPath & "\Chart.xls"
Dim app As New Word.Application() 
Dim doc As New Word.Document() 
doc = app.Documents.Add()
doc.Shapes.AddOLEObject(sXlsFile,...<other parameters>) 
app.Visible = True 

File.Delete(sXlsFile)
...

Edited by: Sierdna S on Jul 17, 2008 2:05 PM