View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ron de Bruin Ron de Bruin is offline
external usenet poster
 
Posts: 11,123
Default Save into different "user's" folder

Try this JohnUK

SigString = "C:\Documents and Settings\" & Environ("username") & _
"\Application Data\Microsoft\Signatures\Mysig.txt"

Part of this macro
http://www.rondebruin.nl/mail/folder3/signature.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"JohnUK" wrote in message ...
Hi All,
Can someone help me with this? I am looking for a way to automate a file to
save into different USERs Signatures file (For Outlook)
I know that if it was in Documents I could have used the
€˜Application.DefaultFilePath, but because the Signatures Folder is the
€˜C:\Documents and Settings\USER\Application Data\Microsoft\Signatures path,
I am stuck (USER being the problem)
Any help greatly appreciated
Regards
John