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 ActivateWB() Dim UseDate As Date Select Case Weekday(Now) Case 1, 4, 5, 6, 7 UseDate = Date - 2 Case Else UseDate = Date - 4 End Select Windows("UnmatchedReport_GL_8455_56_57_" & Format(UseDate, "yyyymmdd") & _ "_TLM2.xls.xls").Activate End Sub
|Help with Excel formula to look up text in multiple columns then retrieve a value with a formula from another column.||9||33|
|How do I get back values from vlookup's N/A cells?||4||20|
|VBA working with shapes||6||11|
|Check whether active cell resides in a list (list object) by means of a macro||3||10|