View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Metin[_3_] Metin[_3_] is offline
external usenet poster
 
Posts: 3
Default Save file, refer filename to cell and change directory

Hi

I have the following macro to change my filename

Sub save_with_cell(
Dim fnam
fname = Worksheets("General info").Range("C47").Value & "#" & Range("C26").Valu
fname = fname & ".xls
ActiveWorkbook.SaveAs Filename:=fnam
End Su

I want also get my file saved in a specific folder in a other directory. Can anybody tell me how to do that