MACROS for combining .CSV to XLS...

[pma101]

Hey all:

I am relatively new to MACROS and have spent days trying to figure out a MACRO that appends data from a DAILY. CSV file into an existing RUNNING.XLS

I have 10 DAILY. CSV
10 RUNNING. XLS

Two of the CSV (A andB) files appends to RUNNING A
All other appends to its own RUNNING

I have the files saved on my C/drive folder as REPORTS...Once the NEW appended existing I would like it to SAVE as REPORT dd/mm/yy todays date. Please assist me with developing a macro to execute this task and saving the

I would like to keep the existing CSV. for records.


I hope this was not to confusing...thanks in advance for helping!

[MarvinP]

Hi pma101
I do a similar activity where I add a .csv day file to the bottom of the data in my .xls. Here is the code I use below. After opening the csv file I remove some unwanted columns before copying the data to the windows clipboard. Then I close the csv file without changing it. Then the macro goes to the bottom of the data in my xls and pastes it there.

Please Login or Register  to view this content.