Open Separate File, Copy Data and Paste Macro

Hi

I have vba enable spreadsheet open C:\Workbook1.xlsm at "Sheet 1". I would like to write a macro for this file that open a second file, C:\Data.xlsx and copies "Sheet 2" A1:A20 and pastes the values only into Workbook 1, Sheet 1 A1:A20. I then need this macro to Close C:\Data.xlsx without saving.

Any help would be greatly appreciated.

Doug

Hi Pike

That code is close but it doesnt paste the values only and I get a compile error when I run it saying that the sub or function is not defined.