ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Launching Excel From internet Explorer (https://www.excelbanter.com/excel-discussion-misc-queries/96295-launching-excel-internet-explorer.html)

pjnesbitt

Launching Excel From internet Explorer
 

Hi
I know it is possible to change the settings within internet explorer
to launch excel when a link is clicked but i need this web page to run
on more than one machine, so i was wondering if it is possible to use a
script in the web page that would make excel launch when the link is
clicked.
I have found a script that will work for a word document and have tried
to change it so it will function for excel but it doesn't work, any
suggestions?????:confused:
Below is the script i have been trying,
<HTML
<HEAD
<SCRIPT LANGUAGE=VBScript
Dim ojbexecl
Sub Btn1_onclick()
call Openxls("file:///P:\Test.xls")
End Sub

Sub Openxls(strLocation)

Set objexecl = CreateObject("Excel.Application")
objexecl.Visible = true
objexecl.Spreasheets.Open strLocation
End Sub

</SCRIPT

</HEAD
<BODY
<INPUT TYPE=BUTTON NAME=Btn1 VALUE="Test.xls"
</BODY
</HTML


--
pjnesbitt
------------------------------------------------------------------------
pjnesbitt's Profile: http://www.excelforum.com/member.php...o&userid=35827
View this thread: http://www.excelforum.com/showthread...hreadid=556068



All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com