November 6, 200817 yr Hi, I have a requirement to import data from a variable number of spreadsheets which follow a naming convention but the number of files vary from project to project. i.e. In one project there may be 6 files from one section of samples: BP1-TP1 to BP1-TP6, followed by five samples in the next set BP2-TP1 to BP2-TP5 and further ones from different borrow pits. Is there a way to automate the import for however many files there may be.
November 6, 200817 yr Yes by use of a plugin that would get you a list of items in the folder then you can loop thru each file, exiting when you process the last file. http://www.fmpug.com/resourcedirectory_plugin_list.php?find=File%20Manipulation (FMPug members receive a discount)
Create an account or sign in to comment