Help How to update linked .xls offline with MS-ACCESS (VB)?
 

Hi guys,

How can get an excel file to update itself offline?

The context:

TEST1.XLS
TEST2.XLS is linked to test1.xls (ie a cell in test2 is
='D:\TEMP\[test1.XLS]test1'!A2)
ACCESS.MDB Updates TEST1 and NEEDS updated results from TEST2

The question

How can I "request" TEST2.XLS to update itself from ACCESS.MDM before I
import it in ACCESS.MDB?

Thank you all.

--
Don't forget to remove the JUNK when you reply...
N'oubliez pas d'enlever le JUNK quand vous répondez...