select an MS Excel worksheet by name rather than by index

[lmd2]

Running LabVIEW 2010 on a Windows machine - I have code for working with Excel; saving a local copy of a workbook, and updating cells on a worksheet (see attached) - I don't remember, probably modified from some sample. Thing is this code accesses a worksheet by index, but my client is going to be adding sheets to the template, so the index may change. I am thinking that selecting a worksheet by name would be a more robust solution but I can't find a property for doing that.

anyone know if this is possible? maybe a sample someplace?

Thanks

lmd2

[smercurio_fc · Accepted solution]

Instead of passing in a number pass in a string to the To Variant function. That's it.

[lmd2]

excellent - thank you