Is anyone else encountering a stall with the "ExportAsFixedFormat" command in VBA as of a recent build of Office 365?

Anonymous
2023-06-28T16:24:46+00:00

There appears to have been an issue introduced in a recent build of Office 365 that has caused problems with the "ExportAsFixedFormat" command in VBA. I am using it to convert a Word document into separate pdfs, with one pdf per section in the Word document.

Intermittently, this command will cause an indefinite stall when running custom code, and it always stalls on the "ExportAsFixedFormat" command. There appears to be no discernible reason for the stall, and it does not occur consistently, though it does occur frequently. This issue seems to have appeared in or around Version 2305 (Build 16501.20228). Prior to this, the custom code worked flawlessly for many years. This problem is occurring across multiple machines, though the installations of Office 365 on which the problem has been observed have all been 64-bit to this point.

So far I've tried restarting the machine and repairing the installation of Office. Neither of these solved the problem. Because of the intermittent nature of when the problem occurs, it is hard to diagnose what is having any impact on when it works and when it doesn't.

I managed to stop my laptop from updating beyond Version 2305 *(*Build 16501.20210), and the code is still working correctly as of this build with no issues at all. My machine for which I am encountering the problem is on Version 2305 (Build 16501.20228), and I am not yet able to push it forward to Version 2306 (Build 16529.20154) yet to see if the problem persists into that version and build.

Microsoft 365 and Office | Word | For home | 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 No comments

3 answers

Sort by: Most helpful
  1. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2023-06-29T09:22:56+00:00

    @ReynaldoB Please do not suggest to users to go to the Microsoft Q&A forum.

    It akin to sending someone up the creek without a paddle.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  2. Doug Robbins - MVP - Office Apps and Services 323.6K Reputation points MVP Volunteer Moderator
    2023-06-29T09:18:54+00:00

    My Merge Tools Add-in, which uses the ExportAsFixedFormat command, is being used regularly by thousands of users, many of whom would be using Version 2305 (Build 16501.20228) and I have not had any reports of such an issue and have definitely not experience it myself.

    If you send me a copy of the document and the macro that you are using, referencing this thread in the covering email message, I will investigate the issue.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  3. Anonymous
    2023-06-29T02:32:02+00:00

    Hello Woodrow Ware

    Thank you for posting on the Microsoft community forums. I hope you are doing well.

    To better help you with your concern, we recommend posting your concern in our Microsoft Q&A forum to get answers about your concern on the VBA command that is not working. This way, the experts in these forums will be able to provide more specific information about your concern, so you can get exactly the result you want. We want you to get exactly the information and achieve the desired result. We'll leave this topic open if some virtual machines or other communities want to participate.

    Thank you for your understanding.

    Sincerely

    ReynaldoB

    Microsoft Community Forum Moderator

    Was this answer helpful?

    0 comments No comments