AnsweredAssumed Answered

Import excel with hidden worksheet dialog box

Question asked by PreetHooda on Dec 29, 2010
Latest reply on Mar 3, 2012 by Vincent_L

Title

Import excel with hidden worksheet dialog box

Post

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.

Outcomes