Sending MS Chart to Excel

P

polisci grad

I generate a table and chart from SQL. I can export the table to excel, but
not sure how to send the graph. Here is VB:

Dim str As String

If Len(Me!Text46.Value) > 0 Then

str = Me!Text46.Value
DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Table",
"c:\Documents and Settings\james\Desktop\" & str & ".xls"
Else

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Table",
"c:\Documents and Settings\james\Desktop\TableExport.xls"

End If
 
Top