Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Opening a HTML table in Excel (FrontPage 2000)

    All,
    I want to create a web page with a HTML table in it but I want it to open in Excel when the user clicks on the hyperlink to the page. I know there are ways of doing it using ASP techniques but I seem to remember something about changing the content type to text/csv in the meta tags.
    Can anyone point me in the right direction ?
    Apologies if this is mis-directed..


    Paul

  2. #2
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening a HTML table in Excel (FrontPage 2000)

    Will hypperlinking directly to the .xls file not give you want you want?<pre>

    Click here to open spreadsheet</p></pre>


  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening a HTML table in Excel (FrontPage 2000)

    Leif,
    This means I have to maintain two files, one HTML and one XLS. I was hoping that I could just have one with a choice of format. I suppose I could always ask people to create a linked workbook that will refresh with the data on the web page.

    Paul

  4. #4
    Plutonium Lounger Leif's Avatar
    Join Date
    Dec 2000
    Location
    U.K.
    Posts
    14,010
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening a HTML table in Excel (FrontPage 2000)

    Do you want to give a bit more background about what you are hoping to achieve?
    Why, for example, do you want it to open with Excel?

  5. #5
    Star Lounger
    Join Date
    Jan 2001
    Posts
    93
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Opening a HTML table in Excel (FrontPage 2000)

    Leif,
    Thanks for your comments. I have re-assessed the task and I think I can achieve my aims by using Excel to link to the data on the web page. The data are raw and the use of Excel is to allow people to do their own data 'massaging' using Excel's statistical and graphing capabilities.

    Thanks again.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •