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"
