Excel Value in FP Form

[Guest]

Is there a simple way to display an Excel cell value in a FP generated page?

I have an ordering page where staff my first check inventory in a separate
spreadsheet linked as a hyperlink on our intranet.

What I would like to do is something like this

name of item Current inventory order amount

where the order amount is a FP form item that they input. The Inventory
would come from a predetermined cell on the inventory spreadsheet. I dont
even care to compare the two values to make sure they don't order more than
we have.

Any simple suggestions?

Thanks

 

[Kevin Spencer]

Database Results.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Neither a follower
nor a lender be.

 

[Stefan B Rusynko]

See http://support.microsoft.com/default.aspx?scid=268948

--




| Is there a simple way to display an Excel cell value in a FP generated page?
|
| I have an ordering page where staff my first check inventory in a separate
| spreadsheet linked as a hyperlink on our intranet.
|
| What I would like to do is something like this
|
| name of item Current inventory order amount
|
| where the order amount is a FP form item that they input. The Inventory
| would come from a predetermined cell on the inventory spreadsheet. I dont
| even care to compare the two values to make sure they don't order more than
| we have.
|
| Any simple suggestions?
|
| Thanks

 

[Guest]

This works for an entire sheet

But in my case I have 50 rows in Excel (and growing to 100) and I want to
populate a single cell in each of 50 rows of a table within a form in FP 2002.

 

[Stefan B Rusynko]

The link at the bottom of the article went on to explain extracting data from the workbook
See http://support.microsoft.com/kb/190195/EN-US/

--




| This works for an entire sheet
|
| But in my case I have 50 rows in Excel (and growing to 100) and I want to
| populate a single cell in each of 50 rows of a table within a form in FP 2002.
|
|
|
| "Stefan B Rusynko" wrote:
|
| > See http://support.microsoft.com/default.aspx?scid=268948
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | Is there a simple way to display an Excel cell value in a FP generated page?
| > |
| > | I have an ordering page where staff my first check inventory in a separate
| > | spreadsheet linked as a hyperlink on our intranet.
| > |
| > | What I would like to do is something like this
| > |
| > | name of item Current inventory order amount
| > |
| > | where the order amount is a FP form item that they input. The Inventory
| > | would come from a predetermined cell on the inventory spreadsheet. I dont
| > | even care to compare the two values to make sure they don't order more than
| > | we have.
| > |
| > | Any simple suggestions?
| > |
| > | Thanks
| >
| >
| >