Skip to Main Content
Excel 2003 Programming: A Developer's Notebook
book

Excel 2003 Programming: A Developer's Notebook

by Jeff Webb
August 2004
Intermediate to advanced content levelIntermediate to advanced
312 pages
8h 30m
English
O'Reilly Media, Inc.
Content preview from Excel 2003 Programming: A Developer's Notebook

Kick-Start SharePoint

Wow, you’re so proud of your work you want others to be able to use it. To share the list, publish it to a SharePoint site:

Note

If you don’t have SharePoint, look ahead to Chapter 2 to find out how to get one for a free trial online (it only takes a few minutes).

  1. Click anywhere on the list and then choose Data List Publish List. Excel displays the first step of the Publishing Wizard (Figure 1-9).

    Starting to publish a list to SharePoint

    Figure 1-9. Starting to publish a list to SharePoint

  2. Specify the address of your SharePoint site and give the list a name and description. Click Next. If you aren’t logged on to your site, Excel displays a sign-on dialog box for you to enter your user name and password.

  3. Once you’re signed on, Excel displays the columns that make up the list, along with their data types (Figure 1-10). Click Finish to create the list.

    Choosing types for SharePoint

    Figure 1-10. Choosing types for SharePoint

  4. After SharePoint creates the list, it passes the address of the list back to Excel, which displays it in a success message (Figure 1-11).

    Success!

    Figure 1-11. Success!

  5. Just to make sure that it worked, click on the link in the previous success message. Excel displays the list on the SharePoint site in a browser window, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel 2003 Programming Inside Out

Microsoft® Office Excel 2003 Programming Inside Out

Curtis Frye, Wayne S. Freeze, Felicia K. Buckingham
Excel® 2007 VBA Programmer's Reference

Excel® 2007 VBA Programmer's Reference

John Green, Stephen Bullen, Rob Bovey, Michael Alexander
Office 2003 XML

Office 2003 XML

Simon St. Laurent, Mary McRae, Evan Lenz

Publisher Resources

ISBN: 0596007671Supplemental ContentCatalog PageErrata