With VBA, whether Excel 2003 or Excel 2007, is the FSO sequence and
for Each Workbook in Collection the only way for a simple copy without
data manipulation ?
Thank you for the light,
J.P.

Hi u473

See this page
http://www.rondebruin.nl/folder.htm

--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"u473" wrote in message ...
With VBA, whether Excel 2003 or Excel 2007, is the FSO sequence and
for Each Workbook in Collection the only way for a simple copy without
data manipulation ?
Thank you for the light,
J.P.

Are we to understand that you want to copy each file to another folder and
have the same file in each folder? If so, make a new foldercopy all files
to it.....

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"u473" wrote in message
...
With VBA, whether Excel 2003 or Excel 2007, is the FSO sequence and
for Each Workbook in Collection the only way for a simple copy without
data manipulation ?
Thank you for the light,
J.P.