Hi,
I have hundreds of csv/xlsx/xlsm files that contain data which i need to have in one excel sheet. I know I can insert one at a time but i am looking for an easier way that is only by VBA.
If code would have option as well to select the folder it will be useful.
I would greatly appreciate your help,
Kind regards,
I have hundreds of csv/xlsx/xlsm files that contain data which i need to have in one excel sheet. I know I can insert one at a time but i am looking for an easier way that is only by VBA.
If code would have option as well to select the folder it will be useful.
I would greatly appreciate your help,
Kind regards,