View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Mia Mia is offline
external usenet poster
 
Posts: 101
Default 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