I've had a VBA macro heavy spreadsheet I've been using a long time. I've had 2 problems and here are the fixes in case anyone has a similar problem.
Problem 1: Macro to name file by date was a major headache I solved by making a "save file as" cell on the sheet that I type the name of the...