hiyas all!

currently, i am using code such as the following:

WorksheetFunction.CountIf(Sheets("Serial Numbers").Range("A2:A6000"), str(i))
where str(i) is what i am trying to count


what i want to do is replace the "Sheets("Serial Numbers).Range("A2:A6000")" portion to a hard location of a closed workbook on, say, the D: drive.

for instance, the spreadsheet could be at: "D:\RM\SerialNumbers.xls" and wanting worksheet "Serial Numbers"

is this possible? if so, is there an easy way to find code this? and am i even in the right thread?