AnsweredAssumed Answered

Scripting question - (import Excel files)

Question asked by lovelandj on Apr 21, 2016
Latest reply on Nov 1, 2016 by kupietz

Hello,

 

I have a folder on my desktop called files.  There are 30 excel spreadsheets in the folder.

I am trying to import each spreadsheet (some contain 4 workbooks and some contain 2).

 

I am going to make two scripts one for the spreadsheets that have 4 workbooks and one for the 2 workbook one. (Unless there is another way to do that?)

 

I have the following script for the 4 workbook one.

 

Go to Layout ["Written Data" (Written Data)]

Show all records

Import Records [ With dialog: On ;  Source: "2425 CC Vis Com.xlsx"; Worksheet: "Written Data" ; Add; Mac Roman ]

 

Go to Layout ["Written Norms Data" (Written Norms Data)]

Show all records

Import Records [ With dialog: On ;  Source: "2425 CC Vis Com.xlsx"; Worksheet: "Written Norms Data" ; Add; Mac Roman ]

 

Go to Layout ["Performance Data" (Performance Data)]

Show all records

Import Records [ With dialog: On ;  Source: "2425 CC Vis Com.xlsx"; Worksheet: "Performance Data" ; Add; Mac Roman ]

 

Go to Layout ["Performance Data" (Performance Norms Data)]

Show all records

Import Records [ With dialog: On ;  Source: "2425 CC Vis Com.xlsx"; Worksheet: "Performance Norms Data" ; Add; Mac Roman ]

 

My question(s) are;

 

1. Have the user tell Filemaker where the folder is that contains all the files?

2. Can I modify this script to run all files in the folder no mater what the name of the file is?

 

Thanks

Jeremy

Outcomes