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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

expected format 2
Export Report with Graph to Excel error 2495 1
Export to Excel when password protected 3
Opening Excel Workbook from Access after TransferSpreadsheet 2
TransferSpreadsheet construction 5
controling excel from vba access and using sub procedures 3
Problem with TransferSpreadsheet - memo fiedl gets truncated 1
export file to excel in microsoft access 1

Top