I've about 30 excel files in a folder (folder name is Jazz) on the C: drive. I'm looking to write a macro that will import Column A from all the 30 files and bring it under the new file called Result.
I've about 30 excel files in a folder (folder name is Jazz) on the C: drive. I'm looking to write a macro that will import Column A from all the 30 files and bring it under the new file called Result.
This can be easily accomplished with RondeBruin's add-in
Hi
The following code will import data from the files without opening
enter the file names in cells (eg: File1.xlsx, File2.xlsx ) and give the range name as "Filename".
the following code will import Range A1 to A50
make changes where ever necessary
![]()
Please Login or Register to view this content.
Can you help me execute this code. A step by step approach will be appreciated.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks