How to create a matrix from excel sheet using vba

Hi my friends , I have a excel file that contain two coloumn . The first one contain the X coordinates of points and the second one contain the Y coordinates.I want an VBA macro  to create a matrix  M1=[ n x1] wich contain all the X coordinates ( as described in the excel file) and onother matrix M2=[mx1] wich contains the Y coordinates.Thank you vey much for your support

SolidworksApi macros