Notification When MSQuery Returns Data to Excel

  • Thread starter Thread starter msluxmi
  • Start date Start date
M

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
 
Why were they not helpful? Those are the supplied methods to react to an
update.

--
Regards,
Tom Ogilvy

msluxmi said:
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
Click to expand...
creating financial statements
 
Back
Top