Writing to Excel from Frontpage

J

Jimbo411

I have a complex set of spreadsheets which I want to take input from web
pages and place values into the Excel spreadsheets then retreive other values
and place them back onto the html page. Can anyone point me in the right
direction?
 
J

Jens Peter Karlsen [FP-MVP]

You will have to write a Web Service in ASP(.NET) that does this for
you. It is no simple task.
Have you considered a database instead? That will be much simpler and
you can have Excel get the data from there with a simple VBA Macro.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
 
J

Jimbo411

ASP seems to be the only option. I could use a database to store the html
input but how do I then seemlessly initiate the excel macro and present the
results back on the html page?
 
T

Thomas A. Rowe

You would use ASP/VBscript to display the data on your page. If needed, you can then use
ASP/VBscript to generate data output in Excel format.

--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

http://www.Ecom-Data.com
==============================================
 
Top