| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy data from all the file file from a folder.
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy data for match word from one file to another file | Excel Worksheet Functions | |||
| Open and copy all workbook sheets in a folder to a master file | Excel Discussion (Misc queries) | |||
| Capture data in one 'destination' file from varied 'source' file stored in one single folder. | Excel Programming | |||
| Create a copy in the same folder when a file is modified and saved | Excel Discussion (Misc queries) | |||
| Copy an excel file to new created folder | Excel Programming | |||
Threaded Mode
