Copy data from files located in sub folders.

[homegrownandy]

Please Login or Register  to view this content.

I'm using the code above (from a different forum) to search folders and sub folders for xlsx files, and then display results on the workbook I run it from,

However I cant get this to work, Is there any obvious mistakes I've made?

There is no error message so I'm assuming its all running okay its just the fact I get no results.

Thanks in advance!

Andrew.

[karedog]

Hi,

The code is working well here.

The code is looking for all Excel files with .xlsx extension (this means, excluding .xls, .xlsm, .xlsb) in folder :
"C:\Users\Admin\Documents\test"

Then for every file it found, it copy from the activesheet (the sheet that appeared if you open the file manually) on cell C4, D4, E4.

Please check :
- Is the path is correct ? --> "C:\Users\Admin\Documents\test"
- Is the extension is correct ? --> .xlsx
- Is the value you looking for is located at the sheet that appeared when you open the file manually ?
- Are the values you trying to retreive located at C4, D4, E4 ?


Regards

[homegrownandy]

Yes it appears to work for me now also... after an hour of trouble shooting!

I have no idea what the problem was but its working now!

thanks for the reply all the same.

andy.

[karedog]

You are welcome, glad to hear you have sorted it out.


Regards