I am running a Macro that takes todays date, alters and formats it as such 07 04 18. Goes into an object, enters the date this way, scrapes data and enters into onto my spreadsheet.
this is the code:
Dim lDate As String
Dim lMonth As String
Dim lDay As String
Dim lYear As String
lDate = Date...