Excel macro for Save As option

Hi Guys,

I have just started to create macro by using record option to hide and unhide Columns and now I need to have a complex macro in my report.

The requirements are as below once you click on the command button

1). It should take you to save as option in xls Format. Currently my file is in xlsm format.
2). The file should be saved in the same part of the file which is open now.
3). The file should have the file name as entered in Cell A1
4). If possible it should also remove all the macros in worksheet.

Since I am new to writing or creating Macro, I need step by Step guidance in creating or additing this macro to my report.

Thanks for your support

Regards,
SJ Chirayath..