Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
2003 update link when Source open | Excel Worksheet Functions | |||
File asks to update when no links were created | Links and Linking in Excel | |||
Automatic update of links in destination file when source file mo. | Excel Discussion (Misc queries) |