this is an excellent bit of code.

I'm wondering how I can specify a path for the usage log - as I don't
want it stored where the worksheet is.

I've tried this:

Code:
--------------------
Open "Cs_Fs1\Prodvol\Techserv\PMR\Reporting\" & Left(ActiveWorkbook.Name, _
Len(ActiveWorkbook.Name) - 4) & "_usage.log" For Append As #1
--------------------
but it doesn't work.

i've also tried putting '\\' before the path, as per my drive mappings
in windows explorer.

can anyone suggest how I can specify a path?

thanks,
Matt


--
matpj
------------------------------------------------------------------------
matpj's Profile: http://www.excelforum.com/member.php...o&userid=21076
View this thread: http://www.excelforum.com/showthread...hreadid=523717