I have a small module that opens a file on a shared network drive and copys information back to the sheet. This works with some users but some get a runtime error#9, subscript out of range when the "Windows("TADS 1.2.xls").Activate line is ran.
I know I am missing something but I am new to this.Thanks in advance on any help you could provide.
I am using Excel 2003 sp2 and the workbook with the code is TADS 1.2.xls
Workbooks.Open filename:= _
Selection.AutoFilter Field:=16, Criteria1:=terrnum