Now it is not very clear what you mean by users 'not having access to
the server'.
Do you mean that the user can access the intranet over the internet, but
do not have direct access to the server through LAN?

If this is the case then the path entered as
'\\servername\foldername\subfoldername\filename' will not work for those
who are not connected to the server through LAN.

There is also no need to copy the file on to local PC. Just open the
file, and as long as it is open, even if the user disconnects from the
intranet the file will remain open on the PC.
You can use the URL of file to open the file.
e.g. "
Dim intraBook As Workbook
Set intraBook = Workbooks.Open
_("http://www.yourdomain.com/yourfile.xls") 'complete url
'If you must save then save it
intraBook.SaveAs "C:\localfoldername\filename.xls"

Sharad


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!