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

John,

Try this

Dim sPath As String

sPath = Replace(Application.StartupPath, "XLSTART", "")
ActiveWorkbook.SaveAs Filename:=sPath & "TestWorkbook.xls"


--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"JohnUK" wrote in message
...
Bob,
I still have the problem with not having the user:
ActiveWorkbook.SaveAs Filename:="C:\Documents and Settings\Application
Data\Microsoft\Stationery\TestWorkbook.xls"
Because of not having a username the macro can't find its way.
The only other way I can think of is collecting everyone's username that
has
been programmed onto their PC's (All 20 of them) and writing out the code
20
times. This seems just too painful just to get the file into the right
Folder.
My boss doesn't half give me some complicated challenges.



"Bob Phillips" wrote:

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