Convert table to Excel Worksheet

So this is easy to do with just copy and paste. But I want to do it in an automated way.

I have been running an experiment at work and have been logging and analyzing all the data with Igor, because it is just easier for me, but most people here can't handle anything other than Excel, so I need to convert most of the tabulated data into an excel workbook for others.

I can set up all the data on about 14 tables (that I generate with a function I've written). I'm wondering if there is any way to export a table as a worksheet in excel, and ideally pack a bunch of tables together as different worksheets all in the same workbook. But do this in an automated way.

I'm thinking this is too much to ask and I would probably need to do something with VBA tapping Igor occasionally (groan) which would probably take me forever to figure out.

Any ideas?

Thanks,
gh
gh-

It must have been you that I talked to on the telephone today. I pointed you at the Save command and the SaveTableCopy command. I think it should do what you need, but I would be interested in any updates on the project.

John Weeks
WaveMetrics, Inc.
support@wavemetrics.com
As John notes, the Save command can be made to save any collection of waves.

You are right, you could use VBA in Excel to pull the data from a running copy of Igor. You are also right that there is a learning curve involved. See "Igor Pro Folder\Miscellaneous\Windows Automation". Among other things, it includes some Visual Basic examples.