Send Object - Format Problem

T

Tom Ventouris

I am using SendObject send a table in Excel. I am running Office 2007 and my
code works. One of my users is getting the following message:

"The format in which you are attempting to output the current object is not
available."

Here's my code:
DoCmd.SendObject acTable, "tbl_DataTransfer",
"Excel97-Excel2003Workbook(*.xls)", "", "", "", "Data", "", True, ""

The application is in A2003.
Any suggestions appreciated.
 

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

Working outlook via vba code with xlsx - error 0
Error probably caused by lack of library reference 8
Error 2950 from macro when exporting to Sharepoint 0
Can't send emails but can receive in Outlook 2019 1
Exporting from Access 2003 & Access 2007 to Excel 1
Problem with SET & REF function 0
Object Browser in VBA 0
New computer, how do i move outlook 365 ENTIRELY? 0

Top