| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto Refresh MS Query SQL Server
I have a MS Query to retrieve data from SQL server database through ODBC
Connection My user needs to right click to refresh data every time. Is it possible to write some code to refresh the MS Query when open the spreadsheet? Also, May I pass parameter from spreadsheet? Any information is great appreciated, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unable to open after auto refresh(Query) | Excel Discussion (Misc queries) | |||
| Web Query Auto Refresh | Excel Worksheet Functions | |||
| How do you avoid window that prompts to enable auto query refresh | Excel Discussion (Misc queries) | |||
| How do I get a web query to auto-refresh before a pivot table aut. | Excel Discussion (Misc queries) | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Threaded Mode
