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
Runtime error 91 (Read 8701 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Runtime error 91
09.12.05 at 10:46:13
 
Runtime error 91
 
Stephan from Germany asked the following question.
 
Question:
I have reinstalled SQL*XL and I am getting the following message when I am trying to start it.
 
I am getting the following error message:
Laufzeitfehler 91: Objekt variable oder With-Block variable nicht festgelegt
 
In English:
Runtime error 91: Object variable or With block variable not defined
 
Answer:
It seems that SQL*XL is unable to use its dlls. This can happen when you are using a mismatch of dlls versions together. When you downgrade SQL*XL (install an older version without fully uninstalling the more recent version) you could fall into this pitfall.
 
The best thing to do is to remove the SQL*XL dlls manually and then to reinstall it.
 
Please read the following topic for the list of SQL*XL dlls that you need to remove:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1134121829
 
General information about SQL*XL can be found at:
www.oraxcel.com/projects/sqlxl
Back to top
 
« Last Edit: 15.09.06 at 16:22:48 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Runtime error 91
Reply #1 - 19.07.06 at 22:08:23
 
It looks like this is an initialisation problem. Recently I have added an initialiseSQLXL method that forces SQLXL to initialise first before it runs the other statements in a macro. I suggest you do this too. First thing you do in your macro is a call to SQLXL.InitialiseSQLXL. Then add the calls you want to make.
 
Back to top
 
 

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