I have a named range (FilesToOpen) that contains a variable number of
filenames and path (i.e. c:\mydoc\text.xls) that need to be opened
(range FileCount contains number of files).

What I want to do is have a macro that opens all the files in
FilesToOpen range, calculates the original sheet, and then close the
files opened by the macro.

I've been trying with For and Next and open file Range etc. but am
strugling with the syntax. Any help appreciated. Thanks.