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.