Hi, Anybody knows how to open xls file, close it and open the next
file.
Ok, this is the case:
I have some xls files in folder c:\mysummary. All of these files have
similar format and formulas. I want to create a macro to open these
file one by one, copy some of the sheets in each file and add them to
the new xls file, at the end I will get a file as a summary from all
files in that directory.
Thanks.