Is there a way to interactively select a worksheet from an Excel workbook in Labview?

[flow]

All of the examples that I can find only allow you to select a sheet by knowing it's index number or the exact name of the sheet.  I haven't been able to query or otherwise find out what sheets are in the workbook to allow the operator select one.

[MikeS81]

Hi flow,

see this link please and change the "new ..." vi with the "open ..." vi which you will find two posts below them.
http://forums.ni.com/ni/board/message?board.id=BreakPoint&view=by_date_ascending&message.id=5589#M55...

Mike

[flow]

Thanks!  The bit of information that I needed was to iterate the sheets and get their names.  I have successfully integrated this into my program and am now able to select a particular sheet from an Excel file.  With any luck, I won't need any more help to finish this project.

[parthabe]

Hi Mike,

Can you please post the latest available link to the one you had mentioned?

When I tried to open it, it said that it had been deleted.

[Robbob]

Partha,

I tried tracking down the exact thread that Mike was linking, to no avail, but maybe this would help you out just as much:

http://forums.ni.com/ni/board/message?board.id=170&message.id=332297&requireLogin=False

Rob K

Message Edited by Rob_K on 09-15-2008 01:43 PM

[parthabe]

Thanks, Rob.