Batch processing of password-protected Excel files

Anonymous
2015-12-23T13:31:01+00:00

I have created a set of employee timesheets in a folder, each identified by the employees name and ID no, and protected by the employee's National Insurance No as a password. They will add their overtime and mileage claims to their spreadsheet and I will process all the files at the end of the month for payroll, adding all the records from each file to a MS Access database table.

The one issue that I have is that I don't know how to open the password protected files in VBA in order to process them. Is there anyone out there with any experience of a similar process?

Stuart

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Deleted

    This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

    Comments have been turned off. Learn more