| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change folder to save in
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change folder to save in
Try
Dim Rapp As String Rapp = ActiveSheet.Range("B3") FilenameStr = "http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & ActiveSheet.Range("b8").Value & " " & ".pdf" -- Jacob "Mia" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change folder to save in
It worked, thank you so much!!!
Have a nice wekend! -- Best regards Mia "Jacob Skaria" skrev: Try Dim Rapp As String Rapp = ActiveSheet.Range("B3") FilenameStr = "http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & ActiveSheet.Range("b8").Value & " " & ".pdf" -- Jacob "Mia" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update workbooks in folder, new name and save in new folder | Excel Programming | |||
| Can I change Excel 2003 default "save to" folder? | Setting up and Configuration of Excel | |||
| Save file in a new folder, but create folder only if folder doesn't already exist? | Excel Programming | |||
| canĀ“t change folder when open or save | Excel Discussion (Misc queries) | |||
| Need code to save file to new folder, erase from old folder | Excel Discussion (Misc queries) | |||
Hybrid Mode
