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.
|Published (Last):||23 January 2005|
|PDF File Size:||16.38 Mb|
|ePub File Size:||14.25 Mb|
|Price:||Free* [*Free Regsitration Required]|
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.
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?
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.
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.
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.
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:.