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