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):||10 June 2005|
|PDF File Size:||2.34 Mb|
|ePub File Size:||17.24 Mb|
|Price:||Free* [*Free Regsitration Required]|
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
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.
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??