ExcelBanter - Determining if a query is refreshing

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Determining if a query is refreshing (https://www.excelbanter.com/excel-programming/445038-determining-if-query-refreshing.html)

hutteto

Determining if a query is refreshing

Hey,

In VBA, how would you determine if a query is currently refreshing?

Thanks

isabelle

Determining if a query is refreshing

hi,

If ActiveSheet.QueryTables(1).BackgroundQuery Then

--
isabelle

Le 2011-10-10 15:11, hutteto a écrit :
Hey,

In VBA, how would you determine if a query is currently refreshing?

Thanks

All times are GMT +1. The time now is 08:37 AM.