Copy from one workbook to another and insert current date and time in cells. Unique Code!

[jelgin]

Looking to copy a row from one workbook(wbk1) that is already open to another workbook(wbk2)not open. the date from wbk 1 needs to be appended to the data in wbk2. I also want to place a current date in a cell and time in another cell for each time I do the copy. The date and time cells are pasted in wbk2. Finally the wbk2 is closed and saved with the current date as the name of the file.

The ultimate plan is to place this code in a ONTIME function where it loops until a set time, but I'll handle that later.

Any help is very much appreciated. Love this forum btw!
Code is below:

Please Login or Register  to view this content.

Moderator's Note: Use code tags on your codes, since this is your first post I'll do it for you. Thanks.

[patel45]

Please Login or Register  to view this content.

the csv file must be with comma delimiters