extracting cell value from ech file of a folder

[anilg0001]

using the following code i am extracting the file name from a folder to A range
now i need to extract value of C47 cell of each file at B range
is it possible??

Please Login or Register  to view this content.

[patel45]

Please Login or Register  to view this content.

[anilg0001]

thank you patel
but is there no way without open each file?

[anilg0001]

the following macro is working but if the file name contain ' then it shows error
is ther any way to change?

Please Login or Register  to view this content.

[anilg0001]

mr patel

how can i extract the file name of the same folder at A range??

[patel45]

Please Login or Register  to view this content.

[/QUOTE]