Grant file access to macro but not to user profile?

jon1315

Board Regular
Joined
Jun 16, 2020
Messages
53
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

GWteB

Well-known Member
Joined
Sep 10, 2010
Messages
2,582
Office Version
  1. 2013
Platform
  1. Windows
Each user has certain read and write permissions on the disks of the local client and/or network environment. These access rights continue in all applications that a user has at his disposal, including VBA.
I would inquire with your IT department about the possibilities to introduce a new (fictional) user who has sole access to that specific disk folder, your "consolidation area".
Of course you (and a small select group of colleagues) can log in as that user and the VBA/Python can do its job under the same account. In this way, the data cannot be viewed by everyone.
 
Learn Excel from Bill Jelen

Understanding data is crucial, and the easiest place to start is with Microsoft Excel.

Forum statistics

Threads
1,151,491
Messages
5,764,681
Members
425,229
Latest member
Rashid mahmood

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top