Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Sub CopyToNew() Dim ws As Worksheet Sheets(Array("SO")).Copy For Each ws In ActiveWorkbook.Worksheets ws.UsedRange.Value = ws.UsedRange.Value Next ws Application.DisplayAlerts = False ActiveWorkbook.SaveAs "\\BCAR1\BCAR-Net\IT\Excel Spreadsheets\Daily SO Report\Daily SO Report.xlsx" Application.DisplayAlerts = True End Sub
Join the community of 500,000 technology professionals and ask your questions.