allow users to edit Excel over the web

P

peterswan

Hello,

I'd like to post an Excel spreadsheet on our company intranet and allo
users to access the file from the intranet through a simple <a href
tag, and then edit the file.

I know allowing the user to view the file is easy, but is there a wa
to get the user to edit the file as well?

Thanks, :)

Pete
 
P

peterswan

I found out there are a couple of ways to do this.

1. create a shortcut to the excel spreadsheet you want to open and lin
to this shortcut.

2. paste the following VBScript into your file:

<SCRIPT LANGUAGE=VBScript>
Dim objExcel
Sub Btn1_onclick()
call OpenWorkbook("path to your Excel file\test.xls") End Sub
Sub OpenWorkbook(strLocation)
Set objExcel = CreateObject("Excel.Application")
objExcel.Visible = true
objExcel.Workbooks.Open strLocation
objExcel.UserControl = true
End Sub
</SCRIPT>

<INPUT TYPE=BUTTON NAME=Btn1 VALUE="Open Excel File">

But you'll need to do the following for it to work on your server:

In browser go to Tools | Internet Options | Security | Custom Level.
By default Initalizing and Scripting ActiveX controls that are no
marked safe is disabled.
Change it from disabled to prompt, and the code here works

Now the file will open directly from the web to Excel, and the fil
will be editable.

Peter
:) :) :
 
Top