QueryTable Refresh Event Code

T

Tim

I created a external data table on a separate tab in the
same workbook as the source data. I want the external data
table to refresh whenever the source data is changed. The
workbook event "Workbook_SheetChange" runs a procedure
whenever any cells in the sheet is changed. So, I want to
run a query table refresh method inside this event. Do I
put the SheetChange event code in the source data object's
class or in the query tables object class?

Also, VBA help says that you have to initialize the query
table as an object WithEvents first. This is confusing to
me. Where do these initializations go and how do I
incorporate them into the SheetChange Event?

Any suggestions would help.

Thanks in advance,
Tim
 
Top