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
Bookmarks