Data from Macro to Report
I have a question regarding the use of macros. I run a macro whenever a user creates a new folder. This macro executes a report that sets the access for the user. However, I'm not sure how to pass the newly created folder to the report, so currently I set the rights for every folder owned by that user. Long, slow process.
Can anyone please suggest a way to pass the newly created folder from the macro to the report please?