(Solved) – Having a dynamic output file for ExportWithFormatting macro action [duplicate]

(solved)-–-having-a-dynamic-output-file-for-exportwithformatting-macro-action-[duplicate]

This question already has an answer here:

I use a techonology called BOX for saving data. In Box, the address path of a file will be different for every user. For example,

If a user is called “John Test”, the data path will be “C:UsersJtestBoxnew folder”
If a user is called “Sara Exam”, the data path will be “C:UsersSexamBoxnew folder”

My question is how I get a dynamic address for generating a PDF output file in access? Please see the image I uploaded.

output file for ExportWithFormatting macro action

I tried to build up a function, but it did not work.

Leave a Reply

Your email address will not be published. Required fields are marked *