Automatically update from source when file opens
 

I have an XLS worksheet (destionation file) that I wish to populate with data
from a CSV file (source). In order to update the XLS, the CSV must be open.
What is the best way to automatically update the destination file? Can a
macro automatically open the source file, upload the data to the destination
file, then close? Or is there an easy way to open the CSV file automatically
when the XLS is opened? thanks

Hi,

Have you looked at
Data - Import External Data - New Database Query...
and choosing Text Files as the data source ?

You then select the csv file, and use microsoft query to import into Excel.

Once this is set up, refreshing data from the csv file is a one click
operation.

Ed Ferrero

"P Flater" <P wrote in message
...
I have an XLS worksheet (destionation file) that I wish to populate with
data
from a CSV file (source). In order to update the XLS, the CSV must be
open.
What is the best way to automatically update the destination file? Can a
macro automatically open the source file, upload the data to the
destination
file, then close? Or is there an easy way to open the CSV file
automatically
when the XLS is opened? thanks