Help on Prompt

Z

Zubair

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.REQUEST("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 within a formula as soon as i open the xls
to update
the data accordingly.
Thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top