Automatically update from source when file opens

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert csv to Excel files 1
Excel CSV Files; Creating Of 3
Import Multiple CSV Files from Same Folder into Open Workbook 5
Automatic "data refresh" when XLS file is opened? 1
Cut and Paste from one worksheet to another? 1
Reading CSV with numbers in text format, Excel automatically convertsto scientific notation 1
update links question 2
how to link ot a data in a csv file? 3

Back
Top