refresh data from a intermediate excel data file (not opened)
 

Hi

I would like to import data separate excel file, which itself consolidates
data from mutliple CSV files.

CSV files --- Excel Data File --- Excel Results File

My question : how do I refresh the Excel Data File programmaticaly ? I tried
to open/close it, with the refresh on open option checked, but it asks me if
I trust the data source, etc etc.. This is not ideal and machine
dependant...

How do I refresh it transparently ?

Matthieu