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 CopyPaste2() Dim Wb As Workbook ' current workbook Dim Report As Workbook ' referenced workbook Dim Ffn As String ' full file name of Report Dim Fname As String ' retrieved file name Ffn = "H:\Futures\Macros\F&O Report\F&O Report Instructions Macro 1-22-2014.xlsm" Set Report = GetWorkbook(Ffn) If Report Is Nothing Then MsgBox "Couldn't find the Report", vbCritical, _ "Missing workbook" Exit Sub Else Fname = Report.Worksheets(1).Range("A11").Text & ".xlsx" 'MsgBox Fname End If If Sheets(Fname) = True Then MsgBox "Good, file opened." Else MsgBox "Today's report is currently not opened." End If 'If Len(Fn) Then End Sub
|I need help with an EXCEL Nested formula.||5||24|
|Power BI date filters||3||13|
|I need Excel macro modified to filter remote2office and filter out duplicates.||5||14|
|Index Match does not work why ??||4||16|