| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy worksheets to control file
Does anyone know what code I could use to copy sheets from several files in
the same folder into a master control file? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheets to control file
Check out Ron de Bruin's site.
http://www.rondebruin.nl/tips.htm Browse through the codes you find under his Copy/Paste/Merge Examples. Gord Dibben MS Excel MVP On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery" wrote: Does anyone know what code I could use to copy sheets from several files in the same folder into a master control file? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheets to control file
Thanks Gord, I'll have a look.
Jim "Gord Dibben" wrote in message ... Check out Ron de Bruin's site. http://www.rondebruin.nl/tips.htm Browse through the codes you find under his Copy/Paste/Merge Examples. Gord Dibben MS Excel MVP On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery" wrote: Does anyone know what code I could use to copy sheets from several files in the same folder into a master control file? |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Copy worksheets to control file
Good luck........note the "merge data from all workbooks in a folder" Add-in.
Gord On Mon, 20 Jun 2011 22:05:05 +0100, "Jim Lavery" wrote: Thanks Gord, I'll have a look. Jim "Gord Dibben" wrote in message .. . Check out Ron de Bruin's site. http://www.rondebruin.nl/tips.htm Browse through the codes you find under his Copy/Paste/Merge Examples. Gord Dibben MS Excel MVP On Mon, 20 Jun 2011 19:58:12 +0100, "Jim Lavery" wrote: Does anyone know what code I could use to copy sheets from several files in the same folder into a master control file? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How keep links when copy worksheets to another file? | Excel Discussion (Misc queries) | |||
| Copy cell from Excel file and paste into control on internet page | Excel Programming | |||
| copy multiple worksheets of a workbook, and paste onto a Word document ( either create new doc file or paste onto an existing file.) I need this done by VBA, Excel Macro | Excel Programming | |||
| copy Excel worksheets into one text file | Excel Programming | |||
| Copy worksheets into new file | Excel Programming | |||
Hybrid Mode
