I am referring to workbooks by number (I open a workbook and then refer to
it as workbooks(2). Problem is that when I refer to it, it refers to an
invisible workbook that is opening (personal) without my volition. Can
anyone tell me hwat's going on?

Thanks in advance, kind regards, Mark

I don't think I'd ever trust the index into the workbooks collection.

I'd use a variable (or two):

dim ActWkbk as workbook
dim otherWkbk as workbook

set actwkbk = activeworkbook
set otherwkbk = workbooks.open(filename:=.....)

....

then you can do anything you want by using that variable:

otherwkbk.save
otherwkbk.close savechanges:=false




Mark Stephens wrote:

I am referring to workbooks by number (I open a workbook and then refer to
it as workbooks(2). Problem is that when I refer to it, it refers to an
invisible workbook that is opening (personal) without my volition. Can
anyone tell me hwat's going on?

Thanks in advance, kind regards, Mark

--

Dave Peterson