Importing files

[Jacob]

Where can I find some good info on how to import other excel files, access
data base ranges, and other file to import? Any good books on importing excel
files? I have a Power Programing for Excel with VBA but it doesn't show me
how to import data from another Excel file or Access data.

 

[Andy Smith]

In Access you can export any table or query as an Excel file, so then you can
just open it.

In Excel, pull down File / Open, drop down the Files Of Type list and
examine the whole list by scrolling it.

 

[Jacob]

I would like to import data from other Excel files and Access files on a
network drive in VBA, any ideas or code examples? Say I want C5, C7, A1, and
B24 cell values and I have user input a file name to pull these values from,
how could I code this?