error 9 'subscript out of range' using workshhets function
 

using workbooks.open filename:="C:\test.xls" I can open successfully open
test.xls
using worksheets("Sheet1").activate activates worksheet 1 of test.xls
however
workbooks("test").activate causes error 9

Any suggestions as to the cause. This code worked fine 2 days ago but now I
get error 9 for most functions and properties of worksheets.

The namespace is correct and the file is open and accessible as proven by
the worksheets function.

Any help/suggestions gratefully received.

error 9 'subscript out of range' using workshhets function
 

workbooks("test.xls").activate
--
Gary''s Student - gsnu200799

error 9 'subscript out of range' using workshhets function
 

Your a star. I can't believe that it was that bloody simple. Thanks.

error 9 'subscript out of range' using workshhets function
 

You are quite welcome!
--
Gary''s Student - gsnu200799


"Toby" wrote:



Your a star. I can't believe that it was that bloody simple. Thanks.