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