Merging a CSV and XLS file automatically

[Maxwell2006]

Hi,



I have a csv fles on the network derive that is being updated every night.



I need to automatically put the CSV data into the first worksheet of another
XLS file and make it available for users.



I can have a scheduled task runs and merge the CSV into the XLS file.



What would be the easiest/automated way to do that?



Thank you,

Max

[mrice]

Sounds like you need an auto_open macro in your workbook which you are opening as a scheduled task.