simple import script to read specific Excel cells
To work around the limitation that standard Excel import is row by row, I would like to create a short script that reads Excel cells that are in the same column into different fields in an FM table. How would one set up a simple Filemaker script that import specific Excel cells?
The script would:
- open a file, e.g. ~/Desktop/import.xls
- import B1, B2, B3 into an FM table
I have searched the forum for 20 minutes and found lots of discussion on scripts but very few actual scripts.