I am looking to automate a couple of tasks for an Excel workbook
stored on a mapped network drive that will be accessed and shared by
multiple users. A list of these tasks is as follows:

1) Automatically execute a macro in the workbook every night at 12:15
AM. My initial thoughts are to write a VBScript file that will create
an instance of Excel, open the workbook and execute the macro. The
VBScript will be run using Windows Scheduler on the workbook's host
computer.

2) Allow users to open the Excel workbook from within a 3rd party
application, make changes if necessary and save the file. (Note that
the 3rd party application is built on top of VBA, which I already have
the code for opening the file.) My problem is how to give multiple
users the ability to open the file, edit and save changes. My first
inclination is to copy the file to the user's local hard drive and
then open it. The problem then becomes if the user makes a change and
saves it the file will still be on their local hard drive and not on
the network drive for other users to access. The only way I can think
of to do this is to a special macro for saving the file back to the
network drive.

Any help is greatly appreciated.

Thanks.

-Jim