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 can deliver it to you in an hour or two.some questions. are the worksheet names of all the workbooks are same? I will be online.i can start instantly.Thanks!!
12 freelancers are bidding on average $36 for this job
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