I'm using VBA in Excel 2011 on a Mac in macOS 10.13.4 (High Sierra). I can't find the right code to close the file in which the macro resides - I keep getting an error message, RunTime error 1004 based on the close command. I've tried:
ActiveWorkbook.Close
Workbook.Close
ThisWorkbook.Close
and they all fail. What should I be doing?
Bookmarks