Relative Reference File Name- Why Not Working?

[Sgligori]

How can I change the file name from "File 1", "File 2", etc. to whatever it says in Cell A10?

Please Login or Register  to view this content.

[6StringJazzer]

You can change this

Please Login or Register  to view this content.

to something like this

Please Login or Register  to view this content.

BUT you don't say what worksheet contains cell A10. That's important. Because you are looping through the sheets maybe you mean each sheet:

Please Login or Register  to view this content.

[Sgligori]

Second one worked. THANK YOU!!!

[6StringJazzer]

Is this the same question you are asking in this thread: http://www.excelforum.com/showthread...7412&p=4152925

[Sgligori]

No, they're two separate questions.