AnsweredAssumed Answered

Script to import specific excel worksheet

Question asked by jayyo on Aug 10, 2016
Latest reply on Aug 11, 2016 by philmodjunk



I have an excel workbook that has two worksheets: Survey and Import. The Import worksheet simply takes all of the fields from the survey and puts them into columns for a straight import into FM via a script I wrote that works well, but it asks for which sheet I want to use for import every time. I'm wondering if there's a line I can write in the script that will specify which worksheet I want to import by the text "Import" since that's the name of the sheet. Thanks!