I would like to get a notification when MSQuery (i.e. when
Menu-Data-Get External Data- New Database Query) returns
data to excel sheet. I would like to do some modification on th
returned data.

Is there a way to notify or intercept when MSQuery returns data t
excel?

I tried the events BeforeRefresh() and AfterRefresh() of the QueryTabl
object. But they were not helpful.

Lakshm

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

~~Now Available: Financial Statements.xls, a step by step guide to creating financial statements

Why were they not helpful? Those are the supplied methods to react to an
update.

--
Regards,
Tom Ogilvy

"msluxmi" wrote in message
...

I would like to get a notification when MSQuery (i.e. when
Menu-Data-Get External Data- New Database Query) returns
data to excel sheet. I would like to do some modification on the
returned data.

Is there a way to notify or intercept when MSQuery returns data to
excel?

I tried the events BeforeRefresh() and AfterRefresh() of the QueryTable
object. But they were not helpful.

Lakshmi


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide to
creating financial statements