How can I select version of excel from excel file

E

Enrico

I have an xls file and i will select version of Excel from this file. How can
I do this?
Thank you
 
J

Jaleel

I will select or I have to select? Go to File - Save As and from the drop
down arrow of Save as type, select the appropriate version.

Jaleel
 
G

Gord Dibben

Sub This_Version()
MsgBox Application.version
End Sub

Sub This_Version22()
Range("A1").Value = "Excel " & Application.version
End Sub


Gord Dibben MS Excel MVP
 
J

Jaleel

Oh Go(r)d!

You are omniscient.

Jaleel



Gord Dibben said:
Sub This_Version()
MsgBox Application.version
End Sub

Sub This_Version22()
Range("A1").Value = "Excel " & Application.version
End Sub


Gord Dibben MS Excel MVP
 
Top