Excel ERROR The Visual Basic Code contains a Syntax Error/Output

Question

I am trying to export a generated file in my Access Program to Excel. Had no issues until last weeks update.

Code has not changed -- I can export to Word and Pdf still but getting an Error to Excel with Visual Basic Code Syntax Error.

Is anyone else having this issue?

Any thoughts on how to manipulate the issue

Thank you

Michelle

C:\PROGRAM FILES (X86)\MICROSOFT OFFICE\OFFICE16\ACCWIZ\UTILITY.ACCDA

Answer 1

Same issue.

Have Office o365 - From a Report - if I select External Data from Ribbon and try to export it to Excel, Text File or RTF, I get the error. If I go to the query that runs the report - I can export the query OK.

So, not even running any code - just using Microsoft's own External Data ribbon, error exists.

Issue just started about a week ago.

Answer 2

Hi All,

Sorry for the inconvenience caused.

This article Error when trying to open an ACCDE/MDE file created in a different version of Access lists the fix available for different versions of Access. We suggest you check the information in it.

If you have further questions, we suggest you focus on this thread MS Access "Can't complete the Output operation", the engineer in related team is monitoring this thread.

Thanks for your understanding and cooperation!

Sincerely,

Tina | Microsoft Community Moderator

Answer 3

How do I update mine - here is the product info:

Answer 4

Dear Tammie Denney,

Thank you for posting in Microsoft Community.

We suggest you check the Version and Channel of your Access from the Product Information page, as shown below.

And according to your Office product, you may refer to the information in this article to know issue introduced and fix available for your Office： Error when trying to open an ACCDE/MDE file created in a different version of Access (check the information in STATUS: WORKAROUND)

If fix for your Office product is available, you can update Office from File>Account>Update Options>Update Now.

If you have further questions, we recommend you try to reply in this thread MS Access "Can't complete the Output operation"as the engineers in the related team is monitoring this thread and will assist you further.

Thanks for your understanding and cooperation!

Sincerely,

Tina | Microsoft Community Moderator

Answer 5

I am having the same issue. I am trying to export a report from AD into Excel. The Specify Export Option displays "We will not import table relationships, calculated columns, validation rules, default values, and columns of certain legacy data types such as OLE object." which is new now. The previous view (when the export worked) is below in blue. With no specify export option message.

.

Current updates