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" <(E-Mail Removed)> wrote in message news:9b8ed735-06bc-4845-aa41-(E-Mail Removed)...
> 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 folder>copy all files
to it.....

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"u473" <(E-Mail Removed)> wrote in message
news:9b8ed735-06bc-4845-aa41-(E-Mail Removed)...
> 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.