Here is a example for all workbooks in a folder
http://www.rondebruin.nl/copy4.htm

You can see the code that you must use on that page
If you need more help post back

--

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


"Carl Irving" wrote in message ...
Is it possible for somebody to tell me the code i would need to open up a
password protected workbook, update the linked worksheets inside, then save
and close.