1. We have moved from vBulletin to XenForo and you are viewing the site in the middle of the move. Though the functional aspect of everything is working fine, we are still working on other changes including the new design on Xenforo.
    Dismiss Notice

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