Determine local system32 folder

January 26, 2012 by JP

Something from the FAQ which probably doesn't belong there:

Function GetSystem32Folder() As String
 GetSystem32Folder = Environ("SystemRoot") & "\system32\"
End Function

Why is this important? I really don't know. But it was a few minutes of fun to find out how to do it. The system32 folder does contain a lot of DLLs which you can leverage in VBA.

Filed Under: VBA

Tagged With: Environ, system32

About JP

I'm just an average guy who writes VBA code for a living. This is my personal blog. Excel and Outlook are my thing, with a sprinkle of Access and Word here and there. Follow this space to learn more about VBA. Keep Reading »