Import Protected Excel Worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 23 Nov 2006 03:27 GMT

Does anyone know if there is any way of importing an Exel file which has a
protected worksheet without knowing the password or at least being able to
copy and paste from it without knowing the password? All I want to do is be
able to the read the data from the protected worksheet and insert into a
table.

Thanks,

Sarah

Reply to this Message

Alex Dybenko - 23 Nov 2006 08:51 GMT

Hi,
well, the only way I know - is to supply password for excel file - then you
can import. Perhaps you can use some tool to get a password, which are
available on internet, and then supply this password

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

> Does anyone know if there is any way of importing an Exel file which has a
> protected worksheet without knowing the password or at least being able to
[quoted text clipped - 6 lines]
>
> Sarah

Reply to this Message