Copy from another workbook

[Arsen258]

Hi,

I get a new excel file every day that i need to work on. The thing is i cannot modify is in any way/save it in another location (do not ask....) . What i can do is copy the data to another excel file and then save it so i did something like this:

Please Login or Register  to view this content.

It works fine untill the last line (Pasting) which i don't really know why is not working. It spits out Subscription out of date but how is that possible? How can "A1" be out of range?!

Thanks in advance for your help!

[mike7952]

Try removing the line in red. You already set the wb at the top of your code.

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

Paste method applies to Sheet object.

[Arsen258]

Try removing the line in red. You already set the wb at the top of your code.

It got me: Object doesn't support this property or method

[Arsen258]

Please Login or Register  to view this content.

Paste method applies to Sheet object.

Works great! Thank you!

[jindon]

You are welcome and thanks for the rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.