Mvidas thanks for the ADO code, I'll give it a go shortly to see what it does.

I managed to pick up the path from my spreadsheet using the last of your code posted on the 4th. I had to set tempStr to Public at the start of the Module to get the value to move between Modules (probably obvious to you but a learning point for me ). It doesn't seem as though it'll keep the value as looking at the value at the start of running the cde for a second time it shows "". I've looked at help and it seems I may have to change the variable to Static, I'm not sure but that's my next thing to try.

Is there a way to get a name on a button / Tab from the spreadsheet?

As requested I attach my form (I hope it's attached it's my first time trying). It seems that 2 files are created when I exported and as the file types aren't supported I've zipped them.

Hope that's correct

Regards

Jeff T