ActiveWorkbook.SaveAs in /TMP?
Posted on 2016-09-21
Please forgive what may be astonishing ignorance.
On a PC, it works, but I can't get it to work on a Mac - Goal is to save a temporary Excel with macros file (so it will be deleted thereafter) with a standardized name for emailing. I'd like to do so in the TEMP directory. Here it is for the PC:
ActiveWorkbook.SaveAs Filename:=Environ("temp") & "\" & Range("J112").Text & " - MCR " & Range("D112").Text, _
I've tested various combinations without success. What to do?