worksheet.countif function from outside workbook

**snakeye** · 09-20-2006, 02:47 PM

hiyas all!

currently, i am using code such as the following:

Please Login or Register  to view this content.

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?

**colofnature** · 09-20-2006, 03:17 PM

Either open the workbook (ReadOnly, if you want to make sure it doesn't get changed, or interfere with anyone else using it), or link to the closed workbook using an Excel4 macro. Unfortunately I can't remember how to do that off the top of my head, but if you can wait until I get to work in the morning (about 12 hours) I'll post you the link - unless someone beats me to it! I'm pretty sure the technique is well know, I just can't seem to find it...

Col