Correct the codes - Open, copy & Paste

[kit370]

Hi Guys,

Coding for opening the excel file and copy the range from sheet 1 to another workbook and then close it.

I have come across for opening the workbook, but how do i copy the range till the recent row used in the workbook and close it.

Code:

Please Login or Register  to view this content.

Tried with activating the sheet, but most of the times it resulted in error saying that object is not set & etc..

Thanks,
Kit

[Kaper]

1) use code tags - it is required by forum rules. so please edit your post.

2) as oWS is neither declared nor assigned it contains null so you try to activate here

Please Login or Register  to view this content.

non existing Sheet0

[kit370]

Hi,

Here the picture of the code.

Please Login or Register  to view this content.

I have tried to perform in different way, by giving the range to copy from the target sheet to master sheet, but there too some coding is missing out.

Well is it there any chance to set the pre-defined set of columns & rows to copy (till the last recent used row) and paste it in the master sheet, then do loop the same senario.

Code tags done...

Thanks,
Kit

[Richard Buttrey]

Hi,

As has been mentioned, you need to add code tags - see forum rules.

[kit370]

Code tags done..

Thanks