Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I am attempting to use VB.net to drive Excel 2000. So I add reference in my project to MS XL Object Library 9.0... Everything is great, except here is the issue.... The Box I'm developing on has Excel2000 & Excel2003 installed..... I want to develop and deploy the project to the Excel2000 environment..... Is there an easy way when I create the Excel.Application object to force it to open Excel 2000 and not Excel 2003? Private Sub btnOpen_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOpen.Click Dim oXL As Excel.ApplicationClass Dim oWkb As Excel.WorkbookClass Dim oWkbs As Excel.Workbooks Dim FileSpec As String = "E:\Documents and Settings\Rick\My Documents\Visual Studio Projects\DriveExcel\PIData.xls" oXL = CreateObject("Excel.Application") '***How to specify Excel 2000? oXL.Visible = True oWkbs = oXL.Workbooks oWkb = oWkbs.Open(FileSpec) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Interop problem with VS.NET 2003 | Excel Programming | |||
Interop.Excel version 11 does not work with Office 2003 sp2 | Excel Programming | |||
Where is documentation for the C# Office XP/2003 Primary Interop Assemblies??? | Excel Programming | |||
Excel 2003 Range problem with .Net Interop | Excel Programming | |||
Excel 2003 COM interop problems | Excel Programming |