FM - Is There a Way to Point to Which Excel tab you want to Import?

Is There a Way to Point to Which Excel tab you want to Import?  I don't see anywhere in the Filemaker import script step where you can select the tab.  I have way too many tabs I need to import and I'd rather not Save As a hundred times in order to have the correct tab be imported.  If not, what is the workaround?  Thank you.
LVL 2
rvfowler2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rvfowler2Author Commented:
I found that when I select a different file, it allows you to choose which tab, but the only way to choose a different tab is to select the file all over again.  Anything easier?
0
Will LovingPresidentCommented:
I don't know of a way to do it that is completely automatic. You can make the import dialog visible and then select each tab in succession but of course that leaves you open to errors….

360Works Scribe Plugin can read from and write to Excel, Word and PDFs, so it might be able help with an import from a selected Worksheet within an Excel Workbook, but I've not tried it to know.

http://www.360works.com/filemaker-pdf-plugin/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rvfowler2Author Commented:
Thanks, will look into 360Works scribe.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
FileMaker Pro

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.