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
Refresh queries without showing the SQL (Read 3230 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Refresh queries without showing the SQL
27.11.05 at 08:06:44
 
Lawrence from India asked the following question:
 
Question:
Is it possitble not so show the query (SQL) when clicking the refresh button?
 
Answer:
The refresh queries button will collect all the SQL from your currect workbook and put the statements in the SQL dialog so you can rerun them. By clicking the refresh button you cannot hide the SQL dialog where the SQL is shown. You need this dialog to run the SQL statements.
 
What you require is a way to re-execute the SQL and not to reload the SQL into the dialog. You can make your own refresh button quite easilly. With the macro recorder in Excel you can record the executing of the SQL. Rerunning the macro will rerun the SQL and it will put the result in the same location.
 
References:
Back to top
 
« Last Edit: 27.11.05 at 13:48:55 by Gerrit-Jan Linker »  

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