Copy data from one workbook, paste it to another

Hi,

I'm trying to solve this little problem, but no luck so far. I work with workbooks for customer orders each having a different name. I open it, work on it, then I need to bring data from a second book (this one with a fixed name/location), and paste it onto the customer order's one, then close the copying book without saving changes. The code I have, does open the copying workbook, and copies the data (column A), but does not paste it at all in the customer order's book.

What do I have to adjust? ... This is the code, so far:

Sub Open_Copy_Paste()

Workbooks.Open("C:\Users\DVD\MASTER.xlsx").Activate
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Copy

ThisWorkbook.Cells(1).Range("A1").PasteSpecial

Workbooks("MASTER.xlsx").Close SaveChanges:=False


End Sub


Thanks!

This should solve your problem.

Please Login or Register  to view this content.

Sheets(1) might change in your case. If you want to specify the sheet name, just replace Sheets(1) with .Sheets("YourSheetName")

Hi ssaidli,

First of all, thanks for your help! I used the code you posted, but the column is still not pasted to the current book. The code ended like this:

Workbooks.Open("C:\Users\DVD\MASTER.xlsx").Activate
Range("A2").Select
Range(Selection, Selection.End(xlDown)).Copy

ThisWorkbook.Sheets(1).Range("A1").PasteSpecial xlPasteValues

Workbooks("MASTER.xlsx").Close SaveChanges:=False

Using "Sheets(1)" is better I think, since this macro is to be run on a different workbook each time, but the copied info will always be pasted to the first sheet.

Not sure what's going on? ...

See the link below. This thread is not about copy-paste but I have attached my full code which might help you finding what you need. This code copies data from one workbook onto another and closes them afterwards.
http://www.excelforum.com/showthread.php?t=1170026

Try this code as well.

Please Login or Register  to view this content.

Hi Ssaidli,

I tried the code you posted, but I get a "Run-time error '91': Object variable or With block variable not set". When clicking on "Debug", takes me to this line: workbook1 = Workbooks.open(path)

I read the link for the other post, but was a bit too complicated for me.

I'll try to figure out what's going on. If you happen to have an additional comment, it'll be appreciated.

Thanks!

Sorry about that. Should be

Please Login or Register  to view this content.

See I am no professional in excel VBA, I am a learner too, but this seems like a simple problem to me. If you could go to the link I provided and tweak and change the parts of it, you can actually get it working.

Hi again,

Well, I added the piece of code, but the info still doesn't get pasted at all. Yes, I agree with you, this should be a simple to solve issue. As for the link you provided, as I mentioned, I visited it, and read all info there. However, if you're not a professional, I'm certainly way behind your level, 'cause I didn't really understand most of the code.

I do, however, appreciate your help. Certainly gave me some more understanding about this. I'll keep experimenting and doing research.

Thanks!