Just like the title says, I'm trying to create relative paths to an Illustrator file and Excel file in my template file. I'm using data merge to create a bunch of files from the template and when I the individual InDesign files, I run a script that places each of the new documents into a folder with the same name. I am then dropping the linked files into the new folders and kept the files the same name and kept the same file structure. So, if it were a relative path, it would update. But, it shows up as a missing link. After I make the files, I am running a script to open the files, update links, and export a PDF; so, manually updating the links kinda defeats the purpose.
If there's not a way to create a relative path, is there a script out there that will look for a file of the same file type and/or filename in the same folder as the document?
Thank you in advance!