Alex

presumably you are going around a loop to open and process the files? Why
not record a macro to close one of the CSV files and then incorporate this
code into your loop after you have processed the data ?

If you post an extract from your code (the loop to open and process the csv
files) I'm sure someone will draft some code for you.

Regards

Trevor


"alexm999 " wrote in message
...
I setup a Macro that opens up a bunch of text file and imports them into
a CSV file and then data I need is copy and pasted into specific cells.


Now the problem is that everytime i run the Macro, i get over 31 open
CSV files. Is there a way i can add something to the script that will
close the file automatically for me, but leave my main XLS file open??


---
Message posted from http://www.ExcelForum.com/