Thread: Loop through folder of workbooks and copy range to other workbook
View Single Post
 
Old 07-29-2011, 01:27 AM
Snvlsfoal Snvlsfoal is offline Windows XP Office 2004 for Mac
Banned
  
Join Date: Jul 2011
Posts: 9
Snvlsfoal is on a distinguished road
Default Loop through folder of workbooks and copy range to other workbook
Hi All,

I have Folder named "Test" in my D: drive. this folder has many workbooks with different names. i want to open one by one workbook and copy some range like a2:z500 and paste it to a destination workbook. please help me!!
Reply With Quote