How to determine then name of the active sheet in Excel

Steve Johnson

Delphi Developer

Tue, 15 Jul 2003 05:49:16 GMT

How to determine then name of the active sheet in Excel

Hello

How is the name of the current sheet extracted.

Thanks
Steve

Team

Delphi Developer

Thu, 17 Jul 2003 05:11:40 GMT

<<Steve Johnson:
How is the name of the current sheet extracted.

This is how you could do it using the D5 components:

WS.ConnectTo(Excel.ActiveSheet as _Worksheet);
WS.Name := 'New name';

--
Deborah Pate (TeamB) http://delphi-jedi.org

Use Borland servers; TeamB don't see posts via ISPs
http://www.borland.com/newsgroups/genl_faqs.html