Excel2000: Closing an Excel workbook automatically

[Arvi Laanemets]

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!

 

[MattShoreson]

you can use the 'timer' function in vba to check for for when the file
has been open for 5 mins, if it has then close it.