vb.net Excel versions

[BrianDH]

Hi
Is there a way, in VB.Net, to write a windows based program that will use
more than one version of Office (Excel)?

Example: if office 2000 then else if office 2003 then.

Is this possible? Examples?

Thanks

[Frank Liebelt]

Hi

BrianDH wrote:

Hi
Is there a way, in VB.Net, to write a windows based program that
will use more than one version of Office (Excel)?

Example: if office 2000 then else if office 2003 then.

Is this possible? Examples?

Late-Binding is your friend
Dim xlAppl As Object = CreateObject("Excel.Application")

Frank

[scorpion53061]

Use the registry to check the version....

Pseudo code untested.
Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" & versionnumber &
".0\\Excel"
regVersion = Registry.LocalMachine.OpenSubKey(keyValue,
False)
If regVersion Is Nothing Then
'Do this and exit
End If
If versionnumber = 10 Then

'Do this

End If

Exit Do
Loop
End Function

"BrianDH" <Br*****@discussions.microsoft.com> wrote in message
news:95**********************************@microsof t.com:

Hi
Is there a way, in VB.Net, to write a windows based program that will use

more than one version of Office (Excel)?

Example: if office 2000 then else if office 2003 then.

Is this possible? Examples?

Thanks

[BrianDH]

thanks will give it a try!

"Frank Liebelt" wrote:

Hi

BrianDH wrote:

Hi
Is there a way, in VB.Net, to write a windows based program that
will use more than one version of Office (Excel)?

Example: if office 2000 then else if office 2003 then.

Is this possible? Examples?

Late-Binding is your friend
Dim xlAppl As Object = CreateObject("Excel.Application")

Frank

[BrianDH]

Thanks will give it a try!

"scorpion53061" wrote:

Use the registry to check the version....

Pseudo code untested.
Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" & versionnumber &
".0\\Excel"
regVersion = Registry.LocalMachine.OpenSubKey(keyValue,
False)
If regVersion Is Nothing Then
'Do this and exit
End If
If versionnumber = 10 Then

'Do this

End If

Exit Do
Loop
End Function

"BrianDH" <Br*****@discussions.microsoft.com> wrote in message
news:95**********************************@microsof t.com:

Hi
Is there a way, in VB.Net, to write a windows based program that will use

more than one version of Office (Excel)?

Example: if office 2000 then else if office 2003 then.

Is this possible? Examples?

Thanks

[Herfried K. Wagner [MVP]]

Kelly,

"scorpion53061" <ad***@nospamherekjmsolutions.com> schrieb:

Use the registry to check the version....

Pseudo code untested.
:-)
Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" & versionnumber &
".0\\Excel"

The "\\" should be "\" :-).

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>

[Frank Liebelt]

Hi

Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" &
versionnumber & ".0\\Excel"
regVersion = Registry.LocalMachine.OpenSubKey(keyValue,
False)
If regVersion Is Nothing Then
'Do this and exit
End If
If versionnumber = 10 Then

'Do this

End If

Exit Do
Loop
End Function

With this code you could read the excel version but it doesn't make the
application able to work with different excel versions.
Example:
I have Excel 2003, the application has a reference to the Excel(11) COM
Object.
The user has Excel 2000 (10). The only i can do is inform the user that
his Excel version won't work with this application.
But with Late-Binding the application works with Excel 97, 2000, XP,
2003 without any reference.

Late-Binding makes a application independent from any version.

Frank

[Paul Clement]

On Thu, 28 Oct 2004 10:55:01 -0700, "BrianDH" <Br*****@discussions.microsoft.com> wrote:

¤ Hi
¤ Is there a way, in VB.Net, to write a windows based program that will use
¤ more than one version of Office (Excel)?
¤
¤ Example: if office 2000 then else if office 2003 then.
¤
¤ Is this possible? Examples?

See the following:

INFO: Writing Automation Clients for Multiple Office Versions
http://support.microsoft.com/default...b;en-us;244167
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[scorpion53061]

Herfried,

Yeah you got me.......
:)

"Herfried K. Wagner [MVP]" <hi***************@gmx.at> wrote in message
news:eQ**************@TK2MSFTNGP12.phx.gbl:

Kelly,

"scorpion53061" <ad***@nospamherekjmsolutions.com> schrieb:

Use the registry to check the version....

Pseudo code untested.

:-)

Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" & versionnumber &

".0\\Excel"

The "\\" should be "\" :-).

[scorpion53061]

Frank,

The idea is to take the version number garnered, then if code your app
around the idea if they have 10 and you know your code needs to adapt to
that version so all versions are available. This is the method one could
use to find the office version on the end users machine and try to
accommodate all versions in your code.

As a general rule, the office versions are backward compatible. What
works for office 2000 will work for office 2003.

Unfortunately this general rule gets broken on occasion which makes it
necessary for you to have case statements saying what to do for a
particular version of office. Even using late binding is no guarantee in
all cases you are going to be safe in all office versions for a
particular event.

"Frank Liebelt" <li*********@arcor.de> wrote in message
news:41***********************@newsread4.arcor-online.net:

Hi

Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" &
versionnumber & ".0\\Excel"
regVersion = Registry.LocalMachine.OpenSubKey(keyValue,
False)
If regVersion Is Nothing Then
'Do this and exit
End If
If versionnumber = 10 Then

'Do this

End If

Exit Do
Loop
End Function

With this code you could read the excel version but it doesn't make the
application able to work with different excel versions.
Example:
I have Excel 2003, the application has a reference to the Excel(11) COM
Object.
The user has Excel 2000 (10). The only i can do is inform the user that
his Excel version won't work with this application.
But with Late-Binding the application works with Excel 97, 2000, XP,
2003 without any reference.

Late-Binding makes a application independent from any version.

Frank

[scorpion53061]

Frank,

Can you open a xml document in Excel 97 using late binding?

"Frank Liebelt" <li*********@arcor.de> wrote in message
news:41***********************@newsread4.arcor-online.net:

Hi

Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" &
versionnumber & ".0\\Excel"
regVersion = Registry.LocalMachine.OpenSubKey(keyValue,
False)
If regVersion Is Nothing Then
'Do this and exit
End If
If versionnumber = 10 Then

'Do this

End If

Exit Do
Loop
End Function

With this code you could read the excel version but it doesn't make the
application able to work with different excel versions.
Example:
I have Excel 2003, the application has a reference to the Excel(11) COM
Object.
The user has Excel 2000 (10). The only i can do is inform the user that
his Excel version won't work with this application.
But with Late-Binding the application works with Excel 97, 2000, XP,
2003 without any reference.

Late-Binding makes a application independent from any version.

Frank

[mflorezm]

Hello Guys:

Does anyone know How to create an Excel event handler while using late
binding?

I had to use late binding because my application must run across multiple
MS-Office versions, but I need to catch WorkbookBeforeClose Event of the
application object.

I tried both: delegates and WithEvents keyword like I found in Microsoft
documents, but it doesn't work because those methods use early binding.

http://support.microsoft.com/default...b;en-us;249843
http://support.microsoft.com/default...b;en-us;247579
http://support.microsoft.com/default...b;en-us;244167

Thanks

--
MFM

"Frank Liebelt" wrote:

Hi

Public Function getInstance1() As Excel.ApplicationClass
Dim regVersion As RegistryKey
Dim keyValue As String
Dim versionnumber As Integer = 9
Do
keyValue = "Software\\Microsoft\\Office\\" &
versionnumber & ".0\\Excel"
regVersion = Registry.LocalMachine.OpenSubKey(keyValue,
False)
If regVersion Is Nothing Then
'Do this and exit
End If
If versionnumber = 10 Then

'Do this

End If

Exit Do
Loop
End Function

With this code you could read the excel version but it doesn't make the
application able to work with different excel versions.
Example:
I have Excel 2003, the application has a reference to the Excel(11) COM
Object.
The user has Excel 2000 (10). The only i can do is inform the user that
his Excel version won't work with this application.
But with Late-Binding the application works with Excel 97, 2000, XP,
2003 without any reference.

Late-Binding makes a application independent from any version.

Frank