Open Excel file stored on Web

[tianung]

I have an Excel file stored on the web.

I would like users to be able to access a certain URL or internet
address of some description to open the Excel file in Excel itself
(not in Internet Explorer).

I've tried using VBscript (by itself as a .vbs file) but it throws up
a warning when the user accesses it. Similarly, if the VBscript is
embedded in an html file, an ugly ActiveX warning is thrown up at the
user.

Is there any way of avoiding these warnings ? Is there another way ?
Thanks for your help.

 

[Joel]

The filename in a workbook open statement can have 3 formates

set bk = workbooks.open(Filename:=FName)

where FName can be

1) "c:\temp\book1.xls"
2) "\\mydrive\temp\book1.xls"
3) "//www.microsoft.com/abc/book1.xls" provided the proper access
priviledges are ganted.

 

[royUK]

Chip Pearson has a method that can be adapted for your needs

'Downloading A File' (http://www.cpearson.com/excel/DownloadFile.aspx