ExecuteExcel4Macro to get value from closed workbook
It depends on how you use it. The open file dialog box is being showed to you because the “strPath” doesn’t have a “” in the end 😉 Try this code. Option Explicit Sub Sample() Dim wbPath As String, wbName As String Dim wsName As String, cellRef As String Dim Ret As String ‘wbPath = … Read more