Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Check the SQL*XL version (Read 2489 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Check the SQL*XL version
21.03.07 at 21:43:03
 
Check the SQL*XL version
 
SQL*XL user Graham asked the following question.
 
Question:
How can I check if the currently installed version of SQL*XL is >= the minimum version I need? (e.g. I'll need the 4.1.13 release when you do release it.. and I'll need to ensure that at least this version is installed before my code goes out)
 
Answer:
You can get the version number from:
 
SQLXL.SQLXLApplication.Version As String
 
This would return "4.1.13" as a string.
 
I suggest you use the different components as they are returned as long variables with which you can do the checking:
 
SQLXL.SQLXLApplication.Major As Long
SQLXL.SQLXLApplication.Minor As Long
SQLXL.SQLXLApplication.Revision As Long
Back to top
 
« Last Edit: 21.03.07 at 21:45:18 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1