Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Checking version

2 views
Skip to first unread message

r.gomez

unread,
Jan 5, 2000, 3:00:00 AM1/5/00
to
Hi all.
I need a macro to check wether a user is running excel 2000 when
openning my application.
Is there a different version between excel 97 and 2000?
I also need to remember (I did it in the past but I forgot :))how to
delete rows and columns that are not used in a worksheet in order to
reduce the file size.
I thanks you in advance and wish a happy 2000.


R van Eijk

unread,
Jan 5, 2000, 3:00:00 AM1/5/00
to
Use application.version in VB or INFO("version_excel") as a
worksheet.function

Rudi

r.gomez <r.g...@iaea.org> schreef in artikel
<DD8C7CE3FFD94B4283A804C7D7B61FB629AF4A@CPMSFTMSGV22>...

Michael Williams

unread,
Jan 5, 2000, 3:00:00 AM1/5/00
to
One difference I found between 97 and 2k had to do with the assistant. This
code checks for the version and kills it if necessary.

'check for Excel version, turn on Assistant if Excel 2k
Dim oAssist As Object, Ass As Integer
If Val(Application.Version) >= 9 Then
Set oAssist = Assistant
If oAssist.On = True Then
Ass = 1
Else
oAssist.On = True
Ass = 2
End If
End If

this code restores the worksheet to it's original assistant situation.

If Val(Application.Version) >= 9 Then
If Ass = 2 Then oAssist.On = False
End If


r.gomez <r.g...@iaea.org> wrote in message
news:DD8C7CE3FFD94B4283A804C7D7B61FB629AF4A@CPMSFTMSGV22...

Michael Kishinevsky

unread,
Jan 6, 2000, 3:00:00 AM1/6/00
to
Try:
Function ExcelVersion()
ExcelVersion = "Excel version " & Application.Version & ", build " &
Application.Build
End Function

On my computer:
In Excel 97 the function returns: "Excel version 8.0e, build 5618".
In Excel 2000 the return value is "Excel version 9.0, build 2719"

0 new messages