A shot in the dark, because "On Error.." should cure it, addition to Dave's
code:
dim wkbk as workbook
.....
Application.DisplayAlerts=False
set wkbk = nothing
on error resume next
set wkbk = workbooks.open(filename:=file, ..., password:="IncorrectPassword")
on error goto 0

if wkbk is nothing then
'workbook didn't open
else
'do the real work
end if
Application.DisplayAlerts=True

Regards,
The Code Cage Team
www.thecodecage.com/forumz

"Dave Peterson" wrote:

Even with the "on error" stuff?

If that's true, then I don't have a suggestion. (I don't use the compatibility
pack.)

Sorry.

wrote:
<<snipped
Hi Dave,

Thanks for your quick response. The problem I'm getting is that
because I'm in 2003 and the file is xlxs then the password prompt is
coming up and I can 't move on without pressing return.

Cheers

Mac

--

Dave Peterson