1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Trouble Entering Network Addresses

Discussion in 'Visual Basic ( VB )' started by diane9410, Aug 20, 2009.

  1. diane9410

    diane9410 New Member

    Joined:
    Aug 20, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    I regularly send hyperlinks on our network to customers. I don't want to type the address every time so I wrote a macro that I can copy and paste into the hyperlink. This macro will not work in the Microsoft 2007. Here is an example: ""\\adam\". All I want is a string that prints "\\adam\. This will not work because of the " and \.

    Does anyone have a solution.? :crazy:
     
  2. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    please post your vba macro so that someone can look at it.
    do you get any error while using it?
     
  3. diane9410

    diane9410 New Member

    Joined:
    Aug 20, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    The macro is: ""\\adam\"
    All I want the macros to do is type the above statement: ""\\adam\". This works when written in Word 2007. It does not work when recorded in Outlook 2007. It ignores the first " so I get: \\adam\"
     
  4. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    oh.. then use this
    chr(34) & "\\adam\"

    I think this should work
     
  5. diane9410

    diane9410 New Member

    Joined:
    Aug 20, 2009
    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    0
    Worked perfectly, just what I wanted. Thank you.
     
  6. nimesh

    nimesh New Member

    Joined:
    Apr 13, 2009
    Messages:
    770
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    :welcome:
     

Share This Page