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