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