Announcement

Collapse
No announcement yet.

Excel question: auto-save as html?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Excel question: auto-save as html?

    Hey all,
    I know some of you are really good with Excel and scripting, so I was hoping for some help/advice.

    We have this spreadsheet at work, and it needs to be very up to date, but not every machine can run Office or OpenOffice.

    Is there a way that every time the document is saved, an HTML version is also saved somewhere on our internal network?
    Last edited by Wombat; 6 February 2004, 11:54.
    Gigabyte P35-DS3L with a Q6600, 2GB Kingston HyperX (after *3* bad pairs of Crucial Ballistix 1066), Galaxy 8800GT 512MB, SB X-Fi, some drives, and a Dell 2005fpw. Running WinXP.

  • #2
    Yup with a bit of VBA this can be done... SaveAs format:=xlHtml I believe along with the scripting to trigger the saveas when saving normally. If you get stuck I can give you a hand later Wombat.
    DM says: Crunch with Matrox Users@ClimatePrediction.net

    Comment

    Working...
    X