AnsweredAssumed Answered

Importing hidden excel sheet into filemaker

Question asked by HashirRaja on Feb 2, 2015
Latest reply on Feb 2, 2015 by SteveMartino


Importing hidden excel sheet into filemaker


Hello guys! I'm new to filemaker pro. I created an excel file that has users fill out a form. Once they press the submit button, the form info is converted into a second sheet in the same workbook. It gets converted to a row format so it can be synced with filemaker. However, that second sheet is hidden from all users and requires user to enter a password. It's not a workbook password lock but a script that basically makes the sheet visible if the correct password is written. My client wants to make a script in filemaker that will import that info automatically. Is it possible to import a worksheet that is hidden in excel into filemaker?