Forums New posts Search forums. What's new New posts New Excel articles Latest activity. New posts. Excel Articles Latest reviews Search Excel articles.
|Published (Last):||21 October 2012|
|PDF File Size:||13.85 Mb|
|ePub File Size:||19.67 Mb|
|Price:||Free* [*Free Regsitration Required]|
Forums New posts Search forums. What's new New posts New Excel articles Latest activity. New posts. Excel Articles Latest reviews Search Excel articles. Log in Register. Search titles only. Search Advanced search….
The closest I've gotten has failed after trying to export with Run Time Error , stating "document not saved. The document may be open, or an error may have been encountered when saving". Any idea what I can do here? There are two sheets, named Operation List and Tool List. Excel Range "B1". Last edited: Apr 20, Some videos you may like. Excel Facts. Click here to reveal answer. Joined Mar 10, Messages 19, Change the path and filename accordingly. Copy ActiveWorkbook.
Re: Error exporting excel workbooks to PDF, please help Thanks Domenic, I tried the code and it showed the publishing dialog but before it finished it threw up this error: Code:. Domenic said:. The following macro will create a single PDF containing the specified worksheets.
In my example, I had left out the back slash before the file name. It should have been Did you change the path to a valid one? Re: Error exporting excel workbooks to PDF, please help That's probably because you don't have permissions to save in the root directory.
Try saving it in your Documents folder. That was it, thanks much. That explains another issue I was having some time back. Hello Sirs, Maybe you can help me. I am getting the same exportaspdf failed error. Here is the code I am using. I have a command button in my data entry form, which when clicked will save a pdf file for sheet 4.
VBA Code:. You must log in or register to reply here. Watch MrExcel Video. Date and reference number being inserted into footer after the first page Started by dpaton05 Sunday at PM Replies: Calculating lost hours per week Started by gd6noob May 29, Replies: VBA Open. Invalid qualifier Started by dpaton05 May 26, Replies:
Workbook.ExportAsFixedFormat method (Excel)
Remember Me? Results 1 to 4 of 4. Thread Tools Show Printable Version. I am having trouble fixing this error that pops up. I have tried fixing this several ways and will get it to work for a few times and then it will break again.
Run time error below code