captsalmon
New Member
- Joined
- Oct 29, 2012
- Messages
- 6
I have an odd question. I help hospitals in low resource setting to develop locally sustainable patient data management methods (not necessarily computer based...paper is at times the best solution).
One hospital in Dar es Saleem decided to password protect a PDF Fillable Form I setup for them to use to collect data from paper form. Over 2,000 forms filled, each with the same password. Now I need to extract the data into a spreadsheet for converse to a new electronic database. But can't because of the password. The Adobe community has so far not responded to request for options. Since I am much more familiar with Excel, VBA and using VB from within a macro, I want to see if it is possible to use VBA to:
1) open a PDF Form file from the C-drive
2) select File tab
3) select Properties tab
4) select Security tab
5) change Security Method from Password to No Security
6) enter password in box provided
7) save file
8) move onto the next file
With this, I can automate the process of removing the password secuirty, then easily compile all data into a spreadsheet via the Acrobat internal process.
Any suggestions would be appreciated.
cheers
One hospital in Dar es Saleem decided to password protect a PDF Fillable Form I setup for them to use to collect data from paper form. Over 2,000 forms filled, each with the same password. Now I need to extract the data into a spreadsheet for converse to a new electronic database. But can't because of the password. The Adobe community has so far not responded to request for options. Since I am much more familiar with Excel, VBA and using VB from within a macro, I want to see if it is possible to use VBA to:
1) open a PDF Form file from the C-drive
2) select File tab
3) select Properties tab
4) select Security tab
5) change Security Method from Password to No Security
6) enter password in box provided
7) save file
8) move onto the next file
With this, I can automate the process of removing the password secuirty, then easily compile all data into a spreadsheet via the Acrobat internal process.
Any suggestions would be appreciated.
cheers
