Excel Help

[Mason64]

I have just started using excel in the last 48 hours. but i am having problems. I need to make a save button.

What i want the save button to do is when you click the save button it saves the file as a name which is on A3 for example and then saves it to a location i tell it to ( the location will always be the same for example x:\excelwork\filename.xlsx

Does anyone know how to do this?

 

[Makhaira]

You'll need to implement this via visual basic - if you Google there are lots of examples.

 

[namnoc]

Just add the macro below and change the path to wherever you want it..........


Sub save()
'
' save Macro
'
' Keyboard Shortcut: Ctrl+s
'
ThisFile = "C:\Users\Cliff\Desktop\" + Range("A3").Value
ActiveWorkbook.SaveAs Filename:=ThisFile
End Sub