July 4, 200718 yr i understood how to create a dynamic filepath by setting variables within a "esport to excel" script. it works fine. now i have another question: let's say, someone wants to export several found sets one after the other to excel without the second export overwriting the first. e.g. script is saving the file automatically onto the local desktop. the first file would have the name "file1.xls", the second exported file would get the name "file2.xls", the third "file3.xls" - safari does this when downloading several files with the same name.... thanks for all your help. hans
July 4, 200718 yr Multiple options: Could a timestamp be added to the file name? File_20070704-1318.xls In a network enviroment, create a table where each exported record is named with a unique file name. Use a global variable to increment the file names. The variable would reset every time the file is closed. Write the Windows/AppleScript to check if the file names already exists in the export location.
Create an account or sign in to comment