Determine local system32 folder

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.

Related Articles:

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 »

Share This Article:

Share and bookmark this articledelicious buttonfacebook buttonlinkedin buttonstumbleupon buttontwitter button
Note: Comments are subject to the Blog Comment Policy and may not appear immediately. To post VBA code in your comment, use code tags like this: [vb]your code goes here[/vb]

Add a Comment:

*

Site last updated: February 22, 2012