I am trying to conduct an automated Find and Replace with VBA Inputbox to simply replace this:
07 July 2019\SpeeDee Royalty Calculation\07.27\Sales Reports\[07.27.2019 Nexgen SpeeDee Report.xlsx]rptCustomMonthlySalesOverview'!$A$4:$I$102,5,FALSE)
To This:
08 August 2019\SpeeDee Royalty...