Hyperlink contents of a cell in an Excel sheet into a web button

[Marc Issler]

My web design has interactive buttons that have links directly to an ethernet
address (eg. http://111.222.333.444).

There is an Excel spreadsheet that the addresses reside in (cells in the
sheet contain the text "http://111.222.333.444")

I would like to hyperlink a cell's content into a button on the web sheet.
So far, all I can do is load the entire spread sheet, not just 1 cell's
content. The Excel sheet has the cells named, but there does not seem to be
any ablity to reference the cell ID (E14) or its name.

Advice here will allow my site to be automatically kept up to date from
these hyperlinks rather than manual typing.

 

[Stefan B Rusynko]

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

--

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


| My web design has interactive buttons that have links directly to an ethernet
| address (eg. http://111.222.333.444).
|
| There is an Excel spreadsheet that the addresses reside in (cells in the
| sheet contain the text "http://111.222.333.444")
|
| I would like to hyperlink a cell's content into a button on the web sheet.
| So far, all I can do is load the entire spread sheet, not just 1 cell's
| content. The Excel sheet has the cells named, but there does not seem to be
| any ablity to reference the cell ID (E14) or its name.
|
| Advice here will allow my site to be automatically kept up to date from
| these hyperlinks rather than manual typing.
| --
| Marc
|

 

[Marc Issler]

The instructions in the link you gave me were for FrontPage 2000 ... it may
not be different for FrontPage 2003 but it still did not answer the question.
There was no method described to bring text from 1 cell on the Excel sheet
into the Interactive button "Link" field.
Is there another type of button on tool to have the web site attach directly
to an address (like typing http:111.222.333.444 onto a command line)?

 

[Stefan B Rusynko]

Your cell would be (or a reference to it) would need to be set up as a DB Table (fieldname & filed value) in the spreadsheet
- you can't just reference any cell like b14

--

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


| The instructions in the link you gave me were for FrontPage 2000 ... it may
| not be different for FrontPage 2003 but it still did not answer the question.
| There was no method described to bring text from 1 cell on the Excel sheet
| into the Interactive button "Link" field.
| Is there another type of button on tool to have the web site attach directly
| to an address (like typing http:111.222.333.444 onto a command line)?
| --
| Marc
|
|
|
| "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!" (-;
| > _____________________________________________
| >
| >
| > | My web design has interactive buttons that have links directly to an ethernet
| > | address (eg. http://111.222.333.444).
| > |
| > | There is an Excel spreadsheet that the addresses reside in (cells in the
| > | sheet contain the text "http://111.222.333.444")
| > |
| > | I would like to hyperlink a cell's content into a button on the web sheet.
| > | So far, all I can do is load the entire spread sheet, not just 1 cell's
| > | content. The Excel sheet has the cells named, but there does not seem to be
| > | any ablity to reference the cell ID (E14) or its name.
| > |
| > | Advice here will allow my site to be automatically kept up to date from
| > | these hyperlinks rather than manual typing.
| > | --
| > | Marc
| > |
| >
| >
| >

 

[Marc Issler]

I am new to this type of inter-program linking.

When I try to create a Table or database link, it wants files or other
http:// sites for reference. It is not an http web service being created.

Perhaps this type of input into the Inteactive button is not available. If
it is, could you give an example of the appearance of the syntax of the link.

(eg: spreadsheet.xls$e$5 ... ?????) - or -
spreadsheet.htm($E$5)