In Microsoft Office Access 2007, you may experience one or more of the following symptoms.

Back to the top

Symptom 1

Consider the following scenario. You try to export a report to a Microsoft Excel format. To do this, you right-click the report in the navigation pane, and then you point to Export. In this scenario, you may find that the Excel option is unavailable.

See workaround 1 in the "Workaround" section.

Back to the top

Symptom 2a

Consider the following scenario. You try to export a report to an Excel format by using the OutputTo macro action or the SendObject macro action. In the macro action, the value of the Object Type argument is Report. In this scenario, the option to export the report to the Excel format does not appear in the Output Format list.

See workaround 2 in the "Workaround" section.

Back to the top

Symptom 2b

Consider the following scenario. You run a macro that was created in an earlier version of Access. The macro has the OutputTo action or the SendObject action. In the macro action, the value of the Object Type argument is Report, and the value of the Output Format argument is Microsoft Excel 97-2003. In this scenario, you may receive the following error message:When you click OK in the Action Failed dialog box, error 2950 is displayed.

See workaround 2 in the "Workaround" section.

Back to the top

Symptom 3

Consider the following scenario. You run a Microsoft Visual Basic for Applications (VBA) procedure that contains the SendObject method. In this method, the value of the ObjectType argument is acSendReport, and the value of the OutputFormat argument is acFormatXLS. Alternatively, you run a VBA procedure that contains the OutputTo method. In this method, the value of the ObjectType argument is acOutputReport, and the value of the OutputFormat argument is acFormatXLS. In this scenario, you may receive the following error message:See workaround 3 in the "Workaround" section.

Back to the top

Workaround 1

To work around symptom 1 in the "Symptoms" section, use one of the following methods.

Method 1

In the navigation pane, right-click the table or query that is bound to the report, point to Export, and then click Excel. Then, follow the wizard to finish the export.

Method 2

In the navigation pane, right-click the report that you want to export, point to Export, and then select another format. For example, select one of the following formats:

•	Word RTF file
•	PDF or XPS
•	Access Database
•	Text File
•	XML File
•	Snapshot Viewer
•	HTML Document

Back to the top

Workaround 2

To work around symptom 2a and symptom 2b in the "Symptoms" section, use one of the following methods.

Method 1

In the macro action, change the value of the Object Type argument to either Table or Query. Additionally, change the value of the Object Name argument to the record source of the report.

Method 2

1.	In the Action Arguments for the OutputTo macro action or SendObject macro action, select another format in the Output Format list. For example, select one of the following formats: • HTML • Rich Text Format • Snapshot Format • Text Files
2.	Change the value of the Output File argument to the correct file name extension.

Back to the top

Workaround 3

To work around symptom 3 in "Symptoms" section, use one of the following methods.

Method 1

1.	In the VBA procedure, change the value of the ObjectType argument to one of the following: • acSendTable • acSendQuery • acOutputTable • acOutputQuery
2.	Change the value of the ObjectName argument to the record source of the report.

Method 2

1.	In the VBA procedure, change the value of the OutputTo argument to another value. For example, change the value of the OutputTo argument to one of the following values: • acFormatPDF • acFormatRTF • acFormatSNP • acFormatTXT • acFormatXPS
2.	Change the value of the OutputFile argument to the correct file name extension.

Back to the top

This behavior is by design. You cannot export reports to the Excel format in Access 2007. Microsoft has disabled this functionality.

Back to the top

To use one of the following file formats in the 2007 Microsoft Office system, download the corresponding 2007 Microsoft Office add-in:

•	PDF
•	Snapshot
•	XPS

The following table lists these file formats, their corresponding add-ins, and the Microsoft Web sites for downloading the add-ins:

File format	2007 Microsoft Office add-in	Microsoft Web site
PDF	Microsoft Save as PDF or XPS	http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041 (http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041)
PDF	Microsoft Save as PDF	http://www.microsoft.com/downloads/details.aspx?familyid=F1FC413C-6D89-4F15-991B-63B07BA5F2E5 (http://www.microsoft.com/downloads/details.aspx?familyid=F1FC413C-6D89-4F15-991B-63B07BA5F2E5)
Snapshot	Snapshot Viewer for Microsoft Access	http://www.microsoft.com/downloads/details.aspx?FamilyID=b73df33f-6d74-423d-8274-8b7e6313edfb (http://www.microsoft.com/downloads/details.aspx?FamilyID=b73df33f-6d74-423d-8274-8b7e6313edfb)
XPS	Microsoft Save as PDF or XPS	http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041 (http://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041)
XPS	Microsoft Save as XPS	http://www.microsoft.com/downloads/details.aspx?familyid=BCE8F991-F0A4-47A0-866B-2FD84A329E02 (http://www.microsoft.com/downloads/details.aspx?familyid=BCE8F991-F0A4-47A0-866B-2FD84A329E02)

Back to the top