Copy the whole folder content to new location
 

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.

Copy the whole folder content to new location
 

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.

Copy the whole folder content to new location
 

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.