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
Software Configuration Management
Project Management in a CM Environment
CM Automation
Appendix A Project Plan
Appendix C Sample Data Dictionary
Appendix L Software Requirements Changes
Kanban Made Simple: Demystifying and Applying Toyotas Legendary Manufacturing Process
Auditing the Kanban
Improving the Kanban
Appendix C Two-Bin Kanban Systems
Appendix E EOQ vs. Kanban
Appendix J Abbreviations and Acronyms
Network Security Architectures
Everything Is a Weapon
Emerging Security Technologies
Routing Considerations
References
Security Will Become Computationally Less Expensive
Managing Enterprise Systems with the Windows Script Host
Input/Output Streams
Registry Operations
Regular Expressions
Internet Applications
Internet Information Server
C++ How to Program (5th Edition)
Terminology
Summary
E.12. Unions
G.10. Class BalanceInquiry
J.2. Editing XHTML
MPLS Configuration on Cisco IOS Software
Cell-Mode MPLS
RIPv2 PE-CE Routing Overview, Configuration, and Verification
Case Study-Hub and Spoke MPLS VPN Network Using BGP PE-CE Routing for Sites Using Unique AS Numbers
Case Study 7: Implementing Hub and Spoke Topologies with OSPF
Case Study 10: BGP Site of Origin
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