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

Mark Forums Read

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 »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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 06:09 AM.