Share via

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

Anonymous
2022-07-19T07:51:01+00:00

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

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

18 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-25T18:25:26+00:00

    yes having same error any fix

    0 comments
  2. Anonymous
    2022-08-25T19:13:57+00:00

    Updated Office with latest release (8/9/22) and working as expected now.

    0 comments
  3. Anonymous
    2022-09-23T02:34:32+00:00

    Cross posted... https://answers.microsoft.com/en-us/msoffice/forum/all/ms-access-cant-complete-the-output-operation/882ee01c-3e12-45df-8c22-ed73aa043c48?page=14

    I'm surprised it has not been mentioned before BUT....

    Regardless of which updates etc you install you will STILL experience the "Can't complete the output operation" when attempting to output to Excel if your macro settings are set to 'Disable all macros without notification' OR 'Disable all macros except digitally signed macros'.

    This occurs I believe because the export to Excel process involves a macro or code in the access utility.accda module which is now untrusted.

    You can change your macro settings in the Trust Center ( for 2016 - File, Options, Trust Center, Trust Center Settings, Macro Settings) Depending on your use case you can set to Enable all macros (which is not recommended) or Disable all macros WITH notification. This setting allows you to decide each time if you want to run the macro or not.

    The other issue I've seen is if you are not seeing all the export options in the ribbon you need to change a setting to display full menus. (File, Options, Current Database) scroll down to Ribbon and Toolbar options and **** ensure the tickbox is checked beside Allow Full Menus

    Close Access, restart and your problem should now be resolved.

    Note that an Access Security Notice window will pop when you try export to Excel, you should click Open to allow the export to proceed.

    0 comments