PDA

View Full Version : Automatic Saving as Web Page



Danimagus
03-06-2005, 10:43 AM
Hello all!

I'm working on a project in Excel involving a network of spreadsheets, where the value of one cell is pulled and copied into another cell in another spreadsheet (that value is then used to create a graph). The goal is to export that spreadsheet (the one containing the pulled value and resulting graph) as an html document, and to have this happen automatically

So far, I've created a macro that runs periodically or at a certain time, opening and saving any number of spreadsheets to html, but this isn't quite good enough.

I'd like to have a macro that causes the spreadsheets to save as html automatically whenever they are also saved in the normal sense. The object is to have the most up to date information and charts in html format.

Does anyone know how this might be done?

Danimagus
03-06-2005, 11:26 AM
Also, in my charts, how do I go about inserting text that is tied to the spreadsheet like any other cell? That is, I need to have text in the graphic that changes automatically when its source cell does.