Hi Kwyjibo,
I'm wondering if its possible to embed an excel spread sheet inside
an HTML page. If I open the HTML page I should be able to view the
contents of the excel spread sheet and I can make changes directly
from the HTML page to the excel sheet and save the changes.
If you want the spreadsheet to be part of an HTML page (and not the whole
page), then you'll have to use the Office Web Components (more info here:
http://www.4guysfromrolla.com/webtech/022101-1.shtml). But be warned that
the licensing model for OWC is very strict, and I doubt you'd be able to use
it in a public environment.
If you don't mind that the spreadsheet is the only thing on the page, you
can save your Excel workbook as HTML (Save As Web Page from File menu). In
order for visitors to be able to save changes, either you must have them
authenticate using an account that has write permissions to the file on the
web server, or you must set up the anonymous account for the web server with
write permissions.
A third option is a third-party tool.
http://officewriter.softartisans.com/officewriter-37.aspx allows you to
read/create Excel documents on the web server without having Excel installed
there (installing Excel on the server is not recommended or supported by
MS).
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address unmonitored]
