View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Matthieu Gaillet Matthieu Gaillet is offline
external usenet poster
 
Posts: 2
Default 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