Change folder to save in

  • Thread starter Thread starter Mia
  • Start date Start date
M

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!
 
It worked, thank you so much!!!

Have a nice wekend!


--
Best regards
Mia


"Jacob Skaria" skrev:
 
Back
Top