View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maxwell2006 Maxwell2006 is offline
external usenet poster
 
Posts: 5
Default Merging a CSV and XLS file automatically

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