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: Fenrirg Dailmaran
Country: South Sudan
Language: English (Spanish)
Genre: Marketing
Published (Last): 10 July 2011
Pages: 133
PDF File Size: 15.39 Mb
ePub File Size: 2.40 Mb
ISBN: 681-8-29720-884-6
Downloads: 44608
Price: Free* [*Free Regsitration Required]
Uploader: Zoloshakar

Document Not Saved Error on ExportAsFixedFormat

Select Worksheets “Label Template – X”. That was it, thanks much. This site in other languages x. This thread is locked. Range “C11” Sheets “Sheet3”.

Most of the time the code would work, but sometimes it would not. ereor

I could not capture the screen after a crash, and capturing the various window contents did not help: There is an interesting approach to trying to export the file multple times to a server location here: Want to add to the discussion?

Am I missing a reference to a specific. How satisfied are you with this reply? Did this solve your problem? I think exportasfixedformah not about the code itself but something is off on my machine that I am not able exportasfixedfor,at figure out. Later I’ll do it with Excel Congratulations and thank you to these contributors Date User CP By clicking “Post Your Answer”, you acknowledge that you have read our updated terms of serviceeerror policy and cookie policyand that your continued use of the website is subject to these policies.


Running unattended, sometimes there was no valid printer.

Virus or malware infection that has corrupted Windows system files or Windows Operating System-related program files. Any help greatly appreciated Thanks NJ.

Some Excel commands, including the command to save as a. Thread Tools Show Printable Version. After a rigorous test of one time, it worked. Thanks for the suggestions. The time expotrasfixedformat is By using our site, you acknowledge that you have read and understand our Cookie PolicyPrivacy Policyand our Terms of Service. If I manually type in the same information that is brought in by strPdfFinalPath2 it works fine.

Comments are not for extended discussion; this conversation has been moved to chat. Friday, October 20, 2: Try saving it in your Documents folder.

Using the SysInternals Strings utility to inspect the. Cells vaRows i2. On Error GoTo 0. Error exporting eerror workbooks to PDF, please help Well isn’t that curious?!?! 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.


[SOLVED] Report Generator Fix – Run-time error ”: Doc not saved

Share it with others Like this thread? You can help protect yourself from scammers by verifying that the contact is a Microsoft Agent or Microsoft Employee and that exportasfixeddormat phone number is an official Microsoft global customer service number. Range “C17” Sheets “Sheet3”. Stack Overflow works best with JavaScript enabled. Therefore, depending on accidents of timing, sometimes the end-of-day Excel program would see a valid, available default printer, sometimes not.

Well eportasfixedformat that curious?!?! Resize 624.

Email Required, but never shown. Prior to executing this particular Sub, the worksheet is unhidden and unprotected.