Good afternoon
A bit of a strange one on a process I'm currently changing.
Currently, the business emails payroll data to the payroll team in a variety of weird and wonderful formats for them to manually process.
I've streamlined the process by standardising the submission using VBA and automatically emailing this to payroll. All works fine.
I'm currently working on a Python script to pull all the attachments from these emails and save into a folder, with a script (VBA/ Python tbc) to then combine all the saved down submissions into one csv file to be bulk uploaded.
As it's payroll information, we wouldn't want the people who submit to have access to the "consolidation area" - but submitting through email and saving them all down into a folder seems a bit long winded. I'm wondering if anyone has any ideas of a better way to do this - ideally (?!) giving the macro access to save into a filepath but restricting it for the user?
Appreciate any feedback you have.
Thanks
Jon
A bit of a strange one on a process I'm currently changing.
Currently, the business emails payroll data to the payroll team in a variety of weird and wonderful formats for them to manually process.
I've streamlined the process by standardising the submission using VBA and automatically emailing this to payroll. All works fine.
I'm currently working on a Python script to pull all the attachments from these emails and save into a folder, with a script (VBA/ Python tbc) to then combine all the saved down submissions into one csv file to be bulk uploaded.
As it's payroll information, we wouldn't want the people who submit to have access to the "consolidation area" - but submitting through email and saving them all down into a folder seems a bit long winded. I'm wondering if anyone has any ideas of a better way to do this - ideally (?!) giving the macro access to save into a filepath but restricting it for the user?
Appreciate any feedback you have.
Thanks
Jon