Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save workbook i specified folder
Hi,
I cant get my code right to save my workbook in a specified folder, do anyone know whats wrong with the code? FilenameStr = ("http://srv.he.com/ekon/Fakturor/A/2010/ & Rapp/") & _ ActiveSheet.Range("b8").Value & " " & ".pdf" Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful! -- Best regards Mia |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save workbook i specified folder
My not working code a
Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful for help! -- Best regards Mia "Mia" skrev: Hi, I cant get my code right to save my workbook in a specified folder, do anyone know whats wrong with the code? FilenameStr = ("http://srv.he.com/ekon/Fakturor/A/2010/ & Rapp/") & _ ActiveSheet.Range("b8").Value & " " & ".pdf" Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful! -- Best regards Mia |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save workbook i specified folder
You are including a space for example run the following and checkout the
address. Furthermore, do checkout that u don't have any special invalid characters in B3: Sub TEST() Dim Rapp As String Rapp = ActiveSheet.Range("B3") MsgBox "http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " " End Sub -- Thanx in advance, Best Regards, Faraz "Mia" wrote: My not working code a Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful for help! -- Best regards Mia "Mia" skrev: Hi, I cant get my code right to save my workbook in a specified folder, do anyone know whats wrong with the code? FilenameStr = ("http://srv.he.com/ekon/Fakturor/A/2010/ & Rapp/") & _ ActiveSheet.Range("b8").Value & " " & ".pdf" Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful! -- Best regards Mia |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Save workbook i specified folder
Hi,
Your test code are working but I still don't get my code to work. -- Best regards Mia "Faraz A. Qureshi" skrev: You are including a space for example run the following and checkout the address. Furthermore, do checkout that u don't have any special invalid characters in B3: Sub TEST() Dim Rapp As String Rapp = ActiveSheet.Range("B3") MsgBox "http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " " End Sub -- Thanx in advance, Best Regards, Faraz "Mia" wrote: My not working code a Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful for help! -- Best regards Mia "Mia" skrev: Hi, I cant get my code right to save my workbook in a specified folder, do anyone know whats wrong with the code? FilenameStr = ("http://srv.he.com/ekon/Fakturor/A/2010/ & Rapp/") & _ ActiveSheet.Range("b8").Value & " " & ".pdf" Dim Rapp As String Rapp = ActiveSheet.Range("B3") ActiveWorkbook.SaveAs ("http://srv.he.com/ekon/Fakturor/A/2010/" & _ Rapp & "/" & "Astra" & " " & Rapp & " ") Activewokbooks.Close I'l be wery grateful! -- Best regards Mia |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save Workbook with existing Name in the Folder | Excel Programming | |||
Force a Readonly Workbook to save to a different folder | Excel Discussion (Misc queries) | |||
save workbook created from templete to a specific folder | Excel Discussion (Misc queries) | |||
code to save the whole folder with a workbook | Excel Programming | |||
code to save the whole folder in which is the workbook | Excel Programming |