Dear All,

I am looking for a macro to save a file name with active cell value(where the cursor is placed) and with 3 date options.

Date options = a pop-up should come-up with buttons asking A B and C. If I click A = save the file with today's date. Click B = yesterday's date and Click C = day before yesterday's date.

In brief the flow of the macro should be:

Open the excel file>>>Place the cursor on the cell which should be the filename(the name may be anywhere in the sheet)>>> run the macro >>> A pop-up with with button A B and C>>> say click on B>>> file should be saved in a drive path with the file name and yesterday's date like _xyz_20100626.xls

Could anybody help me in building this macro for me, I would be greatful to them and this may change my life in the office I work.

Thanks a lot in advance for helping me.