Copy Data to a new workbook

[webiscore]

Hello,

I'm using the code to copy data from a sheet to another and at the same time copy it to a new workbook however it's not working always an error. Please advice, than you in advanced.

Please Login or Register  to view this content.

[jolivanes]

Where is the error (which line is highlighted), what does the error message say and explain what you want to do.

[webiscore]

The line highlighted is "MYDATA.Save"
Compile error: Method or data member not found

[jindon]

You are assigning the variable to Workbook Collection.
Try get rid of "s".

Please Login or Register  to view this content.

[webiscore]

Didn't solve the problem

[jolivanes]

Does it actually paste in DATABOOK2? You don't open it anywhere that I can see.
Maybe this line

Please Login or Register  to view this content.

should be

Please Login or Register  to view this content.

Is this the line you have in your code?

Please Login or Register  to view this content.

Do you have a "USER" in C:\Users? Or is it your name?

[jindon]

Didn't solve the problem

This doesn't help at all.

How is it not working? what are you trying to do? What error in which line?

[webiscore]

I've modified the code now thanks to @jolivanes I added the Open tag however the error highlighted now
"Range("A5:K4005").PasteSpecial"

It's not pasting in this range, actually it should be from A5-A4005 to K5-K4005.

[jolivanes]

Did you see what the excel vba help says about pastespecial?