Moved workbooks to folders now User form "Subsript out of range"

Hi Guys
I'm sure this must be an easy fix and I'm sure I'll look like a fool once It's resolved!
The attached workbook has a userform which was searching the same folder where this file is located for entries in columns "A" and "B" of files named in column "I" (workbook1, workbook2 etc).
I have this placed on a sharepoint and want to move the files into specific folders (folder1/workbook1, folder2/workbook2 etc.) so I can set them as view only folders to stop unuathorised editing.
I am now getting a "Subscript out of range" error after doing a search. I can see it's a problem with the file name as it's pulling it from text in a cell but can't work out a fix!

Thanks!!

Hi Roy

Thanks for your reply.
The workbooks open method seems to work Ok as the I've changed the cell value it's referencing to reflect the new path....from workbook1 ".xls" to folder1\workbook1 ".xls"; it seems to screw up here:

Please Login or Register  to view this content.

Thanks

Hi Roy

No not changed this workbook path...am a little confused!!
This is on a sharepoint and as the codes stands I can see a dialogue box open and it is openeing the file from within the new folder with the new path name visible....this is why I assumed this part of the code was OK!!

Hi Roy

Tied up at the moment will try later and get back 2 U.

Thanks

Hi Dave

My sincere appologies.....I was sure I'd updated the thread!!

Any way here's the resolution...

Please Login or Register  to view this content.

Thanks again!!