Hi Aman Can u please specify what kind of error you are facing.... which point the error comes.... does the file get saved.. or might be possible the file path doesnot exist.....
Thanks and Regards, Vivek Agrawal Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 23, 2009 at 9:34 PM, Aman Singh Aneja <amanan...@gmail.com>wrote: > Thanks - seems seem to be getting a 400 error > > I really appreciate your assistance, > > Sub save_file_on_time() > vYear = Year(Date) 'Current year > vMonth = Month(Date) 'Current Month > vDay = Day(Date) 'Current Day > vHour = Hour(Time) 'Current Hour > vMin = Minute(Time) 'Current Minute > vFileName = vYear & "-" & vMonth & "-" & vDay & "_" & vHour & vMin > 'Define the filename > vPath = "D:\extractfiles" ' Define the file path - can be > changed accordingly > ActiveWorkbook.SaveAs vPath & "\" & vFileName & ".xls" 'Saving > the workbook. > ActiveWorkbook.Close > End Sub > > > > On Jul 23, 12:55 am, vivek agrawal <vivek.agrawa...@gmail.com> wrote: > > Hi Aman > > Following is the code that performs your task.... now u can copy paste > this > > is the "personal" workbook and access the code while working with any > other > > application. > > > > ======================================== > > Sub save_file_on_time() > > > > vYear = Year(Date) 'Current year > > > > vMonth = Month(Date) 'Current Month > > > > vDay = Day(Date) 'Current Day > > > > vHour = Hour(Time) 'Current Hour > > > > vMin = Minute(Time) 'Current Minute > > > > vFileName = vYear & "-" & vMonth & "-" & vDay & "_" & vHour & vMin > > 'Define the filename > > > > vPath = "D:\extractfiles" ' Define the file path - can be changed > > accordingly > > > > ActiveWorkbook.SaveAs vPath & "\" & vFileName & ".xls" 'Saving the > > workbook. > > > > ActiveWorkbook.Close > > > > End Sub > > ============================================== > > > > Hope this helps... else you can always mail back.. > > > > Regards, > > Vivek Agrawal > > Skype ID - vivek.agrawal83 > > > > GoogleMoonlight.com - Saving energy-Save Earth > > > > On Thu, Jul 23, 2009 at 6:41 AM, Aman Singh Aneja <amanan...@gmail.com > >wrote: > > > > > > > > > > > > > Hello Everyone > > > > > Been following the group and have found many useful tips – so thank > > > you. > > > > > Wanted to know if anyone could help me – > > > > > I would like to create a button in Excel that saves the file > > > automatically with the following names in the d:\extractfiles folder > > > and closes the current window. > > > > > File name should be : YYYY-MM-DD_HHMM.xls > > > > > Since I have to create multiple files during the day I would not like > > > have to manually enter that. > > > > > Any help would be greatly appreciated!!! > --~--~---------~--~----~------------~-------~--~----~ ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~----------~----~----~----~------~----~------~--~---
