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
Automatically refresh queries (Read 2083 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Automatically refresh queries
28.04.10 at 10:19:44
 
Automatically refresh queries
 
Quote:
I guess the other part is how I could refresh the cells without having to
touch each one. If you have any thoughts I'd appreciate it. Again, we're
pretty much there, the only thing is how do I make it easier for the user.

 
You are using the SQLQueryValue function to retrieve the data into the spreadsheet cells. When the workbook is opened I think the functions will be evaluated automatically if there is a connection. After establishing a connection the functions should also refresh.
 
You can manually refresh the formulas by using the force calculation of all formulas option from SQL*XL's function menu. You can automate this by recording a macro and you can add this code to your connection macro if required.

See also:

Connection macro
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1254470180
Back to top
 
 

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