Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org

**
I assume you are talking about saving to My Documents specific to the user running the macro. It is unlikely that you would be capturing the Windows user name in your workflow, but if you were, you could make it a variable and add it to the report to file: line of your macro ....
to-file: C:\Documents and Settings\$WINUSERNAME$\My Documents\Report.rep

Much easier to go to the user's desktop and use the following path which will go to any user's desktop.
Save the report to like this:
to-file: C:\Documents and Settings\All Users\Desktop\Report.rep

James Mckenzie wrote:


Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org





--
MGR Consulting Services
MGRConsulting@snet.net
(203) 248-0481 office
(203) 494-5930 cell

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**
James,
Actually there is a way he he
What you could do is execute a DOS command getting user signed in,
I believe net name in dos will bring back the username
But parsing is another story -- I would recommend doing that in DOS as well at the same time...
I am no expert here..
Then filling in a field, and passing it back to the File with your variable...


Hope that helps...

-----Original Message-----
From: Michael Ross [mailto:mgrconsulting@SNET.NET]
Sent: Friday, December 20, 2002 4:50 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Report to file to the Folder "My Documents"


** I assume you are talking about saving to My Documents specific to the user running the macro. It is unlikely that you would be capturing the Windows user name in your workflow, but if you were, you could make it a variable and add it to the report to file: line of your macro ....
to-file: C:\Documents and Settings\$WINUSERNAME$\My Documents\Report.rep

Much easier to go to the user's desktop and use the following path which will go to any user's desktop.
Save the report to like this:
to-file: C:\Documents and Settings\All Users\Desktop\Report.rep

James Mckenzie wrote:


Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org





--
MGR Consulting Services
MGRConsulting@snet.net
(203) 248-0481 office
(203) 494-5930 cell

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**

Hi James,

1. Write the macro so that it writes the report file into a temp space, let's say "c:\report.rpt".

2. Use the DOS move command to move the report file into the user's My Document folder like that:
move c:\report.rpt "%userprofile%\My Document"

Works fine on Windows XP, not sure about other Windows so you'd better give it a try.

Best regards,

Ashraf Elrefaey
Remedy Developer
Group IT

COLT TELECOMUNICATIONS

-----Original Message-----
From: James Mckenzie [ mailto:james.mckenzie@NETCOM.ARMY.MIL]
Sent: 20 December 2002 21:24
To: ARSLIST@ARSLIST.ORG
Subject: Report to file to the Folder "My Documents"


Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org



*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**
That is it..
I Thought It was there,,, I just forgot... Thanks... Ashraf

-----Original Message-----
From: Elrefaey, Ashraf [mailto:Ashraf.Elrefaey@COLT-TELECOM.COM]
Sent: Monday, December 23, 2002 11:47 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Report to file to the Folder "My Documents"


**

Hi James,

1. Write the macro so that it writes the report file into a temp space, let's say "c:\report.rpt".

2. Use the DOS move command to move the report file into the user's My Document folder like that:
move c:\report.rpt "%userprofile%\My Document"

Works fine on Windows XP, not sure about other Windows so you'd better give it a try.

Best regards,

Ashraf Elrefaey
Remedy Developer
Group IT

COLT TELECOMUNICATIONS

-----Original Message-----
From: James Mckenzie [ mailto:james.mckenzie@NETCOM.ARMY.MIL]
Sent: 20 December 2002 21:24
To: ARSLIST@ARSLIST.ORG
Subject: Report to file to the Folder "My Documents"


Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org



*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************
You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**
Michael:

That looks like the answer. I will pass this onto the Team that asked for it.

James Mckenzie

-----Original Message-----
From: Michael Ross [mailto:mgrconsulting@SNET.NET]
Sent: Friday, December 20, 2002 2:50 PM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Report to file to the Folder "My Documents"


** I assume you are talking about saving to My Documents specific to the user running the macro. It is unlikely that you would be capturing the Windows user name in your workflow, but if you were, you could make it a variable and add it to the report to file: line of your macro ....
to-file: C:\Documents and Settings\$WINUSERNAME$\My Documents\Report.rep

Much easier to go to the user's desktop and use the following path which will go to any user's desktop.
Save the report to like this:
to-file: C:\Documents and Settings\All Users\Desktop\Report.rep

James Mckenzie wrote:


Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org





--
MGR Consulting Services
MGRConsulting@snet.net
(203) 248-0481 office
(203) 494-5930 cell

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

**
Ok. I need to do this without ANY user intervention. Looks like I will have to look at this one. Possible to do this with an Active Link?

James Mckenzie

-----Original Message-----
From: Elrefaey, Ashraf [mailto:Ashraf.Elrefaey@COLT-TELECOM.COM]
Sent: Monday, December 23, 2002 9:47 AM
To: ARSLIST@ARSLIST.ORG
Subject: Re: Report to file to the Folder "My Documents"


**

Hi James,

1. Write the macro so that it writes the report file into a temp space, let's say "c:\report.rpt".

2. Use the DOS move command to move the report file into the user's My Document folder like that:
move c:\report.rpt "%userprofile%\My Document"

Works fine on Windows XP, not sure about other Windows so you'd better give it a try.

Best regards,

Ashraf Elrefaey
Remedy Developer
Group IT

COLT TELECOMUNICATIONS

-----Original Message-----
From: James Mckenzie [ mailto:james.mckenzie@NETCOM.ARMY.MIL]
Sent: 20 December 2002 21:24
To: ARSLIST@ARSLIST.ORG
Subject: Report to file to the Folder "My Documents"


Listers:

I was asked if it is possible to build a macro which will save a text file
report to the logged in user's My Document folder. Is this possible? If
so, how?

Thanks.

James Mckenzie
SR. Systems Engineer
METI, Inc.
CONUS-TNOSC Remedy Support Team
Phone: Commercial (520) 538-6943 DSN 879-6943
E-mail: james.mckenzie@hqasc.army.mil


You may control your subscription options, including UNSUBSCRIBE,and ACCESS THE ARCHIVES at http://www.ARSLIST.org. For ARSList support, please send eMail to support@arslist.org



*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900

This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************
You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface

You may also control your subscription options, including UNSUBSCRIBE, at http://www.ARSLIST.org This posting was submitted via the Web interface