Run time error 1004 document not saved

[PEAKCAB]

Good Morning All,

can anyone help on this issue? I have an invoice spread sheet that has worked fine for the past 12 months but this morning is giving the run time error 1004 document not saved. I have not changed anything in Macro. I have also noticed that if i run the purchase order version i have (running the same format) that also now comes up with the error. When running the macro, the debug brings me to the part below.

Any help would be much appreciated as i am loosing what little hair i have!


Sheets("Invoice").Range("A1:J66").ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"Y:\Dropbox\Accounts\Accounts\Sales\DELIVERY NOTES\SI" & Range("J22") & ".pdf", Quality:=xlQualityStandard, _
IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:= _
False

Regards,

Richard

 

[ChrisFoster]

Is the file path ( Y:\Dropbox\Accounts\Accounts\Sales\DELIVERY NOTES) still a valid path?

 

[PEAKCAB]

Is the file path ( Y:\Dropbox\Accounts\Accounts\Sales\DELIVERY NOTES) still a valid path?

Hello Chris,

Genius - change to fibre and new router must have changed setting so windows didn't like it. thanks very much

 

[ChrisFoster]

Hello Chris,

Genius - change to fibre and new router must have changed setting so windows didn't like it. thanks very much

You're welcome, and thank-you for the feedback.