Open, copy and save to password protected workbook

**pjbassdc** · 08-26-2013, 03:19 PM

Hi all,

Having issues with my code. I am working between two network workbooks. One is for data entry, the other is for data collection. For some reason, I am the only one who has been able to get this working and I am not sure why. I have my 1st workbook (EEG Tech form) which is populated and submitted to a 2nd workbook (EEG Billng Log) The EEG billing log has a writerespassword set up (neuro). Here is my code I am using.

Please Login or Register  to view this content.

For some reason, the above is only working for me. Any other user, my terminal or their's, can go through the motions of filling out the form and processing it. It seems to run through all the routines, but the information, even though visible on the opened sheet (EEG Billing log), does not save.

I am wondering if I might not be getting the password submitted correctly. I have really run out of ideas and could use some expert advice as to why this isn't working as I would like.

Let me know if you need a sample project.

Many thanks,
Patrick

**pjbassdc** · 08-27-2013, 08:02 AM

BUMP......

Any takers?

Thanks,
Patrick

**pjbassdc** · 08-27-2013, 11:46 AM

So....I did some more searching and taking bits and pieces of code I have found around the web. I have updated my original post with my current code, which is still giving me issues. I have put in an error handler and have a bit more info. The error discription states that it " can not access read only document".

I suppose my code isn't passing the password to the workbook in a way that it needs. Once again it is very confusing because I am not personally experiencing it. All my co-workers seem to be having the issue.

Ideas or solutions welcome.

Patrick