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!


--
Best regards
Mia