Online Test Banks
Score higher
See Online Test Banks
eLearning
Learning anything is easy
Browse Online Courses
Mobile Apps
Learning on the go
Explore Mobile Apps
Dummies Store
Shop for books and more
Start Shopping

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
Advertisement

Inside Dummies.com

Dummies.com Sweepstakes

Win $500. Easy.