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

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