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

Re: Hyperlink contents of a cell in an Excel sheet into a web button by Stefan

Stefan
Fri Feb 01 03:07:39 CST 2008

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

--

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


"Marc Issler" <MarcIssler@discussions.microsoft.com> wrote in message news:0C8D0EB0-3F15-4DD4-998F-E70E84D66195@microsoft.com...
| 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
|



Re: Hyperlink contents of a cell in an Excel sheet into a web butt by MarcIssler

MarcIssler
Fri Feb 01 23:47:00 CST 2008

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!" (-;
> _____________________________________________
>
>
> "Marc Issler" <MarcIssler@discussions.microsoft.com> wrote in message news:0C8D0EB0-3F15-4DD4-998F-E70E84D66195@microsoft.com...
> | 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
> |
>
>
>

Re: Hyperlink contents of a cell in an Excel sheet into a web butt by Stefan

Stefan
Sat Feb 02 03:10:22 CST 2008

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!" (-;
_____________________________________________


"Marc Issler" <MarcIssler@discussions.microsoft.com> wrote in message news:FAF96C11-237D-4573-8D71-D54E2069DB9B@microsoft.com...
| 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!" (-;
| > _____________________________________________
| >
| >
| > "Marc Issler" <MarcIssler@discussions.microsoft.com> wrote in message news:0C8D0EB0-3F15-4DD4-998F-E70E84D66195@microsoft.com...
| > | 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
| > |
| >
| >
| >



Re: Hyperlink contents of a cell in an Excel sheet into a web butt by MarcIssler

MarcIssler
Tue Feb 05 23:42:01 CST 2008

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)

--
Marc



"Stefan B Rusynko" wrote:

> 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!" (-;
> _____________________________________________
>
>
> "Marc Issler" <MarcIssler@discussions.microsoft.com> wrote in message news:FAF96C11-237D-4573-8D71-D54E2069DB9B@microsoft.com...
> | 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!" (-;
> | > _____________________________________________
> | >
> | >
> | > "Marc Issler" <MarcIssler@discussions.microsoft.com> wrote in message news:0C8D0EB0-3F15-4DD4-998F-E70E84D66195@microsoft.com...
> | > | 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
> | > |
> | >
> | >
> | >
>
>
>