Office 2011 for Mac: Making a Scroll Bar for Excel Forms
Protect Excel Worksheets and Lock Cells in Office 2011 for Mac
How to Share a Workbook in Excel 2011 for Mac

Automating Web Pages with Excel in Office 2011 for Mac

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.

    image0.jpg
  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.

    image1.jpg
  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.

blog comments powered by Disqus
How to Save as a Template in Office 2011 for Mac
Working with Templates in Office 2011 for Mac
Office 2011 for Mac: Making Spin Buttons for Excel Forms
Make a Form on a Dialog Sheet in Excel 2011 for Mac
Excel for Mac 2011: Add a Picture to a Worksheet Background
Advertisement

Inside Dummies.com