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

F

Finny388

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.
 
S

sebastienm

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open, Update, and Close files automatically 5
Database update Mk II 3
Excel Macro to copy, paste and then update web queries 0
Auto Open file VBA Refresh MS Query Save Close 2
Importing from another workbook 0
Access data in a closed workbook with ExecuteExcel4Macro 5
Simple MS Query with Data Parameters Not Auto-refreshing 0
Web Query 0

Top