Using the OPEN statement to append the data from one wkb to another

[SDruley]

Please Login or Register  to view this content.

The above code generates error 75. Need to know how to work around.

I have two workbooks
TEST1.xlsm = Master file that has in column A the numbers 1 through 21
TEST2.xlsm = A file that contains new data (A,B.C) to be appended to TEST1.xlsm
I want Test1 to read vertically in column A 1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,A,B,C

The error stops me from meeting my goal.