How can I use Excel to calculate orders in Frontpage webform?

[Adolf Ezeribe]

I need to insert an Excel Spreadsheet in my Frontpage webform to calculate a
site visitor's orders when the visitor makes products selections from list
boxes.

How do I link the list box selections with the cells in the spreadsheet web
component to enable automatic calculation of order totals?

How can I link the selection to another file containing unit prices for the
products selected?

Please help

Adolf

 

[Stefan B Rusynko]

You can't use Excel for form calculation
To use form calculation you need to use JavaScript

You should be looking at Access for your datasource for prices
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I need to insert an Excel Spreadsheet in my Frontpage webform to calculate a
| site visitor's orders when the visitor makes products selections from list
| boxes.
|
| How do I link the list box selections with the cells in the spreadsheet web
| component to enable automatic calculation of order totals?
|
| How can I link the selection to another file containing unit prices for the
| products selected?
|
| Please help
|
| Adolf

 

[Adolf Ezeribe]

Thank you Stefan,
But there is an Excel Spreadsheet 'Web Component' in Frontpage and there is
the 'HOST ()' Function in it to allow online form calculation design. My
problem is how to use the Function and its syntax. In other words, how can I
feed the list box data into the spreadsheet cells as addresses so that the
site visitor's click will appear in the spreadsheet cells?

Adolf Ezeribe

 

[Thomas A. Rowe]

In order to use the Excel web component, the server must have the Office Web component installed and
every visitor to your site must be using Windows with IE and have Excel installed.

You need to looking into use Access and the FP database component (ASP/VBScript)
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

Thank you Stefan,
But there is an Excel Spreadsheet 'Web Component' in Frontpage and there is
the 'HOST ()' Function in it to allow online form calculation design. My
problem is how to use the Function and its syntax. In other words, how can I
feed the list box data into the spreadsheet cells as addresses so that the
site visitor's click will appear in the spreadsheet cells?

Adolf Ezeribe

You can't use Excel for form calculation
To use form calculation you need to use JavaScript

You should be looking at Access for your datasource for prices
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I need to insert an Excel Spreadsheet in my Frontpage webform to calculate a
| site visitor's orders when the visitor makes products selections from list
| boxes.
|
| How do I link the list box selections with the cells in the spreadsheet web
| component to enable automatic calculation of order totals?
|
| How can I link the selection to another file containing unit prices for the
| products selected?
|
| Please help
|
| Adolf

 

[Adolf Ezeribe]

Thanks a lot, Rowe,

I appreciate the explanation. I'll begin learning to do what you said. I am
not familiar with the procedure. Maybe you send me a page on how to use
access and VBScript for the purpose of online calculations of a customer's
orders or products selections.
Again, thank you very much and hoping to hear again from you.
Adolf

In order to use the Excel web component, the server must have the Office Web component installed and
every visitor to your site must be using Windows with IE and have Excel installed.

You need to looking into use Access and the FP database component (ASP/VBScript)
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

Thank you Stefan,
But there is an Excel Spreadsheet 'Web Component' in Frontpage and there is
the 'HOST ()' Function in it to allow online form calculation design. My
problem is how to use the Function and its syntax. In other words, how can I
feed the list box data into the spreadsheet cells as addresses so that the
site visitor's click will appear in the spreadsheet cells?

Adolf Ezeribe

You can't use Excel for form calculation
To use form calculation you need to use JavaScript

You should be looking at Access for your datasource for prices
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I need to insert an Excel Spreadsheet in my Frontpage webform to calculate a
| site visitor's orders when the visitor makes products selections from list
| boxes.
|
| How do I link the list box selections with the cells in the spreadsheet web
| component to enable automatic calculation of order totals?
|
| How can I link the selection to another file containing unit prices for the
| products selected?
|
| Please help
|
| Adolf

 

[Thomas A. Rowe]

I would suggest you use a pre-written shopping cart application, as there is a lot involved in
writing a shopping cart application from scratch.

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

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

Thanks a lot, Rowe,

I appreciate the explanation. I'll begin learning to do what you said. I am
not familiar with the procedure. Maybe you send me a page on how to use
access and VBScript for the purpose of online calculations of a customer's
orders or products selections.
Again, thank you very much and hoping to hear again from you.
Adolf

In order to use the Excel web component, the server must have the Office Web component installed
and
every visitor to your site must be using Windows with IE and have Excel installed.

You need to looking into use Access and the FP database component (ASP/VBScript)
--
==============================================
Thomas A. Rowe
Microsoft MVP - FrontPage

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

Thank you Stefan,
But there is an Excel Spreadsheet 'Web Component' in Frontpage and there is
the 'HOST ()' Function in it to allow online form calculation design. My
problem is how to use the Function and its syntax. In other words, how can I
feed the list box data into the spreadsheet cells as addresses so that the
site visitor's click will appear in the spreadsheet cells?

Adolf Ezeribe

:

You can't use Excel for form calculation
To use form calculation you need to use JavaScript

You should be looking at Access for your datasource for prices
--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


|I need to insert an Excel Spreadsheet in my Frontpage webform to calculate a
| site visitor's orders when the visitor makes products selections from list
| boxes.
|
| How do I link the list box selections with the cells in the spreadsheet web
| component to enable automatic calculation of order totals?
|
| How can I link the selection to another file containing unit prices for the
| products selected?
|
| Please help
|
| Adolf