Import excel with hidden worksheet dialog box
Hi, I am using fm pro adv 11.0v1.
I need to import an .xlsx file. User will select file and this file have multiple worksheet. I don't want user to select worksheet too. I can define .xlsx in variable, but how to define worksheet name in variable. File will have pre-defined worksheet name and it is hidden in xlsx file.
Under import script step, If I do have select file as selected, then of course I can pre-define worksheet name. But I need to give choice to user to select the file.
My all attempts failed to hide the "select worksheet" dialog box.
Any clue will be helpful. Thanks in advance.