matt1112
05-22-2014, 01:54 PM
Hello,
Each day i receive a zip file containing multiple excel workbooks with differing file extensions (.csv, .dat,. and .xls). Some workbooks contains only one worksheet while others contain multiple. Each workbook's file name changes on a day to day basis.
I'm looking to create a macro to combine all worksheets from these workbooks into one workbook.
I've been searching for a way to do this but haven't been able to find a VBA code for my particular situation.
Please help.
Thanks,
Matt
Each day i receive a zip file containing multiple excel workbooks with differing file extensions (.csv, .dat,. and .xls). Some workbooks contains only one worksheet while others contain multiple. Each workbook's file name changes on a day to day basis.
I'm looking to create a macro to combine all worksheets from these workbooks into one workbook.
I've been searching for a way to do this but haven't been able to find a VBA code for my particular situation.
Please help.
Thanks,
Matt