refresh web quiries when workbook is opened

[J.W. Aldridge]

need a simple workbook module code....

have several web quiries on different worksheets in a workbook.
when i open the workbook, i want to automatically refresh all web
quiries.


thanx.

 

[Tom Ogilvy]

For each table,

Right click on the table and select properties. There should be an option
box to refresh on opening.