| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Merging info from Wkbk 1 to Wkbk2 automatically | Setting up and Configuration of Excel | |||
| Merging cells in shared file | Excel Discussion (Misc queries) | |||
| merging of data automatically | Excel Discussion (Misc queries) | |||
| Updating or merging files, same file, they were updated independan | Excel Discussion (Misc queries) | |||
| Problems merging an excel file due to code or file problems? | Excel Programming | |||
Threaded Mode
