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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    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:
    769
    Likes Received:
    20
    Trophy Points:
    0
    Occupation:
    Oracle Apps Admin
    Location:
    Mumbai
    Home Page:
    http://techiethakkar.blogspot.com
    :welcome:
     

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice