Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    obtain the environment variables (OfficeXP SP3)

    hi

    when your are at the command prompt MS-DOS & you type in the command Set
    the result is > it returns the environment variables.

    What I'm after is 'how can I obtain these environment variables using VBA code?
    I'm after the data stored in :
    TEMP=
    TMP=

    Diana

  2. #2
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Melbourne, Australia
    Posts
    1,294
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: obtain the environment variables (OfficeXP SP3)

    Edited by HansV to make URL clickable - see <!help=19>Help 19<!/help>

    hi - I found the following code so I'll work with this . ta diana <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

    http://www.xcelfiles.com/VBA_Quick1.html

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: obtain the environment variables (OfficeXP SP3)

    The Environ function mentioned there is the simplest way:

    MsgBox Environ("Temp")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •