Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open a workbook using a stored name | Excel Programming | |||
using a workbook to open more workbooks with filenames stored in cells | Excel Programming | |||
FYI: One macro really helped for capturing data from multiple workbook stored in a specific folder to one excel file only | Excel Programming | |||
Capture data in one 'destination' file from varied 'source' file stored in one single folder. | Excel Programming | |||
In Excel - Use Windows Explorer instead of File Open to open file | Excel Discussion (Misc queries) |