' at the top of a module
Public bk as workbook

Sub HideBook()
set bk = Workbooks("MyFile.xls")
Windows(bk.name).Visible = False
End Sub

Sub UpdateBk()
bk.worksheets("Sheet1").Range("A1").Value = 12
End Sub

Sub SeeDatafromBook()
msgbox bk.Worksheets("Sheet1").Range("A1").Text
End Sub

--
Regards,
Tom Ogilvy

"Ed" wrote in message
...
I have three workbooks open. I'd like to set an object to one of them so
I
can hide it away from the user, but still have it available for VBA to
write
to it. As far as I can tell, I have to use Application.Window, but I
can't
figure out how to set an object to one particular window to manipulate it.
Hints and suggestions are greatly appreciated.

Ed