LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default COM interop XL2000 vs 2003

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interop problem with VS.NET 2003 Dhruv Excel Programming 0 January 3rd 06 09:52 PM
Interop.Excel version 11 does not work with Office 2003 sp2 Hua Huang Excel Programming 3 November 22nd 05 09:36 PM
Where is documentation for the C# Office XP/2003 Primary Interop Assemblies??? Stefani[_2_] Excel Programming 7 April 2nd 05 03:47 AM
Excel 2003 Range problem with .Net Interop Simon Neumann Excel Programming 0 February 14th 05 03:42 PM
Excel 2003 COM interop problems Matt Storz Excel Programming 2 December 7th 04 04:47 PM


All times are GMT +1. The time now is 02:08 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"