2 Replies Latest reply on May 11, 2017 12:47 PM by philmodjunk

    Import an excel file with multiple worksheets

    dougw

      I know this was ask before but not recently so I'm wondering if anyone has developed a solution since.

       

      I'm using FM Advanced 15 on a Windows 7 computer.

      I need to import an excel document with the potential for 30 or more worksheets.

      Each worksheet has the exact same layout.

      I will be getting these documents on a regular basis

       

      I've created a simple script to import the excel spread sheet (with dialog on), starting at worksheet 1 within a loop and manually select the next worksheet each time the script loops around. 

      It does work this way but it's tedious and mind numbing with the potential for importing the same worksheet twice or missing one altogether.

       

      I'm just looking for a way to automate the entire process so that each worksheet is imported in the sequence they are in the excel document.

       

      thanks

      Doug