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

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


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=541719