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

Martyn wrote:
Hi Frank,
No I haven't figured out the problem. It's still there...:(
---
Martyn

"Frank Kabel" wrote in message
...
Hi
Have you figured out the problem or is the error still there?

--
Regards
Frank Kabel
Frankfurt, Germany

Martyn wrote:
It's already there...
Martyn

"Frank Kabel" wrote in message
...
Hi
the log.xls workbook has to be put in the path: D:\temp\ (or you
may change the path variable assignement)

--
Regards
Frank Kabel
Frankfurt, Germany