I had understood your question correct.
I have excel 2003. With DisplayAlerts set to False
the Download box does not pop up.
Sharad
"Ajit" wrote in message
...
I mean a progress bar

"Ajit" wrote:

That doesn't work. The downloading status still comes up.
I think DisplayAlert property is used any time a message requires a
response. Is my assumption correct.

Or may be i wasn't too clear in what i mean't
Actually whem i am opening the URL
Workbooks.Open"http://www.yourdomain.com/yourfile.xls"). It shows a
downloading box for a second.

Any Ideas!

Thanks,

"Sharad" wrote:


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!