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

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

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

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