View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arvi Laanemets Arvi Laanemets is offline
external usenet poster
 
Posts: 510
Default Excel2000: Closing an Excel workbook automatically

Hi

I need an Excel workbook, which contains 4 ODBC queries, to be opened every
night, and to be closed after all queries are refreshed (The queries
retrieve some data from source restricted for most users, and save them in
tables. For every table, a non-dynamic named range is defined - so users can
use this workbook as source for their queries).

All queries are set to be refreshed on open automatically. Refreshing them
takes several seconds only. On this computer, I can set all queries to be
refreshed without confirmation, and there is no VBA code in workbook. I can
start the workbook at given time through Windows script, but is there some
simple way to close the same workbook p.e. 5 minutes later?


Thanks in advance!

--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )