Having another look at a Macro that I've had parked for a while as I am stuck on one piece:

At the moment it has the options to export to a pre defined folder in the Macro code or if you wish you can select a specific folder using the browse button. What I would like to do is have it so that the user can copy and past a folder location into the highlighted space to set an export location rather than have to use the browse button a navigate.

Possible?

Even if you have to paste the file path in the click another button on the form to  'set path' that would be better than nothing!