simora
08-26-2016, 12:42 PM
Trying to write the SaveAs location that a user selects to a Worksheet cell,
and to write ONLY the location without the filename used in Cell A22 & use it in a Variable.
I tried modifying code like this, http://software-solutions-online.com/excel-vba-save-file-dialog-getsaveasfilename/
but, still inelegant and not working for me. Any ideas?
and to write ONLY the location without the filename used in Cell A22 & use it in a Variable.
I tried modifying code like this, http://software-solutions-online.com/excel-vba-save-file-dialog-getsaveasfilename/
but, still inelegant and not working for me. Any ideas?