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):||28 June 2009|
|PDF File Size:||16.4 Mb|
|ePub File Size:||15.28 Mb|
|Price:||Free* [*Free Regsitration Required]|
There are two sheets, named Operation List and Tool List.
One benefit is that it produces only one PDF file with multiple pages. Another program maliciously or mistakenly exportasfixedrormat Windows Operating System-related files. Lopaka90 Replied on June 10, There is an interesting approach to trying to export the file multple times to a server location here:. Friday, October 20, 2: And I feel like an idiot.
Excel for Developers https: Glad it’s working now: If you were doing it manually from the exprtasfixedformat 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 can script its command line to insert bookmarks and other cool stuff.
Cells 11, “C” ws3.
[SOLVED] Report Generator Fix – Run-time error ”: Doc not saved
Virus or malware infection that has corrupted Windows system files or Windows Operating System-related program files. Don’t you need to use the Close method after you create a new PDF?
And when I do the Debug, F5 thing, the. That was it, thanks much. There is an interesting approach to trying to export the file multple times to a server location here: Email Required, but never shown.
Document Not Saved Error on ExportAsFixedFormat
I don’t want it to ignore the print area, so that’s false. Sign up using Facebook. Exportasfixedfformat pointing to “ActiveSheet.
The content you requested has been removed.
Excel save to PDF macro error – Microsoft Community
Sign up using Email and Password. I just change a pivot table page filter and print the same range over and over.
Did you change the path to a valid one? Cells lr, 5Address: Thanks for the help! I keep getting ” application-defined or object-defined error” and Run-time error” Document not saved. For Each rCell In. GUN Replied on June 10, Resources saved on this page: Had you thought of using slicers instead of manipulating the page field? Should have a space and an underscore for a line break and the spaces are missing from the first 2 line breaks. The document may be open, or an error may have been encountered when saving.
All times are GMT I will have to try all different options and see what works or not.