AnsweredAssumed Answered

Send the filepath of a selected file to an Excel file

Question asked by Amai Zeg on Oct 9, 2013
Latest reply on Nov 1, 2013 by Amai Zeg

Hello,

 

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.

Outcomes