Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Rick,
Interesting question... I can think of two possibilities to try as it appears you have the right reference added. 1) What happens when you have Excel2000 open and you run your code? If this works, you can start up an instance of it before opening the file then closing the extra blank workbook if it gets in the way. 2) What happens if you tell windows to associate .xls files (or the file extension you are using) to open with the Excel2000 version? Note, this may cause problems later with opening files created in Excel2003. You may need to toggle this programatically (not sure how it would be done in .net) before/after opening what you need if it works. David "Rick Humphrey" wrote in message ... 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 |
Reply |
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 |