Importing an Excel File

[Guest]

Does anyone know if there is any way of imorting a protected Exel file
without knowing the password or at least being able to copy and paste from it
without knowing the password?

Thanks,

Sarah

 

[John Vinson]

Does anyone know if there is any way of imorting a protected Exel file
without knowing the password or at least being able to copy and paste from it
without knowing the password?

Ummmm...

What would be the use of protecting a file if it could be read without
the password?

No. There isn't. (Not without expensive and probably illegal cracking
software anyway).

John W. Vinson[MVP]

 

[Guest]

It's not like you can't open this file up right now and read it. Protected
files can be opened and read by Excel, but I want to be able to do this in
Access. My workaround is to open the file and copy the contents into an
unprotected Excel file and use that file in my database. I just wanted to be
able to read that file directly instead of having to do that manual step.
Unless jthere is a way to do that programatically?

 

[John Vinson]

It's not like you can't open this file up right now and read it. Protected
files can be opened and read by Excel, but I want to be able to do this in
Access. My workaround is to open the file and copy the contents into an
unprotected Excel file and use that file in my database. I just wanted to be
able to read that file directly instead of having to do that manual step.
Unless jthere is a way to do that programatically?

You *do* need the password to "open this file right now and read it",
do you not!? It sounded like you wanted to simply bypass security
altogether and open the spreadsheet, without knowing the password.

It should be possible to specify the password in an ADO Connection
object, linking to the spreadsheet, but I can't recall just how.

John W. Vinson[MVP]

 

[Guest]

No you do not need the password to open this file and read it. That is what
I am trying to tell you. Only the sheet is protected. All I want to do is
copy what's on the sheet into another excel workbook or into an access table
programatically.

 

[John Vinson]

No you do not need the password to open this file and read it. That is what
I am trying to tell you. Only the sheet is protected. All I want to do is
copy what's on the sheet into another excel workbook or into an access table
programatically.

Ok... sorry, I'm not at all familiar with the Excel security model.
You might want to ask on an Excel programming newsgroup - you can
certainly run Excel Macros from Access. It may be easier to move the
data around in Excel (executing it from Access) than to try to do the
linking.

I still don't see what the point of having a sheet "protected" might
be if you can just open it and read it!

John W. Vinson[MVP]

 

[Guest]

The purpose of having a protected worksheet with read access is so that the
formatting of the sheet is protected. Therefore columns cannot be accidently
deleted or changed, etc...

Ok, I'll ask this question elsewhere. Thanks.