How do I use active X with Excel to invoke the one sheet selection option?

[sfrosty]

I'd like to programatically set Excel Tools/Options/General/Sheets in new Workbook to 1 using active X. Thanks!

[Randy_H]

sfrosty,

The best place to search for this information is on MSDN (msdn.microsoft.com) since Excel is their product, including the ActiveX object. If someone else in this forum knows the answer, then please feel free to add it.

Randy Hoskin
Applications Engineer
National Instruments
http://www.ni.com/ask

[sfrosty]

Sorry, I obviously didn't state the question correctly. I need to do this using LabVIEW to set the 1 sheet parameter in Excel. Thanks!