You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Macro to save file with active cell value with 3 date options

No replies
gilisan's picture
User offline. Last seen 10 years 17 weeks ago. Offline
Joined: 06/26/2010
Posts: 1

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.