'Consolidate' Macro stopped working

Hi Guys,

I have been using a bit of code I got on here, it is:

Please Login or Register  to view this content.

Excuse the bit at the end, that is just tidying up formatting.

Anyhow, this has all worked well but I have recently re-installed my system and changed the filepath (it is right, I can get a macro to open it) but the above macros isn't doing anything other than setting up my consolidate sheet and formatting it - it isn't opening any files.

Any ideas why?

Thanks

I have managed to make it work but don't understand the reason it now needs this. I guess the problem is coming in about a third of the way down with:

Please Login or Register  to view this content.

The next line is:

Please Login or Register  to view this content.

But this isn't giving me any results (I put in a bit which gives me an error code if fname = 0). If I amend it to be:

Please Login or Register  to view this content.

It gives me results. However it fails at:

Please Login or Register  to view this content.

Again, it works if I roll in the fpath to give:

Please Login or Register  to view this content.

Now it seems to work. But why!? Why is the Chdir not bringing me to the specified directory? Why is my workbook open function not working with the fname I have specified (I presume fname is taking on only the name and not the path, even though I have specified path...).

I am confused as to why this has changed...