Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening with a password with VB
Hello everyone.
Hopefully this will be an easy one for someone out there. I hav created a file with a user form that people fill out, save as a ne file #, save the data to a log, with the original file set to open a read-only if they don't have the password (so that the original is lik a template - these files are located on a network and instead of sendin each user a template to store on their computer, I found this easier). This works fine, all the lists, spreadsheets, etc., populate and hav the info stored as needed. Now what I need to do is when a file i opened (this could be either the original or one of the modified files), I need to test to see if it is the original, if yes then as for password, if not, to open with the password from code so that don't have to give it to the end users. If this is possible, would it be part of Workbook_Open somehow? Thanks in advance for your help! Candee PS. Running Office 97, thanks agai -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Opening with a password with VB
I went about it another way. I originally had ThisWorkbook.SaveCopyAs
I changed it to SaveAs and set the password and WriteResPassword to " and now it seems to do what I need. Thanks anyway e1, and have a super day!!!:cool -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel file opening password | Excel Discussion (Misc queries) | |||
Is there any way to be prompted for a password when opening a file | Excel Discussion (Misc queries) | |||
Password prompt when opening Excel within IE | Excel Discussion (Misc queries) | |||
Excel password protected not opening up on just one PC. | Excel Discussion (Misc queries) | |||
how to automate opening a password protected excel file? e.g. a .xls that has a password set in the security tab. | Excel Worksheet Functions |