Hi Frank,
Wow,...if I open log.xls before I start the logging macro everything works
smootly.
But I don't want the user to notice "log.xls "beeeing accesed neither before
start using "test.xls" nor after.
Martyn

"Frank Kabel" wrote in message
...
Hi Marty
to solve this error try the following:
1. Open log.xls before you start this logging macro and see if this
error stil exist
2. Enable screenupdating and insert a breakpoint after opening log.xls
and see if this workbook is really opened. If not probably the workbook
is not found

--
Regards
Frank Kabel
Frankfurt, Germany