I have an Excel file with macros in order to print some variables of a selected file (some kind of history of checks and approvals of a file).
I'm using GetVersionVars in my Excel macro, which is working fine now.
However, in order to obtain the path of the 'selected' file, I'm using FileName = Application.GetOpenFilename("All Files (*.*),*.*") in my file script (VBA).
This only works when I have a file saved local. When a file is not saved local I recieve the error: "File not found", when selecting it.
Using 'Get latest version' solves the problem, but is not the most convenient way. Is there any other way to solve this?
I also made a print button on the datacard. Clicking it opens the Excel file. I guess my problem described above could be solved if I'm able
to send the filepath of the selected file on the vault (datacard) into my (template) Excel file. Is there an easy way to do this? I'm not so familiar with
the EPDM add-ins.
Thanks in advance.