SalesDB_Week_20.xlsxNameOfFile = Range("WeekliesName").Value NameOfFile = Replace(NameOfFile, " - ", "_") NameOfFile= Replace(NameOfFile, " ", "_")
SalesDB_Week_20.xlsxNameOfFile = Range("WeekliesName").Value NameOfFile = Replace(NameOfFile, " - ", "_") NameOfFile= Replace(NameOfFile, " ", "_")
Please take the time to read the Forum FAQ