E
Eric
Does anyone have any suggestions on how to retrieve a specific cell value
within specific workbook without opening it on macro?
I would like to set if-statement as shown below
WkbkName = "D:\Documents\TS\file.xls"
If wkbk.Sheets("Check").Range("N18").Value = 1 Then
....
Does anyone have any suggestions on how to code the workbook part? in order
to make it work.
Thanks in advance for any suggestions
Eric
within specific workbook without opening it on macro?
I would like to set if-statement as shown below
WkbkName = "D:\Documents\TS\file.xls"
If wkbk.Sheets("Check").Range("N18").Value = 1 Then
....
Does anyone have any suggestions on how to code the workbook part? in order
to make it work.
Thanks in advance for any suggestions
Eric