macro to concatenate 3 COLUMNS from one workbook into 1 COLUMN IN ANOTHER WORKBOOK

[drobinson782001]

I have 3 columns in my source workbook, column D (mONTH), COLUMN E (DAY), COLUMN F (YEAR), i would like to combine all the cloumns as 11/13/2013 and export that to another workbook which has a column (R) Birthdate. I already have a macro that copies between the workbook so i would like to incorporate that within this code

Please Login or Register  to view this content.

[LJMetzger]

Try the following tested using Excel 2003.
Obviously I did not have your template file, but I did create a simulated .csv file.
It seemed like your data had a header row, that's why I started at row 2.
All the code I added is indented to the left.

Please Login or Register  to view this content.

If you want dates of the format mm/dd/yyyy each data item should be validated as numeric
to prevent a runtime error, such as

Please Login or Register  to view this content.

Lewis

[GC Excel]

Hi,
You can also used the DateSerial function to build the date

Please Login or Register  to view this content.

[LJMetzger]

You can also used the DateSerial function to build the date

Excellent point GC. However if the cells contain non-numerics or blanks, DateSerial will produce a run-time error.