Flylib.com
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
ISBN: 0596007671
EAN: 2147483647
Year: 2004
Pages: 133
Authors:
Jeff Webb
BUY ON AMAZON
Excel 2003 Programming: A Developer s Notebook
Table of Contents
Copyright
The Developer s Notebook Series
Notebooks Are...
Notebooks Aren t...
Organization
Preface
Don t Force It
Get the Samples
Font Conventions
How to Contact Us
Acknowledgments
Chapter 1. Program the New Excel
Section 1.1.Dude, Where s My Data?
Section 1.2.How the Pieces Fit
Section 1.3.Try It
Section 1.4. Kick-Start Lists and XML
Section 1.5.Kick-Start SharePoint
Section 1.6.Kick-Start Web Services
Section 1.7.Kick-Start Security and .NET
Section 1.8.Kick-Start InfoPath
Section 1.9.What Next?
Chapter 2. Share Workspaces and Lists
Section 2.1.Get SharePoint Services
Section 2.2.Create a Shared Workspace
Section 2.3.Share a Workbook
Section 2.4.Open a Shared Workbook
Section 2.5.Display a SharePoint Site
Section 2.6. Remove Sharing
Section 2.7.Add Users and Permissions
Section 2.8.Allow Anonymous Users
Section 2.9.Create a List
Section 2.10.Share a List
Section 2.11.Update a Shared List
Section 2.12.Insert a Shared List
Section 2.13.Delete or Unlink a Shared List
Section 2.14.Use the Lists Web Service
Chapter 3. Work with XML
Section 3.1. Speak XML
Section 3.2. XML Side-story
Section 3.3. Save Workbooks as XML
Section 3.4. Transform XML Spreadsheets
Section 3.5. Transform XML into a Spreadsheet
Section 3.6. Use XML Maps
Section 3.7. Exporting Through XML Maps
Section 3.8. Use Templates with XML
Section 3.9. Respond to XML Events
Section 3.10. Program with XML Maps
Section 3.11. Get an XML Map from a List or Range
Chapter 4. Get Data from the Web
Section 4.1.Perform Web Queries
Section 4.2. Modify a Web Query
Section 4.3. Perform Periodic Updates
Section 4.4.Manage Web Queries
Section 4.5.Use Web Services
Section 4.6.Use the Web Services Toolkit
Section 4.7. Use Web Services Through XML
Section 4.8. Call a Web Service Asynchronously
Section 4.9. Reformat XML Results for Excel
Chapter 5. Program Excel with .NET
Section 5.1.Work with .NET
Section 5.2.Create .NET Components
Section 5.3.Use .NET Components
Section 5.4.Respond to Errors and Events from .NET
Section 5.5.Debug .NET Components
Section 5.6.Distribute .NET Components
Section 5.7.Use Excel as a Component in .NET
Section 5.8.Work with Excel Objects in .NET
Section 5.9.Respond to Excel Events in .NET
Section 5.10.Respond to Excel Errors in .NET
Section 5.11.Distribute .NET Applications That Use Excel
Section 5.12.Create Excel .NET Applications
Section 5.13.Set .NET Security Policies
Section 5.14.Respond to Events in .NET Applications
Section 5.15.Debug Excel .NET Applications
Section 5.16.Display Windows Forms
Section 5.17.Distribute Excel .NET Applications
Section 5.18.Distribute Excel .NET Documents
Section 5.19.Migrate to .NET
Chapter 6. Explore Security in Depth
Section 6.1.Dress in Layers
Section 6.2. Use Windows Security
Section 6.3.Password Protect and Encrypt Workbooks
Section 6.4.Program with Passwords and Encryption
Section 6.5.Protect Items in a Workbook
Section 6.6.Program with Protection
Section 6.7. Use Identity-Based Security (a.k.a. IRM)
Section 6.8.Program with Permissions
Section 6.9.Add Digital Signatures
Section 6.10.Set Macro Security
Section 6.11.Distribute Security Settings
Section 6.12.Common Questions
Chapter 7. Build InfoPath Forms
Section 7.1.Are InfoPath Forms Better?
Section 7.2.InfoPath and Excel
Section 7.3.Share Data
Section 7.4.Link a Form to a Database
Section 7.5.Populate a Control from a Data Source
Section 7.6.Validate Data
Section 7.7.Link a Form to a Web Service
Section 7.8.Script InfoPath
Section 7.9.Program InfoPath in .NET
Section 7.10.Generate HTML Output
Section 7.11.Prevent Design Changes
About the Author
Colophon
Index
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Excel 2003 Programming: A Developers Notebook (Developers Notebook)
ISBN: 0596007671
EAN: 2147483647
Year: 2004
Pages: 133
Authors:
Jeff Webb
BUY ON AMAZON
The CISSP and CAP Prep Guide: Platinum Edition
Access Control
Telecommunications and Network Security
Understanding Certification and Accreditation
Appendix D The Information System Security Engineering Professional (ISSEP) Certification
Appendix F Security Control Catalog
Mapping Hacks: Tips & Tools for Electronic Cartography
Hack 5. The Road Less Traveled by in MapQuest
Hack 40. Plot Points on a Spinning Globe Applet
Hack 42. Map Your Tracklogs on the Web
Hack 43. Map Earthquakes in (Nearly) Real Time
Hack 88. Load Your Waypoints into a Spatial Database
Pocket Guide to the National Electrical Code(R), 2005 Edition (8th Edition)
Article 210 Branch Circuits
Article 338 Service-Entrance Cable Types SE and USE
Article 354 Nonmetallic Underground Conduit with Conductors Type NUCC
Article 701 Legally Required Standby Systems
Notes for Tables 12(A) and 12(B)
Microsoft VBScript Professional Projects
Project Case Study Desktop Customization and Deployment
Processing and Consolidating Report Data
Archive Management
Designing the Web Site
Converting Reports to HTML Pages
Junos Cookbook (Cookbooks (OReilly))
Debugging a Failed Commit
Controlling Root Authentication
Using Digital Certificates to Create Dynamic IPSec SAs
Viewing the OSPF Link-State Database
Configuring Multiple RPs in a PIM-SM Domain Anycast PIM
Comparing, Designing, and Deploying VPNs
Summary
Review Questions
Scaling and Optimizing IPsec VPNs
Summary
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies