Open workbook, copy rows, paste to end of current workbook

[gmn734]

Hi,

I am trying to put together some code to do the following
1. Open OLDDATA workbook (using the dialog box, file name and path will be different every time)
2. Copy all rows except row1 from OLDDATA, olddatasheet (this is the only worksheet in the file) to the workbook that the macro was run from (workbook=NEWDATA, sheet=newdatasheet. this will always be called the same). newdatasheet will already have data so i need it to copy to the next available row
3. Close OLDDATA workbook without saving

Can anyone help? my attempt is below...

Please Login or Register  to view this content.

[Naveed Raza]

try this code.......

Please Login or Register  to view this content.

or else find the two attached file for validating..

Hope this will work

[HaHoBe]

Hi, gmn734,

you have dimmed wbTarget as Workbook so you may only assign a workbook to that variable, not a workseet as well:

Please Login or Register  to view this content.

Ciao,
Holger