Importing data from other xls tables in VBA

Hi, for my project i need to be able to
load data in my table from other table(in other file) how can I do that in VBA scripting for Excel.
I also will need to export and import data from CSV is there ready made interface or i have to write it on my own.

Thank you in advance.

Nikolay