Importing files

  • Thread starter Thread starter Jacob
  • Start date Start date
J

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.
 
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.
 
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?
 
Back
Top