Can Macro be created to spawn an HTML doc from Excel every w

[winrz]

Would like to find a way to automatically spawn an HTML version of an Excel spreadsheet and place it in the same folder on the server. Would be nice if I could have this set up weekly and triggered at any time by the user. I have a few excel spreadsheets that are rather large and folks who RAS in would like to have something quicker to look at. Any ideas?

 

[Mark W.]

spawn?

See the Excel Help topic for "Ways to put Excel data on the Web".
This message was edited by Mark W. on 2002-10-25 11:38

 

[winrz]

You mean do a search on how to put xcel on the web? i did and nothing specific has come up so far. I basically want to be able to trigger a macro at lets say noon on wed to create an HTML version of itself with or without the spreadsheet being open - is this possible?

 

[Mark W.]

Ahh, setup an Autpen() macro to Publish to a web server. Next, create a scheduled event using Window's Task Manager to open the worksheet at the desired time. That should do it!