I have this:
Code:
ActiveWorkbook.SaveAs Filename:=Format(Date, "yy-mm-") &
Worksheets("Blank").Range("A1").Value
And This:
Code:
ActiveWorkbook.Save
I want to know how to properly insert a path so it will save to that
whenever I choose to click one or the other. It would be nice if
the actual window box opened up like when you normally save a file so
you can change that path if you wanted, but that isn't needed if it
is beyond very basic code. I do want to dictate the name of the
saved file. The "saved as" file should be: Date, "yy-mm-") &
Worksheets("Blank").Range("A1").Value
But the ActiveWorkbook.save I just want to save the same file to
itself, accepting whatever data changes I have made, but no changes
to the actual file name.
Thanks!