Thread: Adding columns from closed files based on cell reference

Hello, here's my problem

I'm trying to create a report which will retrieve data from several sheets which are created by an external application.

The files will named
51200035790010.csv
51200035790020.csv
Etc up to 80

I need to add everything in column F
Everything before "0010.csv" needs to be variable based on input into cell C7


The formula I need will look something like

=sum('c:\temp\[&c7&b11&.csv]'!$F:$F)

I've tried various different combinations but I can't figure it out.

Once this is sorted my next question is how can I retrieve the date from the files without having to open them manually, I have some experience in macros but I would assume that I would need to add in variables similar to above to open and close them or something.


Thanks for your help

Anyone got any ideas?