Importing Column A from all the files.

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.

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.