If you want to create a new macro w/ embedded report: Create a report. Then open the Remedy screen you want, and put in your search. Turn on macro recording. Click on Tools -> Reporting and select your report. Click on Report -> Export to File. Select the Prompt for Filename checkbox on the Save Window dialogue box that pops up. Enter some file name and hit OK Save the macro.
Distribute this macro out to your users. Now whenever they run the macro, it will prompt them to where they want to save the file. They can choose their local computer. If you want to take the current macro file that already exists: hack the current macro file to change the save path. Find the line: "to-file: <Network Directory>" and change it to "to-file: <Local Directory>". If you wanted it to prompt for a file name, then change the "to-file: <Local Directory" to "to-file: ". This would look like the following in your macro file: Statistics: ||to-file: |O|end|| If you have troubles with the hacking it, then follow my first step above to create a new macro with embedded report so you can see exactly how the syntax is. If the macro is centrally located, you might be able to use some of the windows wildcards to specify the directory, so it will be different per user. You could use a to-file: of like %USERPROFILE%. To see what this would be for a given user, open up a command window and type in "echo %USERPROFILE%" and it should show you. You could append folders to it, such as %USERPROFILE%\Desktop -- this might work, although I'm not sure. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of George T. Sent: Wednesday, January 10, 2007 4:57 AM To: [email protected] Subject: Re: Macro -- Save report to Local Computer On Tue, 9 Jan 2007 18:32:59 -0500, SUBSCRIBE arslist Vicky Zen <[EMAIL PROTECTED]> wrote: >Is is possible to have a macro being run by different users to save the >report file on their local desktops (C:\temp)? We have an existing macro >that saves the report to a shared location, but, not all the users have >access to that location. Wondering if it is possible to modify the macro, >so that the resulting file can be saved on their respective computers. > >Thanks for the help, >Vicky I have a number of reports the use a Visual Basic (VB) Script that does this. This is being used to report 'assets' of an office selected from a menu. Active Link is used to open a search dialog where the parameters are selected. It then passes the parameters and starts the VB script that is creating the report (spreadsheet) on the specified local drive. I use the Active Link / VB script combination since I find the VB easier to revise when needed. George T. Harrisburg Pa. ____________________________________________________________________________ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
