refresh web quiries when workbook is opened
 

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.

refresh web quiries when workbook is opened
 

For each table,

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

--
Regards,
Tom Ogilvy



"J.W. Aldridge" wrote in message
ups.com...
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.