Using BrowseFolder Control To Set Path For Saving

.
I'm trying to utilize the BrowseFolder control to obtain the user's preference for saving a file. Just to get the path and append that in the SAVING code.

Using the below macro I can get it to save to the DESKTOP or "C:\Users" but not to any other folder.

Your assistance would be greatly appreciated. I know it's only a word to two ... or a line or two ... but I simply can't get it.
(ps: I want to go this route so the user will not be able to change the filename. The filename is being establish in the TextBox1 control)

Thanks.

Please Login or Register  to view this content.

.
Thanks. I'll give it a go and see what happens.

.

I tried a number of approaches to obtain the selected folder path. There are a lot of suggestions and examples on the .Net but this is the first
one I could get to work for me :

Please Login or Register  to view this content.

Thanks to all who contributed.