Excel as data source for HTML links

[Najemikon]

Hi,

I'm in uncharted territory and wonder if someone could help in the right direction.

I have a spreadsheet in Excel calculating various bits of information. A summary of that information needs displaying on an Intranet page.

I'm a bit rusty on HTML. How do I use a link tag to reference cells in the spreadsheet?

That said if you can suggest other methods of achieving the same thing, I'd really appreciate it.


Cheers,


Jon

 

[kjv1611]

What about doing "Save as webpage", and just saving the report data to a web page, separate from the actual Excel file, and then allowing the users on the intranet to access the data that way?

--

"If to err is human, then I must be some kind of human!" -Me

 

[Najemikon]

Well, the data will alter on a weekly basis. I thought it might be easier if the spreadsheet was altered, the web page would just refresh the content.

Also, because of how the data is calculated, there's a great deal of information that isn't required for the public page. It may even turn out to have to be seperate spreadsheets.

 

[kjv1611]

Well, what you could do then, is create one worksheet, taking values from the other that you want to show on the website, and then save that as a web page. And, if you want it automated, you could set up formulas on the page to take the appropriate values in the appropriate cells, and then use VBA to automate the saving of the web page whenever the data is updated. That way, every time the data is refreshed, you are in effect saving a new web page, but it will practically be the same as refreshing that page.

There may be a better solution, but that just seemed a likely one to me.

--

"If to err is human, then I must be some kind of human!" -Me

 

[Najemikon]

That sounds fair enough, it's just in my mind it seems more logical to have a webpage linking to a data source. I thought there was a tag where you reference file/sheet/cell. If not though, your method will certainly work.

 

[kjv1611]

I would think there is a way to do what you're talking about (like with an Access data page), but I've not done this yet in Excel.

But, if you're looking for an HTML tag to link to ANY data source, I'm sure you could get the right answer in one of the web programming forums... I think there is at least one specifically just on HTML.

--

"If to err is human, then I must be some kind of human!" -Me