i got an Excel spreadsheet that shows data from an Access
query. that Access Database (mdb file) is password
protected so whenever i try to open the Excel spreadsheet
it asks for the password. is there any way that i an open
the Excel file without it asking for the Access Database
password?... of course without removing the password
protection from the Access file. it is probably very easy
with some VB coding. if anyone know or can help me with
the code, it will be greatly appreciated. thanks in
advance.

chaprastee

If you are importing the data into a spreadsheet, simply right click in the
data and select "Data Range Properties...". In the Properties dialog, at the
top, select the "Save password" checkbox.

Alternately, you can right click in the data area and select "Edit Query..."
and manually enter in the password between the quotes.

Either way, anyone who opens the "Edit Query..." menu item will be able to see
the password. Not too bright, Microsoft...

If you have a pivot table then right click in the data area, select Wizard...
then click on the Options... button. In the Options dialog select the Save
password check box near the bottom of the dialog.

--
Toby Erkson
Oregon, USA

"Chaprastee" wrote in message
...
i got an Excel spreadsheet that shows data from an Access
query. that Access Database (mdb file) is password
protected so whenever i try to open the Excel spreadsheet
it asks for the password. is there any way that i an open
the Excel file without it asking for the Access Database
password?... of course without removing the password
protection from the Access file. it is probably very easy
with some VB coding. if anyone know or can help me with
the code, it will be greatly appreciated. thanks in
advance.

chaprastee