Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Open Excel session..?

Status
Not open for further replies.

kenjoswe

Technical User
Sep 19, 2000
327
SE
Hi all,

How can I open a new session of Excel from a html-page with VB-script?
I don't want to open Excel inside a Browser because of the limited Excel functionality (no Menubar,Standard toolbar,Formatting toolbar).

Can this be triggered from an On_Open event?

/Kent J.
 
Afternoon all,

hope this should help you:

Make a buttin named EXCELBUTTON and place the code below between your head tags.

You need to replace the test.xls withthe path to your sheet on the server or make a test.xls in the same directory as the web page to test it out.

<CODE>
<SCRIPT LANGUAGE=VBScript>
Dim objExcel

Sub Btn1_onclick()
Set objExcel = CreateObject(&quot;Excel.Application&quot;)
objExcel.Visible = true
objExcel.Workbooks.Open &quot;test.xls&quot;
objExcel.UserControl = true
End Sub
</SCRIPT>
</CODE>

Cheers 'mi casa es su casa'
]-=tty0=-[
ICQ:82621399
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top