move row from one workbook to another

[alwings]

Hi,

I am new to VB and am trying to move one row of data and append it to the first nonblank row of another workbook. I have figured out how to append it to the first blank row in another sheet within the same workbook but I want to move it to another workbook. Any help would be great!
Here is the code that works for moving it to another sheet. It moves Row 4 from the sheet called Project List and copies it to the sheet called complete, putting it below the last row that is available. I want to move it to another workbook on another drive.

Anyway to move it to another workbook? I have attached the excel file but here is the Macro that works correctly:

Please Login or Register  to view this content.

[Leith Ross]

Hello alwings,

Welcome to the Forum!
You need to tell VBA which workbook by prefixing the worksbook name to the worksheet.

Example

Please Login or Register  to view this content.

[jaslake]

I'm following this post and I have a question for Leith Ross. Doesn't

Please Login or Register  to view this content.

need to opened to do this

Please Login or Register  to view this content.

J

[Leith Ross]

Hello JL,

Yes, the second workbook must already be open when the macro runs or an error will occur.