I have a script that loops through records that contain the names of Excel files in a network directory, sets a variable equal to the complete file path and imports the Excel data into Filemaker. But I am unable to set the worksheet in Excel that I want imported. It defaults to the first worksheet in the Excel file. Filemaker apparently doesn't recognize the import file as Excel (because I am using a variable instead of pointing to an actual Excel file). When you point to an actual Excel file to import, Filemaker also allows you to speciy the worksheet to be imported. Does anyone know if there is a way to designate the worksheet when I name the variable that I use to direct the import?
Thanks for any help anyone might be able to offer.