Importing Column A from all the files.

[Pigggy]

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.

[Pepe Le Mokko]

This can be easily accomplished with RondeBruin's add-in

[Sadath31]

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.

[Pigggy]

Can you help me execute this code. A step by step approach will be appreciated.