7 Replies Latest reply on Jul 31, 2009 10:59 AM by Dennis

    Save to Excel - Use of variable path/filename

    Dennis

      Title

      Save to Excel - Use of variable path/filename

      Post

      I have an application where I need to Save to Excel using a variable path/filename. I build the path from Get(SystemPlatform), Get(DesktopPath) etc. and end up with:
       
      $ExportFileName =  filemac:/Macintosh HD/Users/dennisj/Desktop/Manifest-13925.xls

       

      If I set "Output File Path" to  $ExportFileName I get an Error 1 and the file is not saved.

       

      If I set "Output File Path" to  filemac:/Macintosh HD/Users/dennisj/Desktop/Manifest-13925.xls the file is saved to my desktop. 

       

      How do I get the variable to work in the Save to Excel script step.

       

      Dennis