Visual Basic Run-Time Error 1004

GCramer · Aug 17th 2020

So I have a macro enabled workbook with multiple tabs. as part of the macro, it converts all the tabs to a pdf as part of a package. There is code to select the parent directory to 'print' the pdf documents to. The problem is that when you first open the template from SharePoint and save it somewhere to use, it works fine. Issue is once you've saved it somewhere and then try to move it to another folder and use it, it errors out with the 1004 error stating:

"Document not saved. The document may be open, or an error may have been encountered when saving."

Odd thing is I'm not trying to save the document at all, just run the print to parent directory macro. Below is the code. It gets to the line that starts with wksSheet.ExportAsFixedFormat line and this is where the error occurs. Can't seem to figure out why it works when first saved, but if the file is moved it errors out. Any ideas?

Code

'Sheet by sheet, export to PDF using standard naming convention
'First sheet fully annotated, the remainder are similar
Application.ScreenUpdating = False
'Cover Page
'Select the page to export
Sheets("Cover Page").Select
'Set it as the active sheet
Set wksSheet = ActiveSheet
'Export the worksheet as a PDF with the specified filename
'ThisWorkbook.Path selects the parent directory
'& allows you to concatenate strings of text along with variables
'Naming includes the document number, part number pulled from the sheet, and worksheet name
wksSheet.ExportAsFixedFormat Type:=xlTypePDF, fileName:= _
ThisWorkbook.Path & "\0 - " & Sheet1.Range("L7") & " " & wksSheet.Name, Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False

Display More

**royUK** · Aug 18th 2020

Please read the Forum Rules before posting again I have added Code Tags this time.

Then add an example workbook.

GCramer · Aug 19th 2020

Thank you and apologies. I will just stick with Google

**royUK** · Aug 19th 2020

If you think you can get better help from Google then good luck. It's not much to ask you to follow a few simple rules to get free help.

GCramer · Aug 19th 2020

Didn't mean anything by it. Just that Google has served me well for over 3 years until I was recommended this site.

I did search through Google and found what I needed and my problem has now be resolved.

**royUK** · Aug 19th 2020

It's good Forum etiquette to share solutions in case they help someone else. Our rules aren't rules just guidance how to use the Forum correctly and get the most out of it

GCramer · Aug 19th 2020

No solution only that it was resolved. Once the file is saved the root directory is set and copying the file and then pasting it into a new location breaks that. Just a matter of knowing that the save location is correct when used. The file in question is a single time use file for developing PPAP submissions. Company policy prohibits us from sharing internal documents online.