Access Excel on a Server via the Internet

Hi Everyone :wave: ,

I would like to know how I can host an excel file on a server that would allow a user to access , view and modify/add some content to the file via the internet without downloading the file itself. Each user will access a copy of this file that they will be able to use and save any changes, under their own name, they may have made back to the server for future use. The user should not have the option to download the file, save it on their computer or be able to view or change certain cells, columns, rows or view the VBA code behind it. The user will access the file via a website using a provided login and password. While the file is open and in use by the user, some cells will be updated in real time drawing on information and values from 3rd party software (DDE links).

While the overall structure seems to be fairly straightforward – a server, a website and excel. It becomes murky :confused: when I try to work out the details in how exactly to connect the three. I understand that ActiveX plug-in maybe needed in order to allow the user to open the excel file in IE but I have a feeling there maybe something more to it than just that.

I would like to know your opinion and view on the best approach to achieve this task.

Sonia

Welcome to VBForums :wave:

Thread moved to Office Development/VBA forum (note that the "VB Editor" in Office programs is actually VBA rather than VB, so the VB6 forum is not really apt)

What you want to do isn't really possible, no matter what interface the user has (Excel itself or inside IE), they still need to download the file.

Opening it inside IE might hide "Save As", but even if it does the file is still saved on their computer (in "Temporary Internet Files") and may not ever be deleted. Many users are aware of that, so will be able to do whatever they like with the file.


There are two ways I can think of that would keep it more secure.

One is to create a web based app (such as ASP pages) that would provide the interface for them (using textboxes etc on the page), but I don't know if your DDE links would be possible.

The other is to create a desktop app (using proper VB6, or VB.Net) which again provides the interface for them (using textboxes etc on the form(s)).

Other people might have other ideas.

Thank you for your comment. I have come across Microsoft Office SharePoint Server. This maybe the solution that I am looking for. Currently exploring and I hope this will allow me to solve the problem.