Notification When MSQuery Returns Data to Excel

[msluxmi]

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

 

[Tom Ogilvy]

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

--
Regards,
Tom Ogilvy

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


------------------------------------------------



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

creating financial statements