Rons Website would be an excellent resource for this...
http://www.rondebruin.nl/copy7.htm

"Eric" wrote:

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