Shell Hell for VBA 64 bits

Microsoft, Non classé, Software

One of the useful uses of the Windows API, back in the old days of 32 bits programming, was to use the shell’s standard dialogs for browsing for a folder or picking a file. VB/VBA didn’t have a way to do that, whereas today, modern VB, I mean VBA7 of course (today’s “Visual Basic” denomination being attributed to the VB.NET treacherous brother), has beautiful means to do that; just install some megabytes of Office and there you go.

So there is the 32 bits code I use for browsing for a folder:

Now, I couldn’t find a way to make this work in 64 bits, and frankly, Internet has a lot of bugged code for you to try to. Many claim to have something working, I couldn’t find the correct declarations and calls to avoid GPFing. The crashes occur when invoking SHGetPathFromIDList.

Here’s how to do it in modern VBA (got it on, and in classic VB5/VB6; note that we don’t need a port anymore as there’s is no 64 bits VB/VBA, thanks Microsoft, we always knew you wouldn’t let us down:

So, SHxxx or Shell functions are indeed hell-ish! As another example, it took me quite some time to port to 64 bits the damned SHGetSpecialFolderLocation function.

Again, hard to find any truly working code on the net.
So, let’s go for mine if you don’t mind. Here’s how I declare it:

And there’s how I make it work without crashing:

Hey, hope I spared you some head banging guys !

Time to post a decent comment (“Woaw”, “You suck” are ok too), fellow VB/A developpers.
I need to be a bit encouraged; then I’ll post my solution for another piece, the API way of using the clipboard (getdata/setdata with text), 32 and 64 bits compatible, a working one again.

Cheers 😉

6 comments… add one

Leave a Comment