When people are copying the file to a local folder are they copying the
XLS or a webpage? I'm assuming it is an XLS file they are copying and
not a webpage.

You can shorten the location you are looking for. This isn't very
sophisticated. A file opened from a non web location won't be put into
the temporary Internet Files folder.


if instr(thisworkbook.Fullname , _
"Local Settings\Temporary Internet Files") 0 then


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=180187

Microsoft Office Help