BrowserForFolder on 64bit Excel

[KallunWillock]

I note from your demo workbook that the BrowseForFolder routine does not work in Excel - sure enough, it crashed when I tried it. I knew that the API was temperamental in 64-bit Office, though I wasn't aware that it was an Excel specific issue.

In any event, I have uploaded to my Github repo the BrowseForFolder routine that works (for me, at least) in Excel 64-bit, in hopes that maybe we can reverse engineer why one version works and the other doesn't. I had a quick look during lunch, and nothing jumped out at me as being obviously or materially different - save for the fact that mine is currently contained entirely in a BAS module and is not unicode-capable.

[OlimilO1402]

OK, I was tryin but it still does'nt work. Don't have enough peace to get into it in more detail, atm. "Unfortunately" I have decided requirements like code running everywhere and unicode, so I can not just replace it with another code.

[KallunWillock]

Ok, I went ahead an updated the code to make it Unicode compatible now, and have checked it with my Japanese language folders/files. I made a few other minor changes, so hopefully it now works for you. I uploaded the updated version here: https://github.com/KallunWillock/JustMoreVBA/blob/main/Boxes/modBox_BrowseForFolder.bas