 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Modules / DAO / VBA / September 2007Open Password protected Excel from Access
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! Hi, have a look here: http://alexdyb.blogspot.com/2005/04/how-to-import-password-protected-excel.html  SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Hi, > [quoted text clipped - 9 lines] > > Thanks! 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 > Hi, > have a look here: [quoted text clipped - 13 lines] > > > > Thanks! Hi, sorry, but don;t understand - what do you mean with "deposit"? SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Hi Alex, > [quoted text clipped - 27 lines] >> > >> > Thanks! 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? > Hi, > sorry, but don;t understand - what do you mean with "deposit"? [quoted text clipped - 30 lines] > >> > > >> > Thanks! Hi, I think the same way - you first create password=protected file, open it in excel, then export to it. SignatureBest regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com > Sorry, by deposit, I meant export. > [quoted text clipped - 38 lines] >> >> > >> >> > Thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.