Last November Graham Mayor provided me with a great deal of help linking 2 or 3 spreadsheets together - he provided me with a file called 'Process.xlsm. Since then I have modified what he gave me a couple of times to do similar things. Just yesterday I managed to get a whole year's data linked together for the Charity's accounts.



Unfortunately since completing that work when I now try to open the Process file I am getting a Run time error message (see attached) and it highlights a line in the Visual Basic (see the highlighted line in the Visual Basic code attached). The form for selecting the various files that I want to link no longer appears.

Can someone tell me what has gone wrong and more importantly what can be done to fix it?

Attached Images

error message1.jpg (15.8 KB, 18 views)

Attached Files

Visual Basic for Process.docx (12.8 KB, 11 views)