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?
 

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

Similar Threads

Access Form Refresh 1
Form / Inventory 2
Forms 4
Excel What does E mean in excel numbers? 1
Creating a form in Front Page 1
order forms in front page website? 1
Help With MS Access 4
Add/Subtract columns from tab to tab in same file 3

Back
Top