Whats the syntax for opening the file with the password?

Workbooks("MyBook.xls").Open password:="MyPassword"

Also, is there a way to open the file, such that the user can't see
that its open?

The easiest way is to save it as a hidden workbook. Choose Window/Hide
from the Excel menu and save it that way from the Visual Basic Editor.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *


"Viggy " wrote in message
...