Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh business query on open
Anyone with a good idea how to trigger a refresh of a .bqy when opening workbook ? -- SITO ------------------------------------------------------------------------ SITO's Profile: http://www.excelforum.com/member.php...o&userid=37529 View this thread: http://www.excelforum.com/showthread...hreadid=571742 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Refresh business query on open
Record a macro do do what you want, then put it in the Workbook Open module
so it will run as soon as the Workbook is opened. If you're new to macros, check David McRitchie's site http://www.mvps.org/dmcritchie/excel/excel.htm Event, Change_Cell Events Worksheet events provide a means of automatically triggering a macro when something happens on the worksheet. (change, calculation, double-click, right-click, selection change, worksheet become active or is deactivated, and follow hyperlink). hth Vaya con Dios, Chuck, CABGx3 "SITO" wrote: Anyone with a good idea how to trigger a refresh of a .bqy when opening workbook ? -- SITO ------------------------------------------------------------------------ SITO's Profile: http://www.excelforum.com/member.php...o&userid=37529 View this thread: http://www.excelforum.com/showthread...hreadid=571742 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Query refresh | Excel Discussion (Misc queries) | |||
Get External Data - not editable using Query Wizard | Excel Discussion (Misc queries) | |||
Query parameter "refresh when value changes" doesn't refresh - why | Excel Discussion (Misc queries) | |||
Refresh Imported Data - Does the Excel file have to be open? | Excel Discussion (Misc queries) | |||
open saved query in Excel 2003 | Excel Discussion (Misc queries) |