'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel VBA Run-time Error 1004 When Saving as PDF
Question details
The user is experiencing a 'Run-time error 1004: Document not saved' in Microsoft Excel when running a VBA macro designed to save a worksheet as a PDF file.
- Product
- Microsoft Excel
- Device & OS
- Windows 10
- Scenario
- Running an existing VBA macro to export or save an Excel worksheet as a PDF to a local or network folder.
- Observed behavior
- The VBA macro abruptly fails with Error 1004, preventing any PDF from being created, despite working perfectly prior to a recent system or Office update.
Ensure that the destination folder specified in your VBA code actually exists, that you have sufficient write permissions for the directory, and that a PDF with the same name is not currently open in another application.
Open a Support Ticket for Bug Investigation
Since this error often surfaces after specific Windows or Microsoft 365 updates, reporting it via the admin center is the most direct path to an official patch.
When built-in macros suddenly fail across specific devices running identical update builds (like KB5048652), the root cause is frequently a software bug introduced by the update itself. Engaging IT support to open a ticket ensures Microsoft is aware of the capability failure.
Ask your IT department or Microsoft 365 administrator to log into the Microsoft 365 admin center.
Click on 'Support' in the left-hand navigation menu, then select 'New service request'.
Provide details about the 'Error 1004: Document not saved' issue, mentioning the specific Windows update version (e.g., KB5048652) and the VBA ExportAsFixedFormat method failure.
Perform an Online Repair of Microsoft Office
Repairing the Office installation can resolve underlying software corruption or missing components required for PDF generation.
Verify Output Path and Folder Permissions in VBA
VBA will throw Error 1004 if the specified directory in the code does not exist, contains invalid characters, or lacks correct write permissions.
Switch to WPS Office for Seamless PDF Export
If recurrent Microsoft Excel updates and VBA bugs are disrupting your workflow, consider switching to WPS Office. It provides robust spreadsheet capabilities, high compatibility with Microsoft Office formats, and built-in PDF conversion without the need to troubleshoot macro errors.
- 1. Download WPS Office: Visit the official WPS website and download the free WPS Office suite for Windows.
- 2. Open Your Workbook: Launch WPS Spreadsheets and open your existing Excel (.xlsx or .xlsm) file seamlessly.
- 3. Export to PDF Easily: Go to the Menu and click 'Export to PDF' to save your worksheets instantly, bypassing any need for complex macros.
Frequently Asked Questions
Why does VBA Error 1004 happen only on one computer?
Differences in background Windows updates (such as KB5048652), Office version builds, or local folder permissions can cause identical VBA code to fail on one machine while it continues to work flawlessly on another.
Can I roll back the Windows update to fix the VBA PDF error?
Yes, if a specific Windows update caused the PDF export failure, you can temporarily uninstall it by going to Settings > Update & Security > Windows Update > View update history > Uninstall updates, then rebooting your PC.
How do I save as PDF manually if the Excel macro fails?
You can easily bypass the VBA error by navigating to File > Save As, selecting PDF from the file format dropdown menu, and clicking Save. Alternatively, you can use File > Export > Create PDF/XPS Document.
