Saving pdf

[jebenexcel]

ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="[I]path[/I]" & Firma & "\Offers\" & "OBR1_" & broj & "_" & Firma & "_" & Format(Now(), "dd.mm.yyyy") & ".pdf", Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, OpenAfterPublish:=False

path is juts your regular C:\etc path... getting an error 1004 on this... Why?
Firma is a string, broj is a number.

 

[yky]

If path is a string, you don't need to enclose it with double quotes.

What do you see in the debug window if you monitor the following expression?
"path" & Firma & "\Offers" & "OBR1_" & broj & "_" & Firma & "_" & Format(Now(), "dd.mm.yyyy") & ".pdf"

 

[jebenexcel]

Runtime error 1004;
Document not saved. The document may be open, or an error may have been encountered while saving.

 

[yky]

Remove the two double quotes enclosing the word "path" then run the code. What do you get?

 

[jebenexcel]

path is not a variable, it is the actual path in ""

 

[Fluff]

If Path is not a variable, then you need to remove it & put in the actual path

 

[yky]

Press F8 to step through the code line by line and monitor the following expression in the debug window. What does it show before the code in #1 is executed?

"path" & Firma & "\Offers" & "OBR1_" & broj & "_" & Firma & "_" & Format(Now(), "dd.mm.yyyy") & ".pdf"