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: Magul Mazuzuru
Country: Mauritius
Language: English (Spanish)
Genre: Literature
Published (Last): 10 June 2005
Pages: 56
PDF File Size: 2.34 Mb
ePub File Size: 17.24 Mb
ISBN: 191-9-29961-344-7
Downloads: 38082
Price: Free* [*Free Regsitration Required]
Uploader: Akijin

Excel save to PDF macro error

The problem occurs when the function is lost and is not mapped to any drive. Excel for Developers https: Tony Baker 21 1 2.

Ordinarily, during the day this computer prints to a laser printer set as the exportasflxedformat printer attached to another computer on the network, and that other computer is turned off at the end of the working day.

Share it with others Like this thread? When I re-installed the default printer, Application.

Document Not Saved Error on ExportAsFixedFormat

Edited by Ehtesham Zulfiqar Friday, October 20, 2: I have the same question Select Worksheets “Label Template – X”. As a result, Windows is unable to find and load it and displays the error exportasfixedforjat. By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceprivacy policy and cookie policyand that your continued use of the website is subject to these policies. And when I do the Debug, F5 thing, the.


Thanks Domenic, I tried the code and it showed the publishing dialog but before it finished it threw up this exportasfixedforamt This thread is locked. Therefore, depending on accidents of timing, sometimes the end-of-day Excel program would see a valid, available default printer, sometimes not. Originally Posted by Domenic.

My Excel VBA code was running under Windows 7 as an unattended, end-of-day scheduled task in the background, usually when no one was logged in.

Corruption in Windows registry from a recent Windows Operating System-related software change install or uninstall. For Each rCell In.

Any sugesstions would be appreciated. Am I missing a reference to a specific. By using our site, you acknowledge that you have read and understand our Exporatsfixedformat PolicyPrivacy Policyand our Terms of Service.

I need it to be a namedchangable Filename as it exportasfixedfprmat saves this daily and uses that date as part of the name. Cells lastRow, 5Address: I can script its command line to insert bookmarks and other cool stuff.

VBA error while exporting to PDF – Super User

When the error happens, a. If I click around in that worksheet for a bit the Export function as well as the Macro work. That explains another issue I was having some time back. Corrupt download or incomplete installation of Windows Operating System software.


Some Excel commands, including the command to save as a. Had you thought of using slicers instead drror manipulating the page field? Home Questions Tags Users Unanswered.

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

Lopaka90 Created on June 7, Error exporting excel workbooks to PDF, please help That’s probably because you don’t have permissions to save in errog root directory. Last edited by Billy Hill; Apr 20th, at The first time I saw the described behavior was the first time I tried using this particular function in Excel Windows 10though I’m not sure that’s the cause.

Why do you think that the ExportAsFixedFormat line is causing the error??