Hi, try this code Activeworkbook.saveas(Thiswookbook.path & "\" ClinentName & format(now (),"ddmmyyyyhhmm")&".xls")
With regards BALA On Jun 27, 5:14 pm, "Chidurala, Shrinivas " <shrinivas.chidur...@citi.com> wrote: > Dear Friends > > I want file should be save like client name with current date & time > > e.g. > > ICICIBANK270620091500 > > Regards, > Shrinivas > Query Unit > Securities Services > Global Transaction Services - India. > Ph: +91-80-41446339 > E-Mail: shrinivas.chidur...@citi.com --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
