Newbie, whats wrong with this code?

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
Thanks....


Workbooks.Open filename:= _
"I:BDMSFABDMdatafiles ombstonecrm.xls"
Cells.Select
Selection.AutoFilter
Selection.AutoFilter Field:=16, Criteria1:=terrnum
rows("2:4000").Select
Selection.copy
Windows("TADS 1.2.xls").Activate
Range("A2").Select
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories