I have an an import and export template that are utilized in an automation script. The imported files are located on my desktop and the exported files are exported to my desktop. It works fine. But when a coworker runs the automation script, the templates error out because the path to the desktop is different on his machine. Is there a way to use a relative path like you can in the windows explorer (C:\Users%username%\Desktop)?
I am afraid not. You can, however, use a shared drive that you both have access to as a location to get and save files to.
Shared drive would be the best approach. Even if you could get the %username% value stored into a variable so you could use it in the dynamic path, you would still need to copy the input files from your computer to his.