Trouble Entering Network Addresses

Newbie Member
20Aug2009,19:05   #1
diane9410's Avatar
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.?
Invasive contributor
23Aug2009,02:53   #2
nimesh's Avatar
please post your vba macro so that someone can look at it.
do you get any error while using it?
Newbie Member
24Aug2009,17:31   #3
diane9410's Avatar
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\"
Invasive contributor
24Aug2009,21:35   #4
nimesh's Avatar
oh.. then use this
chr(34) & "\\adam\"

I think this should work
diane9410 like this
Newbie Member
24Aug2009,22:29   #5
diane9410's Avatar
Worked perfectly, just what I wanted. Thank you.
Invasive contributor
24Aug2009,22:38   #6
nimesh's Avatar