0 Comment

The error I am getting is: Runtime error ” Method ‘ExportAsFixedFormat’ of object ‘_worksheet’ failed I know the error is with the. ExportAsFixedFormat Type:=xlTypePDF, _ Filename:=”C:\” Run-time error ‘ ‘: Method ‘ExportAsFixedFormat’ of object ‘_Workbook’ failed. Recently, I was accusing ExportAsFixedFormat of causing a problem with some code. It turned out to not be the culprit. But I was suspicious.

Author: Zuzil Mikaramar
Country: Singapore
Language: English (Spanish)
Genre: Career
Published (Last): 23 January 2005
Pages: 374
PDF File Size: 16.38 Mb
ePub File Size: 14.25 Mb
ISBN: 731-8-94267-473-5
Downloads: 45000
Price: Free* [*Free Regsitration Required]
Uploader: Shabei

Become a Redditor and subscribe to one of thousands of communities. And I don’t want it to open after printing, so that’s false as well. Hi NJ, in your last post you had mentioned that,” I was wondering if I am missing any office components or any addins.

Resize 624. I probably just did the printing saving? If you were doing it manually from the menu options it would add an extra 80 odd tabs to your workbook in seconds and you could print then them all to PDF in one go.

Error exporting excel workbooks to PDF

I know from my experience with text files the File System Object needs to know which File is being referenced. GUN Replied on June 10, egror I finally tried having the VBA code save a copy of the workbook just prior to the point of failure. On the successful runs, the.


Am I missing a reference to a specific. Corruption in Windows registry from a recent Windows Operating System-related software change install or uninstall. There are two page fields, so there are two loops. Invalid procedure call or argument Error 5 Run-Time Error 5: Had you thought of using slicers instead of manipulating the page field? MS office professional plus Operating system: I just change a pivot table page filter and print the same range over and over.

Below is a summary of how I solved it; perhaps exportasgixedformat will suggest some useful approaches you can use.

Sorry this didn’t help. When I navigate to this worksheet manually and choose the export exportasfixedformqt from the file menu, I get the same error. Want to add to the discussion?

Excel save to PDF macro error

This could be due to editing after copying and pasting the code into your post but needs confirming. The following macro will create a single PDF containing the specified worksheets. Lopaka90 Replied on June 10, It turned out to not be the culprit. All contents Copyright by MrExcel Publishing. Edited by Ashidacchi Tuesday, October 25, I have this code that changes the page fields on a pivot table and exports a range. You may have to register before you can post: I’ve run the full gamut of tests.

In reply to Lopaka90’s post on June 10, This site uses cookies for analytics, personalized content and ads. And I feel like an idiot. That ultimately turned out to help me confirm its diagnosis.


ExportAsFixedFormat method throws invalid procedure call error at run time

There is a similar observation at can’t set PageSetup. I finally tried logging program execution milestones to a disk file, reopening and closing the file for each milestone, so no text would be lost if the program subsequently exporatsfixedformat.

Range “C11” Sheets “Sheet3”. Change the path and filename accordingly.

Document Not Saved Error on ExportAsFixedFormat

Wednesday, October 26, 7: You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that the phone number is an official Microsoft global customer service number.

In reply to OssieMac’s post on June 8, Deepak, thanks a lot for the direction. Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Notify me of followup comments via e-mail. You can select code in your VBA window, press Tab, then copy and paste into your thread or comment. There is an interesting approach to trying to export the file multple times to edror server location here:.