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
Bookmarks