Session expiration Your session is going to expireClick here to extend

Budget (€) :

Small project <800

Posted on

1/27/13 11:48 AM

This project has expired

Why don't you register anyway? We are sure that you will find many similar projects out of the thousands waiting for you!

Post similar project now


I need help writing a simple macro in Excel 2011, to run on a Mac.

The idea is to save a medical report with a unique filename, into a new folder with a custom name, located on a network drive. If the network drive is not available, a dialog box needs to be opened, allowing the user to choose the correct destination.

(The filename is madeup of a surname, a number and a date, all referenced from a cell - e.g. Smith-1234-11 Jan 2013.  The folder name is made up of just the surname and reference number: e.g. Smith-1234)

The steps are:

1. Give the file a name - from a cell reference (e.g. F6)

2. Check to see if the network drive is available - if not, open a dialog for user to choose a destination

3. If the network drive IS available, check to see if a FOLDER with the correct name ( - from a cell reference e.g. F5) is already present.

4. Save the macro-enabled file in this location, creating the folder if it is not already there. 

There may be some additional work oof this type available, if this goes well.