April 2006
Beginner
1114 pages
98h 16m
English
Content preview from Programming Excel with VBA and .NETBecome 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,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Distribute .NET Applications That Use Excel
Use the Visual Studio .NET setup and deployment project to create an installation program for applications that use Excel as a component. (See "Distribute .NET Components,” earlier in this chapter, for a walk-through of using the Setup Wizard.)
The .NET setup tools detect the .NET Framework and Excel PIAs as dependencies of any application that uses Excel as a component and includes those files with the installation. However, the setup tools do not automatically check for the installation of Microsoft Excel, or any other Microsoft Office product. You can add required products as a launch condition in the setup project for your application.
PIAs are available for Excel 2002 and later. However, you can use Visual Studio .NET type library import tools to create interop assemblies for earlier versions of Excel (they won’t work as well as the PIAs, but they will work). All interop assemblies are tied to a specific version of Excel, so you should check that the required version of Excel is installed on the user’s computer before installing your application and each time your application starts. You can use the following code to detect which version of Excel is installed:
' Uses the following Imports statement for RegistryKey classes: Imports Microsoft.Win32 Function GetExcelVer( ) As String ' Define the RegistryKey objects. Dim regRoot As RegistryKey, regExcel As RegistryKey, ver As String ' Get root registry entry. regRoot = Microsoft.Win32.Registry.ClassesRoot ...
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.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.