Refresh Ext Date Range Query with workbook closed? (Exc2003)
 

We have a labelling software that looks at Excel sheets to generate
labels.

I have recently made a simple MS Query to look at our company database
for the live information.

But can the sheet refresh when closed? Is it specific enough to ask
whether a sheet is "opened" or refreshed when another sheet or
software reads from it?

Or are we stuck manually opening and refreshing the sheet manually on
a daily basis?

Any thoughts much appreciated.
Thanks.

Refresh Ext Date Range Query with workbook closed? (Exc2003)
 

Hi ,
If the labelling software can query excel, it is possible that the software
can query the database directly without having to run a first (same) query
within excel. What is this software?
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"Finny388" wrote:

We have a labelling software that looks at Excel sheets to generate
labels.

I have recently made a simple MS Query to look at our company database
for the live information.

But can the sheet refresh when closed? Is it specific enough to ask
whether a sheet is "opened" or refreshed when another sheet or
software reads from it?

Or are we stuck manually opening and refreshing the sheet manually on
a daily basis?

Any thoughts much appreciated.
Thanks.