Open Password protected Excel from Access

D

DCPan

Hi,

How do I work with an Excel spreadsheet that is password protected from
Access?

Is it possible?

In all likelyhood, I would probably be doing a DoCmd.TransferSpreadsheet to
replace what's there. But the new file I deposit would need to retain the
same password protection.

Thanks!
 
D

DCPan

Hi Alex,

I actually found your blog on goggle yesterday after the post.

You wouldn't happen to know how I could "deposit" a password-protected file
would you?

Thanks again!

David
 
D

DCPan

Sorry, by deposit, I meant export.

You blog entry allows the import of a password protected file.

How would you export a file and make it password protected?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Password protect new workbooks from template 0
Exporting from MS Access to a protected spreadsheet 1
Open file password 13
Autonumber field in Excel that behaves the same as Access 0
Word macro that can call cells out of Excel for a find and replace 0
Table Security in Access 2013 1
Export to Excel when password protected 3
Transfer Spreadsheet 2

Top