References to cells in another workbook

[Mr Ellis]

Hi,

This is a pretty basic question, but I can't seem to do what I want.

I have a personal finance program which dumps exports from my bank
accounts into a series of CSV files in a single Windows folder. I want
to pull all the data together into a single Excel worksheet. So how to
I reference cells in another file? Ideally I'd prefer it to be doable
without having to have all the CSV files open.

Thanks

 

[Gord]

*.csv files do not have cells.

You must open these files and save as Excel files before you can
reference cells.

Or import each directly into a single worksheet through Data>Import
External Data.


Gord Dibben Microsoft Excel MVP

 

[GS]

Mr Ellis pretended :

Hi,

This is a pretty basic question, but I can't seem to do what I want.

I have a personal finance program which dumps exports from my bank
accounts into a series of CSV files in a single Windows folder. I want
to pull all the data together into a single Excel worksheet. So how to
I reference cells in another file? Ideally I'd prefer it to be doable
without having to have all the CSV files open.

Thanks

Optionally, you could use ADO to extract the data without opening the
files in Excel. For sample code...

http://www.appspro.com/conference/DatabaseProgramming.zip

 

[Mr Ellis]

*.csv files do not have cells.

You must open these files and save as Excel files before you can
reference cells.

Or import each directly into a single worksheet through Data>Import
External Data.

Gord Dibben    Microsoft Excel MVP

Thanks for the replies guys. I didn't mean to be a hit and run poster,
I went away and I've just come back and sorted out the problem thanks
to your advice. Gord's observation was very helpful - because Excel
helpfully opens a CSV file and makes it look like a spreadsheet with
cell references I was getting fooled into thinking that it was.