| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
for every workbook in folder
I have many workbooks in a single windows folder
They are all identical in structure but contain different data I need to paste some data into each from a single source sheet what I really would like is a routine which does a loop For every workbook in folder Open workbook Paste in data Save and Close workbook Is such a loop possible ? How? Many thanks -- Patrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for every workbook in folder
Hi Patrick
Try this http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Patrick" wrote in message ... I have many workbooks in a single windows folder They are all identical in structure but contain different data I need to paste some data into each from a single source sheet what I really would like is a routine which does a loop For every workbook in folder Open workbook Paste in data Save and Close workbook Is such a loop possible ? How? Many thanks -- Patrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
for every workbook in folder
Ron
wow - really helpful - working already Thank you Patrick "Ron de Bruin" wrote: Hi Patrick Try this http://www.rondebruin.nl/copy4.htm -- Regards Ron de Bruin http://www.rondebruin.nl "Patrick" wrote in message ... I have many workbooks in a single windows folder They are all identical in structure but contain different data I need to paste some data into each from a single source sheet what I really would like is a routine which does a loop For every workbook in folder Open workbook Paste in data Save and Close workbook Is such a loop possible ? How? Many thanks -- Patrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Workbook saved in FTP folder | Excel Discussion (Misc queries) | |||
| Move Active Workbook to another Folder | Excel Discussion (Misc queries) | |||
| Link with workbook in other folder which is in another group | Excel Discussion (Misc queries) | |||
| Do same thing to each workbook found in a folder | Excel Programming | |||
| New Folder, Workbook, and Worksheet | Excel Programming | |||
Linear Mode
