3 Replies Latest reply: Feb 11, 2013 4:04 AM by alberdeere RSS

    Scripting wildcard so i can insert multiple files within a folder?

      I have a folder that has data labeled by years. The data has the same tab names and collumn labels. I want to be able to insert all of these excel files into QliView on one script. Isnt there a way to select the file path to the folder where the files are located and then evnter a common word in the files name of the files i want to insert and then add a wild card to get all the files with that word in the title? If so, how can i do that? what is that wildcard? Example(

      Product - Process Archive FY'09-FY'10.xls

       

      can i just delete back to (Product) and then add an (*)

       

      Product* does anyone have an example of creating a script for this?

       

      Thanks!