View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NewsNet NewsNet is offline
external usenet poster
 
Posts: 3
Default COM interop XL2000 vs 2003

Rick,
oXL = CreateObject("Excel.Application.9") 'XL2000
oXL = CreateObject("Excel.Application.10") 'XL2003 ??

NickHK

"Rick Humphrey" ...
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\PvIData.xls"
oXL = CreateObject("Excel.Application") '***How to specify Excel
2000?
oXL.Visible = True
oWkbs = oXL.Workbooks
oWkb = oWkbs.Open(FileSpec)

End Sub