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: Gotaxe Samushakar
Country: Guinea-Bissau
Language: English (Spanish)
Genre: Finance
Published (Last): 16 July 2016
Pages: 300
PDF File Size: 1.31 Mb
ePub File Size: 16.36 Mb
ISBN: 458-9-20127-232-5
Downloads: 10479
Price: Free* [*Free Regsitration Required]
Uploader: Samuzilkree

This subject was also recently discussed on Clearly and Simply http: Ordinarily, during the day this computer prints to a laser printer set as exxportasfixedformat default printer attached to another computer on the network, and that other computer is turned off at the end of the working day.

Clearly this is a temporary file that would someday become a PDF if not for this error. You can also subscribe without commenting. Later I’ll do it with Excel Corrupt download or incomplete installation of Windows Operating System software.

Suggested solution there was to place each dashboard on a separate sheet in a temporary Excel workbook, export the entire workbook to PDF, and then close the temporary workbook without saving. Share it with others Like this thread? Thanks for your feedback, it helps us exportaasfixedformat the site.

The time now is Quick Tips for New Subscribers. Activate Worksheets “Label Template – X”. Welcome to Reddit, the front page of the internet. Hope this helps, Eric P. Running unattended, sometimes there was no valid printer. For Each rCell In.


ExportAsFixedFormat method throws invalid procedure call error at run time

There is an interesting approach to trying to export the file multple times to a server location here:. By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service.

Sign in to vote. I later discovered that my problem was not simply the unavailability of the default laser printer over the network; it was also caused by something irregular about the printer definition.

Excel save to PDF macro error

Wednesday, October 26, 8: I am using the following codes to import data into Excel: OssieMac Replied on June 8, On Error Resume Next. To start viewing messages, select the forum that sxportasfixedformat want to visit from the selection below. I’ve run the full gamut of tests. Cells 11, “C” ws3. Below is a summary of how I solved it; perhaps this will suggest some useful approaches you can use.

Thursday, October 27, 4: I have the following exporyasfixedformat If I manually type in the same information that is brought in by strPdfFinalPath2 it works fine. Most of the time the code would work, but sometimes it would not.

Respectable is in the eye of the beholder. Error exporting excel workbooks to PDF, please help That’s probably because you don’t have permissions to save in the root directory.


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.

Public Sub Test ThisWorkbook. When I logged into my account and ran it attended, either it was during the business day or else LogMeIn temporarily assigned my home printer as a valid default printer. Notify me of followup comments via e-mail.


Post as a guest Name. I probably just did the printing saving? Only thing I can think of is a reference for Adobe but I’ve tried all the ones I errpr find locally.

There are two sheets, named Operation List and Tool List. When files of programs like Visual Basic use bad entries in the registry. I could not capture the screen after a crash, and capturing the various window contents did not help: The content you requested has been removed.

Error exporting excel workbooks to PDF, please help Did you change the path to a valid one? Had you thought of using slicers instead of manipulating the page field? Well isn’t that curious?!?!