64 bit API query-SendMessageString (Upgrading Bovey/Bullen Folder Picker)

I've been using Rob Bovey/Stephen Bullens API Folder Picker for a while now however it isn't 64 bit compatible. So I am trying to convert all API procedures & User Types and I think I only have one left to do.

I need a 64 bit version of the following API:

Please Login or Register  to view this content.

It's not in the MS API PtrSafe document so where do I find this?

Originally Posted by mc84excel

It's not in the MS API PtrSafe document so where do I find this?

Just to clarify, it is in that document, but as SendMessage. The only reason they chose to name it SendMessageString is that they changed the lParam argument to String from Any.

Because the easy option is never the right one for some...

Originally Posted by romperstomper

Because the easy option is never the right one for some...

now now - if we always chose the easy option, how would we ever learn?

Originally Posted by Bob Phillips

Why would you bother persisting with that horrible API folder picker, instead of using Application.FileDialog(msoFileDialogFolderPicker)?

Good to hear from you again (I'm now a heavy user of custom ribbons since you last helped me )

I use that one as well. In fact I have three(!) different folder pickers that I regularly use (one based on the FileDialog, an API picker by Bullen/Bovey and an API picker adapted from J Walkenbach)

As for why would I persist with the Bullen/Bovey API folder picker? Fair question. It has a few advantages over the FileDialog method:

1. You have the option of adding a 'Create New Folder' button to the picker
2. You have the option of adding a custom message to the picker
3. Lastly - and this is the main reason why I prefer the API version in non-personal projects - I have had end-users confused by the FileDialog picker! I kid you not. Some people just don't grasp that they need to drill to the folder, or when they do - they drill into the folder they want and wind up inadvertently selecting a sub-folder. I haven't had any negative feedback on the API version - which I put down to the fact that it looks and acts like the familiar Folder Tree.

Originally Posted by romperstomper

Just to clarify, it is in that document, but as SendMessage. The only reason they chose to name it SendMessageString is that they changed the lParam argument to String from Any.

Ah ha. That explains it. Thanks Rory +1

I've added 64 bit versions of the APIs and UDT. Is that all I need to do to make it 64 bit compatible? Do I need to change any of the Long variables to LongPtrs for instance?

I don't have access to any 64 bit version of Excel to test this on (I installed 32 bit by choice - and will keep doing so until there is a 64 bit version of MZTools!) Is there any 64 bit user who wants to volunteer to test it?

Yes you need to declare the relevant Longs as LongPtr, using conditional compilation.

It's extremely difficult to upgrade a module to 64 bit compatibility when you only have 32 bit installed!

I was using a PC the other day with 64 bit Office so I tested this module on it. Using 64 bit made it much easier to see any variables I had overlooked!

IDK if it is fully upgraded now but it no longer issues a compile error on 64 bit so I'll mark this thread solved.