ChDir

[jebenexcel]

Hello,

Why doesn't this work?
The error is in the line that starts with ChDir abc & ""...

abc = "C:\a\b\c"
f = Range("A1")


       Sheets("1").Select
[B]       ChDir abc & "\" & f & "\" & "\g"[/B]
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
        "a" & "_" & f & "_" & Format(Now(), "dd.mm.yyyy") & ".pdf" _
        , Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
        :=False, OpenAfterPublish:=False

 

[RoryA]

What's the error message?

Note you don't really need to us ChDir at all there - you can simply specify the full path and file name in the following export line.

 

[jebenexcel]

error 76, path not found
So basically if I just remove ChDir and leave pšart of the path as a string it should work?

 

[Stiuart_W]

error 76, path not found
So basically if I just remove ChDir and leave pšart of the path as a string it should work?

Yes


If you set filename to "C:\a\b\c" & "" & f & "" & "\g" & "a" & "_" & f & "_" & Format(Now(), "dd.mm.yyyy") & ".pdf"



Notice the extra "" after the "g"

 

[RoryA]

That is the gist but it sounds as though your path is invalid, so that will probably fail too! You need to make sure the path you specify actually exists.