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.
I've the exact same problem ! We need a way to specify with a variable the worksheet name