JannetteChristie
Board Regular
- Joined
- Dec 14, 2015
- Messages
- 130
- Office Version
- 365
My code is as follows:
I am getting the error message Run-time error '-2147024773 (8007007b)': Document not saved.
I have no idea what is wrong with the code - can anyone help ?
JobName = ActiveSheet.Range("Salesman") & " - Weekly Report: w/c " & Sheets("Analysis").Range("FromDate")
TempFileName = Environ$("temp") & "" & JobName & ".pdf"
' TempFileName = "c:\Users" & JobName & ".pdf"
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _
Filename:=TempFileName, _
OpenAfterPublish:=False
I am getting the error message Run-time error '-2147024773 (8007007b)': Document not saved.
Watch : : TempFileName : "C:\Users\jchri\AppData\Local\Temp\Frazer Ross - Weekly Report: w/c 04/06/2018.pdf"
Watch : : JobName : "Frazer Ross - Weekly Report: w/c 04/06/2018" : String : Module2.SubmitData
I have no idea what is wrong with the code - can anyone help ?