Update Excel file

[tracktraining]

Hi All,

First of all, thanks so much for all the help with the questions.

I think what I am about to ask is impossible, but just wanted to hear some
suggestions (if any).

I have an excel link table in my DB. That excel file needs to be refresh
everytime the user uses the DB. So the user would open up the excel file, an
inital pop-up screen (Query Refresh) appears then click "Enable automatic
refresh". Then close and save the file. Now the user is able to use the DB
with the correct updated information.

Is it possible to have a button on one of the forms so when pushed it will
automatically refresh and save the excel file and thus allowing the correct
updated information to be linked to the DB? Let me know if that is unclear.

Thanks in advance for your time and help.

Cheers,
Thi

 

[Klatuu]

Sorry, it is not clear.
Are you wanting to change data in the linked Excel spreadsheet? If so, it
can't be done. There are ways around the limitiation.
Are you wanting to just make sure you have the most current data in the
linked Excel shreadsheet? If so, it isn't necessary you will get the current
data in the spreadsheet when you open the table.

Please clarify your question.

 

[tracktraining]

Let me try to explain.

I have a linked Excel spreadsheet in my DB. The original Excel spreadsheet
needs to be refreshed very often. To save some time, can I have a botton in a
FORM that would access the refreshed property in the original Excel
spreadsheet? Is this code possible?

 

[tracktraining]

By the way, the reason for refreshing the original excel spreadsheet is
because that excel sheet is getting data from another system that is
constantly being updated.

 

[Klatuu]

Okay, got it.

If you have the spreadsheet table open in a form, you can just periodically
requery the form.