AnsweredAssumed Answered

Specifying excel worksheet when importing

Question asked by marcholt on Dec 7, 2009
Latest reply on Jul 8, 2016 by ClaudeChamberland

Title

Specifying excel worksheet when importing

Post

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:    

 

 

 

Static Filepath

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Variable Filepath

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

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?

 

Thank you in advance!

Outcomes