Open Excel file stored on Web
 

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.

Open Excel file stored on Web
 

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.

"tianung" wrote:

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.

Open Excel file stored on Web
 

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

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


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site' (http://www.excel-it.com/)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=117511