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.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"Jacob" wrote:

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.

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?

"Andy Smith" wrote:

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.

--
* Please click Yes if this was helpful *
Andy Smith
Senior Systems Analyst
Standard & Poor''s, NYC



"Jacob" wrote:

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.