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!
Bookmarks