Prompt before updating values
HI,
I have an SQLREQUEST function which is a simple select query that retrieves data from oracle tables. ='C:\Program Files\Microsoft Office\Office10\LIBRARY\MSQUERY\XLODBC.XLA'!SQL.RE QUEST("DSN=BATSERV;UID=GCOMM;PWD=GCOMM",,,"SELECT nvl(SUM(VERT),0) FROM btc_tblock_count_exch WHERE type1='BT Line' AND exch='RMN' and TO_CHAR(inservicedate,'yyyy')='1988'") How can i issue a prompt on exch column as soon as i open the xls to update the data accordingly. Thanks in advance |
All times are GMT +1. The time now is 05:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com