Workbooks("name1").Sheets(1).Range("a1:B2").Copy
Workbooks("name2").Sheets(1).Range("a1").paste
Workbooks("name1").Close

"David P." wrote in message
...
I am hoping to create a macro that upon opening a file it will do the
following:

1)Copy A1:B:2 (just as an example; also - there is only one worksheet in
this file)
2)Activate Workbook "Price Chart Template" (only 1 sheet here too)
3)Paste on A:1
4)Go back to the original document and close it without saving (this is
where I'm wondering if code can allow to close the document it is written
in???)

Thank you.
--
David P.