A am trying to get the value of a cell in a closed workbook. Any idea on how I can do the below? It works if I have the workbook open and remove the file location. Thank you in advance!
eqque2 = Workbooks("F:\MODEL\Trading\Queue\test\MAB Pending.xls").Sheets("Queue").Range("k1").Value
eqque2 = Workbooks("F:\MODEL\Trading\Queue\test\MAB Pending.xls").Sheets("Queue").Range("k1").Value