EXCEL SQL Problem
 

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

EXCEL SQL Problem
 

I know that older versions of Excel had some "database" capabilities
that have not been continued. Perhaps this is the cause of your
problem.


--
raypayette


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

EXCEL SQL Problem
 

what happens

A - if you try to open it as a spreadsheet - ie do you get the same
error?
B - if you try to open it as a spreadsheet in code?

might help to diagnose the problem


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

EXCEL SQL Problem
 

hi

i have encountered the same problem when i create a new workshee
protected with password. The password is used to open the excel file.

When i wrote another excel to query using ADODB Connection. It wil
give me the same error.

When i open the raw data, it working fine after entering the passwor

--
brucelim8
-----------------------------------------------------------------------
brucelim80's Profile: http://www.excelforum.com/member.php...fo&userid=3224
View this thread: http://www.excelforum.com/showthread.php?threadid=56198

EXCEL SQL Problem
 

Theses articles may help:

http://support.microsoft.com/?scid=kb;en-us;300699

http://www.programmingtalk.com/showthread.php?t=7763

http://experts.about.com/q/Visual-Ba...nnection-1.htm

sorry haven't got time at the moment to look further


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