Excel Form used in Front Page 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an excel form that I use that is attached to a inventory list. I am
able to just enter the title of the product and the product number and qty in
stock automatically populates in seperate cells.
Is it possible to use this same form in a Front Page form and have the same
information populate when the product title is entered?
If this is possible is it possible to have this form emailed to me as an
excel spreadsheet since I print these product requests on a special paper and
will have a special kind of format to fit on this paper?
 
If you want to use Excel as a datasource (to populate your form) see
http://support.microsoft.com/default.aspx?scid=268948
You can only use Excel worksheet as OWC
- but users must have Excel and OWC
See http://support.microsoft.com/kb/828950/en-us
No you can not email the excel worksheet

IMH
Redo your application to use an Access DB w/ the form to get your data and save the results
- then you can use the Access DB to generate you printed copies

--

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


|I have an excel form that I use that is attached to a inventory list. I am
| able to just enter the title of the product and the product number and qty in
| stock automatically populates in seperate cells.
| Is it possible to use this same form in a Front Page form and have the same
| information populate when the product title is entered?
| If this is possible is it possible to have this form emailed to me as an
| excel spreadsheet since I print these product requests on a special paper and
| will have a special kind of format to fit on this paper?
 
Office Web Components.


Christine said:
What is OWC. I'm sorry, I'm still new to this so if you can explain in
simpler terms.

Stefan B Rusynko said:
If you want to use Excel as a datasource (to populate your form) see
http://support.microsoft.com/default.aspx?scid=268948
You can only use Excel worksheet as OWC
- but users must have Excel and OWC
See http://support.microsoft.com/kb/828950/en-us
No you can not email the excel worksheet

IMH
Redo your application to use an Access DB w/ the form to get your data
and save the results
- then you can use the Access DB to generate you printed copies

--

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


|I have an excel form that I use that is attached to a inventory list. I
am
| able to just enter the title of the product and the product number and
qty in
| stock automatically populates in seperate cells.
| Is it possible to use this same form in a Front Page form and have the
same
| information populate when the product title is entered?
| If this is possible is it possible to have this form emailed to me as
an
| excel spreadsheet since I print these product requests on a special
paper and
| will have a special kind of format to fit on this paper?
Click to expand...
Click to expand...
 
Back
Top