If I understand correctly. You can use the stored system variables:
Debug.Print Environ("PROGRAMFILES")
'OR if you want just the drive letter you can also use
Debug.Print Environ("HOMEDRIVE")
'OR
Debug.Print Environ("SYSTEMDRIVE")
Find a large list of these variables here and what they are all about: http://vlaurie.com/computers2/Articles/environment.htm