Linker IT Software
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 2462 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.
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)
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