ActiveX renaming worksheet name in Excel

[Elsa Fung]

Hi! I'm trying to use ActiveX to add a sheet to existing Excel file.  There is an ActiveX Add function for sheets, but it doesn't give me a chance to name the new sheet.  Does anyone know how to rename a sheet in Excel with ActiveX? or Add a new sheet with specific name in Excel with ActiveX?

Thanks in advance!!

[K C]

Hi Elsa,

With attached VI you can add a sheet with the name from the name control. Hope this helps.

[Elsa Fung]

Thanks! that's exactly what I wanted!!