I'm distributing a spreadsheet among some inexperienced computer users. I
want them to enter a place (eg Birmingham) into a cell named 'account_name',
and a date into a cell named 'date_taken' on a sheet named 'Grad Info'. I
then want them to click on a button which will automatically save the
workbook as filename: 'account_name date_taken', to a folder named 'Beacon' -
checking if the folder exists in My Documents and creating it if it doesn't.
I'm an inexperienced user of macros and VBA and know that many respondents on
this forum are genii, so would appreciate simple instructions - preferably
aimed at about 'bright nine year old' level. Many thanks in anticipation.