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


G

Guest

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
 
Ad

Advertisements

S

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
 
G

Guest

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
 
T

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
==============================================


Adolf Ezeribe said:
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

Stefan B Rusynko said:
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
 
G

Guest

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

Thomas A. Rowe said:
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
==============================================


Adolf Ezeribe said:
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

Stefan B Rusynko said:
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
 
Ad

Advertisements

T

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
==============================================


Adolf Ezeribe said:
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

Thomas A. Rowe said:
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
==============================================


Adolf Ezeribe said:
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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top