Hi all,
Is there a way to save-as with only 1 certain macro?
At the moment this done not save any macros but I would like it to keep one when saving
Thank you
Is there a way to save-as with only 1 certain macro?
At the moment this done not save any macros but I would like it to keep one when saving
VBA Code:
Sub SaveFO()
Dim FSO
Dim sFolder As String
Dim Ref
Ref = Sheets("QR9 Order Summary").Range("AG1").Value
sFolder = "O:\Public\Lab consumables\Completed Orders\"
Worksheets("QR9 Order Summary").Copy
With ActiveWorkbook
.SaveAs Filename:=sFolder & Ref, FileFormat:=xlOpenXMLWorkbookMacroEnabled
End With
MsgBox "Completed Order Saved"
Application.DisplayAlerts = False
Application.Quit
End Sub
Thank you