AnsweredAssumed Answered

Script to import designated worksheet of Excel file

Question asked by ReuvenHoch on Dec 1, 2011
Latest reply on Dec 12, 2011 by StephenWonfor

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.

Outcomes