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: Vugal Akijin
Country: Dominica
Language: English (Spanish)
Genre: Politics
Published (Last): 7 November 2017
Pages: 45
PDF File Size: 17.29 Mb
ePub File Size: 7.81 Mb
ISBN: 918-8-83646-471-1
Downloads: 16908
Price: Free* [*Free Regsitration Required]
Uploader: Kagagor

Thanks for your feedback, it helps us improve the site. Tell us about your experience with our site. I don’t want it to ignore the print area, so that’s false.

Therefore, depending on accidents of timing, sometimes the end-of-day Excel program would see a valid, available default printer, sometimes not.

Public Sub Test ThisWorkbook. I keep getting ” application-defined or object-defined error” and Run-time error” Document not saved. Invalid procedure call or argument Error 5. The problem occurs when the function is lost and is not mapped to any drive. The closest I’ve gotten has failed after trying to export with Run Time Errorstating “document not saved.

Document Not Saved Error on ExportAsFixedFormat

You can also subscribe without commenting. Error exporting excel workbooks to PDF, please help Thanks Domenic, I tried the code and it showed the publishing dialog but before it finished it threw up this error: Cells lr, 5Address: How satisfied are you with this reply?

But I’m not sure what the error is. Email Required, but never shown.

VBA: Run-time Error ” after running a print to PDF macro : excel

It should have been 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. Exportasfixdformat you ertor of using slicers instead of manipulating the page field? Glad it’s working now: OssieMac Replied on June 8, Leave a Reply Cancel reply Your email address will not be published.


Log in or sign up in seconds. Maybe comment out your current FullName line and use something like the following save to a generic location with a generic filename errpr to see if this is where you’re having the issue:. Maybe comment out your current FullName line and use something like the following save to a generic location with a generic filename just to see if this is where you’re having the issue: But after importing data I can’t export again.

I should have put a little loop counter in there to see how many times it errored.

I need it to be a namedchangable Filename as it archives saves this daily errror uses that date as part of the name. I am using the following codes to import data into Excel: In reply to OssieMac’s post on June 8, Error exporting excel workbooks to PDF, please help That’s probably because you don’t have permissions to save in the root directory.

Should have a space and an underscore for a line break and the spaces are missing from the first 2 line breaks. The most ecportasfixedformat part is it works sometimes.

Thanks for marking this as the answer. Error exporting excel workbooks to PDF, please help Well isn’t that curious?!?!

Error exporting excel workbooks to PDF

That explains another issue I was having some time back. While I doubt that this is your problem, I spotted a logic flaw that could potentially cause problems: I could not capture the screen exportasfixedflrmat a crash, and capturing the various window contents did not help: You will not have this issue if you login to the server using the user that is running the unattended script.


I am not sure if you were able to resolve the issue but I came across similar issue and the culprit in my case was that my sheet was hidden. Share it with others Like this thread?

Below is a summary of how I solved it; perhaps this will suggest some useful approaches you can use. Hope this helps, Eric P. Sign up using Facebook. My problem was a true Heisenbug — ereor disappeared whenever I re-ran the Excel workbook at random times.

Excel Core Concepts – Back to Basics. When files of programs like Visual Basic use bad entries in the registry.


I will have to try all different options and see what works or not Thanks NJ. By clicking “Post Your Answer”, you acknowledge that you have read exportasfixedformay updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. I have this code that changes the page fields on a pivot table and exports a exportaefixedformat.

Become a Registered Member free to remove the ads that appear in thread area. Excel for Developers https: Range “I28” Sheets “Sheet3”.

Related Posts