I want to dynamically link a value on a FrontPage HTML page to a specific
cell (ie: A3) in a particular Excel file. Is there a way to do this so that
the HMTL is current with whatever value is entered into cell A3 in the Excel
file?
thank you!

You *should* (didn't test) be able to go to that cell, then
Insert-->Name-->Define and give the cell a name. Then, something like:
http://myweb.com/myfile.xls#definedname

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"musicman2112" <(E-Mail Removed)> wrote in message
news:BE0B32ED-F9AE-4C2E-91CB-(E-Mail Removed)...
>I want to dynamically link a value on a FrontPage HTML page to a specific
> cell (ie: A3) in a particular Excel file. Is there a way to do this so
> that
> the HMTL is current with whatever value is entered into cell A3 in the
> Excel
> file?
> thank you!

I may not have stated my scenario very well. That did work in regards to a
hyperlink, but I actually want to populate a particular location in the
FrontPage document with the value in cell A3 of the Excel file (or of that
named field).

"Anne Troy" wrote:

> You *should* (didn't test) be able to go to that cell, then
> Insert-->Name-->Define and give the cell a name. Then, something like:
> http://myweb.com/myfile.xls#definedname
>
> ************
> Hope it helps!
> Anne Troy
> www.OfficeArticles.com
> Check out the NEWsgroup stats!
> Check out: www.ExcelUserConference.com
>
> "musicman2112" <(E-Mail Removed)> wrote in message
> news:BE0B32ED-F9AE-4C2E-91CB-(E-Mail Removed)...
> >I want to dynamically link a value on a FrontPage HTML page to a specific
> > cell (ie: A3) in a particular Excel file. Is there a way to do this so
> > that
> > the HMTL is current with whatever value is entered into cell A3 in the
> > Excel
> > file?
> > thank you!
>
>
>

Oh. I don't think you'll get html (FrontPage) to do that... but that's just
a first guess. Maybe someone else knows better what to use.

************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"musicman2112" <(E-Mail Removed)> wrote in message
news:9A6B6EE1-5F8B-4F6A-ABC1-(E-Mail Removed)...
>I may not have stated my scenario very well. That did work in regards to a
> hyperlink, but I actually want to populate a particular location in the
> FrontPage document with the value in cell A3 of the Excel file (or of that
> named field).
>
> "Anne Troy" wrote:
>
>> You *should* (didn't test) be able to go to that cell, then
>> Insert-->Name-->Define and give the cell a name. Then, something like:
>> http://myweb.com/myfile.xls#definedname
>>
>> ************
>> Hope it helps!
>> Anne Troy
>> www.OfficeArticles.com
>> Check out the NEWsgroup stats!
>> Check out: www.ExcelUserConference.com
>>
>> "musicman2112" <(E-Mail Removed)> wrote in message
>> news:BE0B32ED-F9AE-4C2E-91CB-(E-Mail Removed)...
>> >I want to dynamically link a value on a FrontPage HTML page to a
>> >specific
>> > cell (ie: A3) in a particular Excel file. Is there a way to do this so
>> > that
>> > the HMTL is current with whatever value is entered into cell A3 in the
>> > Excel
>> > file?
>> > thank you!
>>
>>
>>

No.

What you really need is a server side script solution or a small database.


--
Steve Easton
Microsoft MVP FrontPage
95isalive
This site is best viewed............
........................with a computer



"musicman2112" <(E-Mail Removed)> wrote in message
news:9A6B6EE1-5F8B-4F6A-ABC1-(E-Mail Removed)...
>I may not have stated my scenario very well. That did work in regards to a
> hyperlink, but I actually want to populate a particular location in the
> FrontPage document with the value in cell A3 of the Excel file (or of that
> named field).
>
> "Anne Troy" wrote:
>
>> You *should* (didn't test) be able to go to that cell, then
>> Insert-->Name-->Define and give the cell a name. Then, something like:
>> http://myweb.com/myfile.xls#definedname
>>
>> ************
>> Hope it helps!
>> Anne Troy
>> www.OfficeArticles.com
>> Check out the NEWsgroup stats!
>> Check out: www.ExcelUserConference.com
>>
>> "musicman2112" <(E-Mail Removed)> wrote in message
>> news:BE0B32ED-F9AE-4C2E-91CB-(E-Mail Removed)...
>> >I want to dynamically link a value on a FrontPage HTML page to a
>> >specific
>> > cell (ie: A3) in a particular Excel file. Is there a way to do this so
>> > that
>> > the HMTL is current with whatever value is entered into cell A3 in the
>> > Excel
>> > file?
>> > thank you!
>>
>>
>>

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.frontpagemvps.com/FrontPa...3/Default.aspx
_____________________________________________


"musicman2112" <(E-Mail Removed)> wrote in message news:9A6B6EE1-5F8B-4F6A-ABC1-(E-Mail Removed)...
|I may not have stated my scenario very well. That did work in regards to a
| hyperlink, but I actually want to populate a particular location in the
| FrontPage document with the value in cell A3 of the Excel file (or of that
| named field).
|
| "Anne Troy" wrote:
|
| > You *should* (didn't test) be able to go to that cell, then
| > Insert-->Name-->Define and give the cell a name. Then, something like:
| > http://myweb.com/myfile.xls#definedname
| >
| > ************
| > Hope it helps!
| > Anne Troy
| > www.OfficeArticles.com
| > Check out the NEWsgroup stats!
| > Check out: www.ExcelUserConference.com
| >
| > "musicman2112" <(E-Mail Removed)> wrote in message
| > news:BE0B32ED-F9AE-4C2E-91CB-(E-Mail Removed)...
| > >I want to dynamically link a value on a FrontPage HTML page to a specific
| > > cell (ie: A3) in a particular Excel file. Is there a way to do this so
| > > that
| > > the HMTL is current with whatever value is entered into cell A3 in the
| > > Excel
| > > file?
| > > thank you!
| >
| >
| >