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?