I really struggled with understanding the code you supplied. I couldn't work out how to preset the starting folder. Neither do I understand about Functions. (keeping in mind the whole project has been developed by semi-mindless fingers crossed copy paste and hope..)
I'll give it another shot though.
The code above presumes the user will select OK to continue. Would it work if the code presumes the user selects cancel and only explicitly continues on OK.
I am thinking something like:
If .Show = -1 then continue, Else End Sub. ( I am not sure how to write this correctly, I'll try again tomorrow)
Regards from Queensland
|