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

Distribute Excel .NET Documents

If you distribute an Excel workbook that uses .NET code to others who don’t have Excel 2003, the .NET code is ignored and programmed features are unavailable. Earlier versions of Excel can open Excel 2003 workbooks, but they can’t run .NET assemblies on start-up.

Note

If you distribute an Excel .NET document to an Excel 2003 user who doesn’t have access to the assembly location, Excel displays an error message when that user opens the workbook.

Choose the policy level to deploy and enter a filename to create

Figure 5-23. Choose the policy level to deploy and enter a filename to create

If you want to distribute a Workbook to Excel 2003 users who don’t have access to the .NET assembly, either distribute and install the assembly with the workbook as described in “Distribute Excel .NET Applications” or clear the _AssemblyName0 and _AssemblyLocation0 custom document properties before sending. For example, the following code saves a copy of the current document without the references to the .NET assembly; then sends the workbook via email:

 Private Sub cmdSend_Click( ) Handles cmdSend.Click Dim _AssemblyName0 As String, _AssemblyLocation0 As String, _ name As String ' Save custom propeperty settings. _AssemblyName0 = _ ThisWorkbook.CustomDocumentProperties("_AssemblyName0").Value _AssemblyLocation0 = _ ThisWorkbook.CustomDocumentProperties("_AssemblyLocation0").Value ' Clear custom property settings. ThisWorkbook.CustomDocumentProperties("_AssemblyName0").Value ...
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