hi can anyone help me with this problem?

I have a excel raw datafile call holdmail register.xls which is
protected with password when open.

When i use another excel to query using ADODB connection as show below



Dim cn As ADODB.Connection
Set cn = New ADODB.Connection


With cn
..Provider = "Microsoft.Jet.OLEDB.4.0"
..ConnectionString = "Data Source=C:\Documents and
Settings\43230121\My Documents\Working folder\Holdmail\Hold mail
register.xls ;" & _
"Extended Properties=Excel 8.0; User ID=HSBC;
password=holdmail"
..Open
End With


It show me an error as show below
Cannot Start Application. The Workgroup information file is missing or
opened exclusively by another user



The problem is that the file was not open.
Can anyone help me ?

Thank you,


--
brucelim80
------------------------------------------------------------------------
brucelim80's Profile: http://www.excelforum.com/member.php...o&userid=32244
View this thread: http://www.excelforum.com/showthread...hreadid=561987