H
Heera
Hi,
If suppose I have 10 different files in a folder I want the macro to
open the files one after one and copy the data from the file and paste
it in a different workbook.
While doing the same the macro should also rename the tab with the
files name from which the data is copied.
The number of files may increase or decrease.
I just want to mention the path of the folder I don’t want to copy the
names of the files because every time the file names changes.
Any solution for it.
Regards
Heera
If suppose I have 10 different files in a folder I want the macro to
open the files one after one and copy the data from the file and paste
it in a different workbook.
While doing the same the macro should also rename the tab with the
files name from which the data is copied.
The number of files may increase or decrease.
I just want to mention the path of the folder I don’t want to copy the
names of the files because every time the file names changes.
Any solution for it.
Regards
Heera