try the attached macro change fldpth = "D:\my latest data\" this as per ur requirement
if you copy the code of( withsubfolder) to other workbook add Microsoft scripting run time reference in that workbook On Fri, Mar 25, 2011 at 6:13 PM, Dave <davidstev...@gmail.com> wrote: > Ashish, > > Thanks It works great, can you please make one change for me I want the > macro to start searching from c:\temp\vba always and traverse > sub-directories and not ask the operator any questions. > > thanks, > > Dave > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com <http://akoul.blogspot.com/> *akoul*.wordpress.com <http://akoul.wordpress.com/> My Linkedin Profile <http://in.linkedin.com/pub/ashish-koul/10/400/830> P Before printing, think about the environment. -- ---------------------------------------------------------------------------------- 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
file names.xlsm
Description: Binary data
