I am after a excel macro/vba code which i can execute which process multiple excel files in a directory/path i select and extracts a sheet i specify e.g "DataSheet" and saves it as a *.csv file with the same name as the excel file it originated from. The excel files in the folde/path can be *.xls/*.xlsx/*xlsm files.
Hi, I already have faced with this problem. I just checked and I have parts of the code I did some time ago. Contact me if you are interested. Sincerely, Miguel Gonçalves