What format are your report files in? On Apr 26, 11:46 am, "Chidurala, Shrinivas " <shrinivas.chidur...@citi.com> wrote: > Please help. > > Regards, > Shrinivas > Citi(r) Global Transaction Services - India > UB City, Canberra Block, # 24, Vittal Mallya Road, > Bangalore - 56 00 01. > Ph - +91-80-4144 6339 / 6340 > Email - shrinivas.chidur...@citi.com > > > > > > > > -----Original Message----- > From: Chidurala, Shrinivas [ICG-GTS] > Sent: Monday, April 25, 2011 9:10 PM > To: excel-macros@googlegroups.com > Subject: Multiple file Formatting > > Dear Gurus, > > I have created the attached macro for formatting of 50 to 60 files everyday > which are receive from system. But to run this macro i need to open and then > run. It taking too much time. > > Please can you advise to prepare the macro which will give facility do > similar formatting of all files at a time, if i save all files in specific > folder. > > Find attached sample file for your reference. > > Thanks in Advance > > Regards, > Shrinivas
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel