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):||8 August 2010|
|PDF File Size:||19.64 Mb|
|ePub File Size:||1.5 Mb|
|Price:||Free* [*Free Regsitration Required]|
It just creates Acrobat tab in ribbon. I need it to be a namedchangable Filename as it archives saves this daily and uses that date as exportasfixedformag of the name. I will have to try all different options and see what works or not Thanks NJ.
The content you requested has been removed.
Document Not Saved Error on ExportAsFixedFormat – Daily Dose of Excel
In my case, failing to work properly meant crashing without generating any error message. Below is a summary of how I solved it; ertor this will suggest some useful approaches you can use. I’ve gone as far as putting in code that spits out every property of the PageSetup collection to make sure that something is not blowing things up since the output depends so strictly on the page setup.
Sign up using Email and Password. Frogrammer-Analyst’s analysis is great, but the error is not that ambiguous.
VBA: Run-time Error ” after running a print to PDF macro : excel
I will have to try all different options and see what works or not. 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.
Run-time Error ” after running a print to PDF macro self. I love your DoEvents remark. However, I did notice something strange when comparing the. Had you thought of using slicers instead of manipulating the page field? Home Questions Tags Users Unanswered. Any help greatly appreciated Thanks NJ. Well isn’t that curious?!?! Issue was in the save path.
Why do you think that the ExportAsFixedFormat line is causing the error?? The document may be open, or an error may have been encountered when saving. Become a Redditor and subscribe to one of thousands of communities. I have the same question One benefit is that it produces only one PDF file with multiple pages. When I re-installed the default printer, Application.
Document Not Saved Error on ExportAsFixedFormat
Comments are not for extended discussion; this conversation has been moved to chat. Error exporting excel workbooks to PDF. All contents Copyright by MrExcel Publishing.
Thanks for the suggestions. Iterate through the page fields, saving the results off as values-only worksheets, all in the same workbook.
The PDFLabelSheets Sub does get called from another Sub invoked by a form’s button press which compiles a boatload of data into this tab, though I’ve ruled it out as the culprit as successive runs of just the PDF code will succeed then fail without running the exportasgixedformat code. Is there any advantage to export them separately and sew together after saving? On Error Resume Next.
That did not help. Glad it’s working now: In my example, I had left out the back slash before the file name.
I was wondering if I am missing any office components or any addins. Friday, October 20, 2: Public Sub Test ThisWorkbook.
Only thing I can think of is a reference for Adobe but I’ve tried all the ones I could find locally. I could copy fxportasfixedformat paste all to one worksheet with page breaks and just print that one worksheet. Want to add to the discussion?