Greetings, I am using the following sub to save a single WS from a WB onto a network drive and it works flawlessly.
Sub ExportElReport()
Dim wb As Workbook
Sheets("Emergency Lighting Inspection").Copy
Set wb = ActiveWorkbook
With wb
application.DisplayAlerts = False
.SaveAs...