I wrote a Macro to simplify a process at work.
I am trying to figure out how to fix this date so when the macro is run it isn’t missing an “.”
here is my code:
Dim currentDate As String currentDate = Left(Replace(Date, "https://stackoverflow.com/", "."), 5) Right(Date, 2)