Trouble Entering Network Addresses

diane9410's Avatar
Newbie Member
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.?
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
please post your vba macro so that someone can look at it.
do you get any error while using it?
0
diane9410's Avatar
Newbie Member
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\"
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor
oh.. then use this
chr(34) & "\\adam\"

I think this should work
diane9410 like this
0
diane9410's Avatar
Newbie Member
Worked perfectly, just what I wanted. Thank you.
0
nimesh's Avatar, Join Date: Apr 2009
Invasive contributor