VS 2010 Copy Range From .xlsm to .xlsx

Hello,

I've searched online but could not find something for VS, only VBA but even then the comment say it didn't work.

My main code opens workbook "X". which is macro-enabled (.xlsm), exports some values in column A of sheet "DataGridView". I then save and close "X".

I have also created another workbook "Y" (.xlsx) with only one sheet ("Sheet1").

I want to paste the entire column A from "X" onto column A in "Y".

Please note I do not want to use Interop as it messes up my code when I import it; my current preferences are:

Option Strict Off
Imports System.IO
Imports System.Globalization
Imports System.Text
Imports System.Net.Mail
Imports Microsoft.Office

So please whatever you suggest, it should work with these.

Thank you :)