Try an Outlook newsgroup, not an Excel one. There is an Outlook.general, and
an Outlook.program_vba.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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 USER's 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

Thank you Bob for answering.
I also need to auto save an excel workbook into a different directory (USER)
still being the problem. I used the Signatures Folder because Of another
project similer to the excel (Sorry, I shouldnt have used the Outlook word)
Can you help me?
John

"Bob Phillips" wrote:

Try an Outlook newsgroup, not an Excel one. There is an Outlook.general, and
an Outlook.program_vba.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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 USER's 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

Saving an Excel workbook to another directory is straightforward

Activeworkbook.SaveAs Filename:= "C:\newdir\myfile.xls"

To auto-save it, you would use the BeforeClose event, but where would it get
the name to save under from?

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JohnUK" wrote in message
...
Thank you Bob for answering.
I also need to auto save an excel workbook into a different directory
(USER)
still being the problem. I used the Signatures Folder because Of another
project similer to the excel (Sorry, I shouldnt have used the Outlook
word)
Can you help me?
John

"Bob Phillips" wrote:

Try an Outlook newsgroup, not an Excel one. There is an Outlook.general,
and
an Outlook.program_vba.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"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 USER's 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