Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change Excel 2003 default "save to" folder? | Setting up and Configuration of Excel | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Save into different "user's" folder | Excel Programming | |||
"Save as" will not work when trying to save a document in a folder | Excel Discussion (Misc queries) | |||
Backup to specific folder if workbook names begins with "NSR" or "MAC" | Excel Programming |