Excel VBA run-time error 1004 "Application-defined or object-defined error"

Question

Dear All,

I have a macro to save excel sheet to pdf.

Sub DelieveryNotePDF()

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _

fileName:="Users:Shall:Library:Mobile Documents:com~apple~CloudDocs:Delievery Note:" & Range("g2").Value & " " & Format(Now, "dd/mm/yyyy") _

    , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _

    :=False, OpenAfterPublish:=True

End Sub

It works fine but after i press control+p to print a sheet & after that when i want to use the macro it doesn't work and i get the "run-time error 1004 : Application-defined or object-defined error".

I am using office for mac 2011.

waiting for your help

thankssss.....

Answer 1

yes i tried debuging it, but i get all the lines below in yellow Highlight

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, _

fileName:="Users:Shall:Library:Mobile Documents:com~apple~CloudDocs:Delievery Note:" & Range("g2").Value & " " & Format(Now, "dd/mm/yyyy"), _

    Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _

    :=False, OpenAfterPublish:=False

Answer 2

Have you tried to debug it?: Which line causes the error?

Answer 3

Yes i am sure of that, i have macro assigned to a button on multiple sheets and they all work but after printing a sheet none of them work. And i get that runtime error

Answer 4

It looks like your macro opens the sheet after it is saved. So, you need to be sure the correct sheet is active when you run the macro.