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
|