Save file with date

In your button macro

Please Login or Register  to view this content.

Thanks alot brynbaker

I want the main file which name let say complain.xlsm remain in same place with original name, while copy of it create each time after pressing button.
Moreover complete right the Macro as i am weak in VBA, I will be grate full to you.

Regards

OK
Add a module.
Insert this code

Please Login or Register  to view this content.

In your workbook insert a button (form type not OLE) and associate it with macro saver in its context 9right click) menu.
Done.
end sub

still confuse.....more elaboration...sory for inconvenience.

Regards

Have you added the button yet? If not do so. Then post the file and I'll see about adding the macro for you.

Thanks Alot brynbaker
First of all sorry for late reply actually my home Office was corrupted and i want to do this experiment in home.

Any way i did in office and its works fine.
Slight change required if u please consider.

1. Can i save it on Custom folder different folder or drive from original file?
2. When i save file the original file closed i want original file remain open.
3. I want to save file three four time in a day with time Ex:153001Nov2012.xlsm (1530time 01Nov2012 date)

Regards and thanks again

My office Office crashed yesterday and needed reinstall to fix spurious 'Code execution was interupted' messages. Even with centraldistribution tools atht make it easy it took hours.
1. Yes, easy if it's fixed, else but I'll provide for you to specify each time
2. OK, see new code. Windows does save as so original must be reopened.
3. OK, see new code for 153001Nov2012.xlsm format

Please Login or Register  to view this content.

thanks alot brynbaker

its work but may be i unable to define that i dont want it always ask me to where to save, once i define it then it never ask where to save, moreover it auto understand whats time and date and save it.
Like if save it now then it save in E:\MIS Secretariate Data and file name should be 090002Nov2012.xlsm

May be i elaborate myself

REgards

Easy!

Please Login or Register  to view this content.

with due respect

its not save by time and date.......and original file closed...
Thanks in advance.

REgards

I'm losing the ability to type! One more try:

Please Login or Register  to view this content.

The macro must be in your personal macro file; if in the workbook itself, it stops at the penultimate line as the file closes, so cannot reopen.

Thank you for your patience.

Thanks brynbaker

Now its not save neither original file open.

simply recent code did nothing

I hope u will consider it again

Regards

Please run the macro step by step (locate it in VB editor, press F8 to step through each line, slowly enough to be sure they all run, especially the last one. Also try it with any other excel file but with the original file closed.