Excel 2003 Programming

by Webb, Jeff

• ISBN13: 9780596007676
• ISBN10: 0596007671
• Format: Paperback
• Copyright: 2004-08-31
• Publisher: Oreilly & Associates Inc

Summary

This guide introduces intermediate to advanced Excel VBA programmers to the newest programming features of Excel 2003. The book focuses on those features of Excel 2003 that are new, so that programmers can get up to speed quickly. And it provides dozens of practical labs that let them see for themselves which of those features will be useful, or not, in their own work. Excel 2003 Programming: A Developer's Notebook shows programmers how to work with lists and XML data, secure Excel applications, use Visual Studio Tools for Office, consume Web Services, and collect data with Infopath.

Author Biography

1. Jeff Webb

   Jeff Webb is a SharePoint consultant and trainer who has written about computers and technology for 20 years. Among his published O'Reilly titles are Essential SharePoint, SharePoint Office Pocket Guide, Programming Excel with VBA and .NET, and Excel 2003 Programming: A Developer's Notebook. Jeff was an original member of Microsoft's Visual Basic team.

Table of Contents

The Developer's Notebook Series	ix
Preface	xiii
Program the New Excel	1	(26)
Dude, Where's My Data?	1	(1)
How the Pieces Fit	2	(1)
Try It	3	(1)
Kick-Start Lists and XML	4	(3)
Kick-Start SharePoint	7	(2)
Kick-Start Web Services	9	(3)
Kick-Start Security and NET	12	(6)
Kick-Start InfoPath	18	(8)
What Next?	26	(1)
Share Workspaces and Lists	27	(39)
Get SharePoint Services	27	(4)
Create a Shared Workspace	31	(4)
Share a Workbook	35	(1)
Open a Shared Workbook	36	(3)
Display a SharePoint Site	39	(1)
Remove Sharing	40	(2)
Add Users and Permissions	42	(3)
Allow Anonymous Users	45	(5)
Create a List	50	(3)
Share a List	53	(3)
Update a Shared List	56	(1)
Insert a Shared List	57	(1)
Delete or Unlink a Shared List	58	(1)
Use the Lists Web Service	59	(7)
Work with XML	66	(43)
Speak XML	66	(2)
XML Side-story	68	(2)
Save Workbooks as XML	70	(3)
Transform XML Spreadsheets	73	(7)
Transform XML into a Spreadsheet	80	(5)
Use XML Maps	85	(7)
Exporting Through XML Maps	92	(7)
Use Templates with XML	99	(4)
Respond to XML Events	103	(1)
Program with XML Maps	104	(3)
Get an XML Map from a List or Range	107	(2)
Get Data from the Web	109	(25)
Perform Web Queries	110	(5)
Modify a Web Query	115	(1)
Perform Periodic Updates	116	(3)
Manage Web Queries	119	(2)
Use Web Services	121	(2)
Use the Web Services Toolkit	123	(4)
Use Web Services Through XML	127	(2)
Call a Web Service Asynchronously	129	(2)
Reformat XML Results for Excel	131	(3)
Program Excel with .NET	134	(46)
Work with NET	134	(2)
Create NET Components	136	(2)
Use NET Components	138	(3)
Respond to Errors and Events from NET	141	(3)
Debug .NET Components	144	(2)
Distribute .NET Components	146	(2)
Use Excel as a Component in .NET	148	(3)
Work with Excel Objects in .NET	151	(2)
Respond to Excel Events in .NET	153	(1)
Respond to Excel Errors in .NET	154	(3)
Distribute .NET Applications That Use Excel	157	(4)
Create Excel .NET Applications	161	(2)
Set .NET Security Policies	163	(3)
Respond to Events in .NET Applications	166	(2)
Debug Excel .NET Applications	168	(3)
Display Windows Forms	171	(2)
Distribute Excel .NET Applications	173	(2)
Distribute Excel .NET Documents	175	(2)
Migrate to .NET	177	(3)
Explore Security in Depth	180	(43)
Dress in Layers	180	(2)
Use Windows Security	182	(4)
Password Protect and Encrypt Workbooks	186	(2)
Program with Passwords and Encryption	188	(3)
Protect Items in a Workbook	191	(4)
Program with Protection	195	(5)
Use Identity-Based Security (a.k.a. IRM)	200	(5)
Program with Permissions	205	(2)
Add Digital Signatures	207	(6)
Set Macro Security	213	(3)
Distribute Security Settings	216	(4)
Common Questions	220	(3)
Build InfoPath Forms	223	(52)
Are InfoPath Forms Better?	223	(10)
InfoPath and Excel	233	(2)
Share Data	235	(4)
Link a Form to a Database	239	(6)
Populate a Control from a Data Source	245	(4)
Validate Data	249	(5)
Link a Form to a Web Service	254	(2)
Script InfoPath	256	(8)
Program InfoPath in .NET	264	(6)
Generate HTML Output	270	(2)
Prevent Design Changes	272	(3)
Index	275