Is it possible to create an online form on a website from an excel
spreadsheet stored on a server.
Also, is it possible for an outsider to update certain fields?
Yes. Excel offers a usable COM programming interface and you can
easily connect to this from ASP (assuming a Windows box and an IIS
server).
There are various issues about performance for doing this on a large
site, about security for a public site, and about multi-user locking.
I wouldn't recommend it in most circumstances, but I'm sure you have
your reasons (hopefully an intranet).
You probably need to read up on three things; ASP coding (use JScript,
not VBScript), Excel coding (the Range object is your friend) and some
COM (Don Box's books are the ones to read). You should also be aware
of the security issues with widespread COM out the back-end of a
public web server, because otherwise you can build some monstrous
security holes.
The skills needed to do this aren't mainstream, although they're far
from rocket science. If you're in the UK, I'm a contract developer and
I'm looking for work
