Hi, I have this code below but i would like to take the value from "I2" and put that value in the file name if possible. Only issue im having is that, that value in I2 is on another workbook. Workbook 'Test', sheet 'Report'
Filename = "C:\Test\" & Range("I2") & "Done " & Format(Now - 5, "MMMM DD") & " to " & Format(Now + 1, "MMMM DD yyyy") & ".xls"
Bookmarks