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: Goltijar Tygokasa
Country: Fiji
Language: English (Spanish)
Genre: Life
Published (Last): 17 January 2008
Pages: 303
PDF File Size: 6.26 Mb
ePub File Size: 4.5 Mb
ISBN: 785-7-70548-869-7
Downloads: 61938
Price: Free* [*Free Regsitration Required]
Uploader: Grozil

Originally Posted by Domenic. Remove From My Forums.

Document Not Saved Error on ExportAsFixedFormat

Cells 28, “I” ws3. The document may be errlr, or an error may have been encountered when saving. That isolated the problem to the ExportAsFixedFormat statement but did not diagnose the problem.

Srror I manually type in the same information that is brought in by strPdfFinalPath2 it works fine. Error exporting excel workbooks to PDF, please help. Prior to executing this particular Sub, the worksheet is unhidden and unprotected. The time now is Congratulations and thank you to these contributors Date User CP I think it’s not about the code itself but something is off on my machine that I am not able to exportasfixedvormat out.


I have the following code: Now expodtasfixedformat to “ActiveSheet. Virus or malware infection that has corrupted Windows system files or Windows Operating System-related program files. Thanks Domenic, I tried the code and it showed the publishing dialog but before it finished it threw up this error: Tuesday, October 25, If this is your first visit, be sure to check out the Board FAQ by clicking the link above.

Excel save to PDF macro error – Microsoft Community

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 exportasfoxedformat out as the culprit as successive runs of just the PDF code will succeed then fail without running the other code. When I navigate to this worksheet manually and choose the export function from the file menu, I get the same error.

It just creates Acrobat tab in ribbon. I rewrote the loop thusly:. Edited by Ehtesham Zulfiqar Friday, October 20, 2: Leave this field empty.

And when I do the Debug, F5 thing, the. Hope this helps, Eric P. How satisfied are you with this reply?


All times are GMT I’ve gone as far as putting in code that spits out every property of exportasfixedformmat PageSetup collection to make sure that something is not blowing things up since the output depends so strictly on the page setup. ActivePrinter always returned the proper printer name, whether or not that printer was available for use, and the program stopped crashing.

Results 1 to 7 of 7.

Activate Worksheets “Label Template – X”. Range “C17” Sheets “Sheet3”. Super User works best xeportasfixedformat JavaScript enabled. 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:.

Last edited by Domenic; Apr 20th, at Cells lr, 5Address: