Application.VBE.Version on Excel XP
 

Hi,

I've been using Application.VBE.Version to determine which version of
excel my macros are running on sine office 98. I'm just migrating to
Office XP and I am getting a runtime error 1004, Application-defined or
object-defined error.

Sub testit()
MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & _
" running on " & _
Application.OperatingSystem & "!"
End Sub

When I run this, I get "10.0" and "Windows (32-bit) NT 5.01" returned
appropriately. When I change Application.Version to
Application.VBE.Version I get the runtime error.

Has anyone seen anything like this before or can anyone offer some
advice?

Thank you,

Jeremy.

Application.VBE.Version on Excel XP
 

I have never seen VBE.Version, but application.Version has always worked.
Maybe VBE.Version was a fluke and the fixed it.

--
Regards,
Tom Ogilvy

"Jeremy" wrote in message
ups.com...
Hi,

I've been using Application.VBE.Version to determine which version of
excel my macros are running on sine office 98. I'm just migrating to
Office XP and I am getting a runtime error 1004, Application-defined or
object-defined error.

Sub testit()
MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & _
" running on " & _
Application.OperatingSystem & "!"
End Sub

When I run this, I get "10.0" and "Windows (32-bit) NT 5.01" returned
appropriately. When I change Application.Version to
Application.VBE.Version I get the runtime error.

Has anyone seen anything like this before or can anyone offer some
advice?

Thank you,

Jeremy.

Application.VBE.Version on Excel XP
 

Roedd <<Jeremy wedi ysgrifennu:

Hi,

I've been using Application.VBE.Version to determine which version of
excel my macros are running on sine office 98. I'm just migrating to
Office XP and I am getting a runtime error 1004, Application-defined
or object-defined error.

Excel 97:
?application.Version
8.0e
?Application.VBE.Version
5.00

Excel 2000
?application.Version
9.0
?Application.VBE.Version
6.04

Excel XP
?application.Version
10.0
?Application.VBE.Version
6.04

I don't have Office 2003 installed.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

Application.VBE.Version on Excel XP
 

xl2003:
?application.Version
11.0
?Application.VBE.Version
6.04

Robert Bruce wrote:

Roedd <<Jeremy wedi ysgrifennu:

Hi,

I've been using Application.VBE.Version to determine which version of
excel my macros are running on sine office 98. I'm just migrating to
Office XP and I am getting a runtime error 1004, Application-defined
or object-defined error.

Excel 97:
?application.Version
8.0e
?Application.VBE.Version
5.00

Excel 2000
?application.Version
9.0
?Application.VBE.Version
6.04

Excel XP
?application.Version
10.0
?Application.VBE.Version
6.04

I don't have Office 2003 installed.

--
Rob

http://www.asta51.dsl.pipex.com/webcam/

This message is copyright Robert Bruce and intended
for distribution only via NNTP.
Dissemination via third party Web forums with the
exception of Google Groups and Microsoft Communities
is strictly prohibited and may result in legal action.

--

Dave Peterson

Application.VBE.Version on Excel XP
 

I see I was looking in the wrong library (Visual basic extensions) and this
is in the Excel Library. As Rob/Dave show, it works in all versions
(although it doesn't appear to be of much utility).

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
I have never seen VBE.Version, but application.Version has always worked.
Maybe VBE.Version was a fluke and the fixed it.

--
Regards,
Tom Ogilvy

"Jeremy" wrote in message
ups.com...
Hi,

I've been using Application.VBE.Version to determine which version of
excel my macros are running on sine office 98. I'm just migrating to
Office XP and I am getting a runtime error 1004, Application-defined or
object-defined error.

Sub testit()
MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & _
" running on " & _
Application.OperatingSystem & "!"
End Sub

When I run this, I get "10.0" and "Windows (32-bit) NT 5.01" returned
appropriately. When I change Application.Version to
Application.VBE.Version I get the runtime error.

Has anyone seen anything like this before or can anyone offer some
advice?

Thank you,

Jeremy.

Application.VBE.Version on Excel XP
 

"Tom Ogilvy" wrote in message
...
I see I was looking in the wrong library (Visual basic extensions) and this
is in the Excel Library. As Rob/Dave show, it works in all versions
(although it doesn't appear to be of much utility).

--
Regards,
Tom Ogilvy


"Tom Ogilvy" wrote in message
...
I have never seen VBE.Version, but application.Version has always worked.
Maybe VBE.Version was a fluke and the fixed it.

--
Regards,
Tom Ogilvy

"Jeremy" wrote in message
ups.com...
Hi,

I've been using Application.VBE.Version to determine which version of
excel my macros are running on sine office 98. I'm just migrating to
Office XP and I am getting a runtime error 1004, Application-defined or
object-defined error.

Sub testit()
MsgBox "Welcome to Microsoft Excel version " & _
Application.Version & _
" running on " & _
Application.OperatingSystem & "!"
End Sub

When I run this, I get "10.0" and "Windows (32-bit) NT 5.01" returned
appropriately. When I change Application.Version to
Application.VBE.Version I get the runtime error.

Has anyone seen anything like this before or can anyone offer some
advice?

Thank you,

Jeremy.





On the Trusted Publishers dialog I had to check Trust access to Visual Basic
Project.

Now it works.

Jeremy.