View Single Post
  #3   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

A batch job (windows scheduled task) supposed to do that. Can your solution
be called through a scheduled task?



Thanks for help,

Max


"AA2e72E" wrote in message
...
1. Open your xls
2. Write a macro
Macro does this:
1. Reads the CSV into an ADODB.Recorsdset object (works best if the CSV
has
column headers).
2. Insert a new worksheet
3. Use CopyFromReordset to send the ADODB.REcordset to the new sheet.

... save the workbook