Have a gander at the link he
http://www.rondebruin.nl/tips.htm
or
http://www.exceltip.com/show_tip/Fil...Excel/357.html
Corey....
"C_Ascheman" wrote in message
...
I have an old workbook that contains 5 sheets with data, and out dated
code.
Is there a way to copy everything from the old workbook to a new workbook
with the updated code without opening the old workbook? I would like to
have
one of the new workbooks opened with the data contained from the old
workbook. Any help, or ideas is greatly appreciated on this.

C_Ascheman