M
Metin
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
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