Go4Expert

Go4Expert (http://www.go4expert.com/)
-   Visual Basic ( VB ) (http://www.go4expert.com/forums/visual-basic/)
-   -   Trouble Entering Network Addresses (http://www.go4expert.com/forums/trouble-entering-network-addresses-t19109/)

diane9410 20Aug2009 19:05

Trouble Entering Network Addresses
 
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:

nimesh 23Aug2009 02:53

Re: Trouble Entering Network Addresses
 
please post your vba macro so that someone can look at it.
do you get any error while using it?

diane9410 24Aug2009 17:31

Re: Trouble Entering Network Addresses
 
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\"

nimesh 24Aug2009 21:35

Re: Trouble Entering Network Addresses
 
oh.. then use this
chr(34) & "\\adam\"

I think this should work

diane9410 24Aug2009 22:29

Re: Trouble Entering Network Addresses
 
Worked perfectly, just what I wanted. Thank you.

nimesh 24Aug2009 22:38

Re: Trouble Entering Network Addresses
 
:welcome:


All times are GMT +5.5. The time now is 07:10.