Change folder to save in

[Mia]

Hi,

I'm using a vba-macro to automaticly save pdf-files at a specified folder.
Now I want the folder to update depending on what period Im in.
I have following code but I dont get i to work

Dim Rapp As String
Rapp = ActiveSheet.Range("B3")

FilenameStr = ("http://srv.he.com/ekon/Fakturor/A/2010/ & Rapp/") & _
ActiveSheet.Range("b8").Value & " " & ".pdf"

Do anyone know how to solve this I'll be wery grateful!

 

[Jacob Skaria]

Try

Dim Rapp As String
Rapp = ActiveSheet.Range("B3")

FilenameStr = "http://srv.he.com/ekon/Fakturor/A/2010/" & _
Rapp & "/" & ActiveSheet.Range("b8").Value & " " & ".pdf"

 

[Mia]

It worked, thank you so much!!!

Have a nice wekend!


--
Best regards
Mia


"Jacob Skaria" skrev: