Loop through folder of workbooks and copy range to other workbook

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Loop through folder of workbooks and copy range to other workbook

FAQ

Thread Tools

Display Modes

07-29-2011, 01:27 AM

Snvlsfoal

Windows XP Loop through folder of workbooks and copy range to other workbook

Office 2004 for Mac

Banned

Join Date: Jul 2011

Posts: 9

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!!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
outlook 2003 always not remove temp copy of opened attachments in temporary folder	c.itech	Outlook	0	06-20-2011 10:34 PM
macro to transfer data from one workbook to another workbook	virsojour	Excel Programming	5	02-01-2011 08:58 PM
Select a range in one one workbook while working in other workbook	Slow&Steady	Excel	1	02-21-2010 03:34 AM
Copy email to another folder	loc	Outlook	0	12-26-2006 07:39 AM
Page Numbering in Workbooks & Print set up problem	mdouble588	Excel	0	05-21-2006 10:29 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:52 AM.