Specifying excel worksheet when importing

[MARC_PIF]

Specifying excel worksheet when importing

Hi All,

Is there a way to specify an excel worksheet when importing using script steps with no dialogue box shown and using a variable as a filename.

See below screen shots:

When you choose a static file another window appears prompting you to choose a worksheet, this doesn’t appear when using variables.

The excel file contains multiple worksheets and I need to be able to choose which one to use.

FileMaker Pro 9 Adv

FileMaker Server 9

Windows XP

Any idea’s?

[IdealData]

You need to switch off "Perform without dialog" for your Import Record script step.

I can't find a way to encode the worksheet names into the script step.