Hi Martyn
now I'm getting desperate :-)
If the path variable is declared as path="C:\"
and the lo´g_filename as
log_filename = "log.xls"

then the code snippet
If log_wbk Is Nothing Then
msgbox path & log_filename
Workbooks.Open filename:=path & log_filename
Set log_wbk = Workbooks(log_filename)
End If

should do. Does this msgbox returns the correct information?. I have
tested this again in my environment and everything works fine - also
took it to another PC - result was also o.k.

--
Regards
Frank Kabel
Frankfurt, Germany

Martyn wrote:
Yes it does !.

"Frank Kabel" wrote in message
...
Hi
can you put the following line in the Immediate window of the VBA
editor
Workbooks.Open Filename:="C:\log.xls"
and hit ENTER

Does this open the log.xls file?


--
Regards
Frank Kabel
Frankfurt, Germany