Automating Web Pages with Excel in Office 2011 for Mac - dummies

Automating Web Pages with Excel in Office 2011 for Mac

By Geetesh Bajaj, James Gordon

Suppose you post daily updates to Excel for Mac 2011 spreadsheets and charts that you save as Web pages for your intranet. You can set up your Mac so that the Web site is refreshed automatically on any schedule you want. Of course, the Mac must have read/write access to the Web server’s folders. Here’s how to set Excel to automatically update a Web page:

  1. Prepare a workbook with updated information to present on the Web site.

  2. Choose File→Save As Web Page.

    The Save As dialog displays.

  3. Click the Automate button.

    The Automate dialog displays.


  4. To have the Web page updated at a particular time, select the According to a Set Schedule check box.

  5. Click the Set Schedule button.

    The Recurring Schedule dialog displays.


  6. Choose the options that suit the schedule you want Excel to follow, and then click OK to close the Recurring Schedule dialog.

  7. Click OK to close the Automate dialog.

  8. Choose a save location and then click the Save button.

    Excel now saves the current version of this workbook according to the rules you established.

You can combine this technique with a Web query or a database query, and create a Web page that’s completely automatic! Of course, you can also add additional automation procedures with VBA.