Success!

Note

Error

Session expiration Your session is going to expireClick here to extend

Budget:

Small project <800

Posted on

1/27/13 11:48 AM

Buyer:

rda***

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

Description

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.