importing multiple excel files using only certain cell values.

I want to save multiple .xls files from email and save them into:

n:/importxls/import/

I then need a script that runs through all the excell files and imports values from certain cells. I need it to do this for every file and import it into my 'maindatabase'.

Any offers?

To make it clearer:

I need to import all .xls files from a designated folder, and only certain cells within these .xls files.

Can anyone point me in the right direction??

I have something, but im really not to sure if its anything like:

Dim myfile
Dim mypath
mypath = "n:\importxls\aramiska\"
Do
myfile = Dir(mypath & "*.xls")
'this will import ALL the excel files (one at a time, but automatically) in this folder. Make sure that's what you want.
DoCmd.TransferSpreadsheet acImport, 8, "aramiskaimport2", mypath & myfile
myfile = Dir
Loop Until myfile = ""


ps _ I want to import INTO access from external .xls files.
aramsiakimport2 is my access table name.