Re: macro to search and unzip and collect to total amount
Richie:
thank you!!you are so kind.your macros are wonderful.but i still cannot reach my purpose.i still don't know how to search the files within a dir with so many zip files.i am a newer to study vba.forgive me!
i have a dir that have so many zipfiles named by date(like 20041202.rar in the attachment,each of them can be unzipped to a.xls and b.xls). now i want to search and unzip files of this month,read data from every a.xls. and finally collect to total amount in total.xls.how to create the macro??thanks in advance.
