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