<div>
If you want to run a macro in Excel, save a macro of this...<br />

<pre><code id="code-20-41693166-1">Sub SheetNames()
    Columns(1).Insert
    For i = 1 To Sheets.Count
        Cells(i, 1) = Sheets(i).Name
    Next i
End Sub</code></pre>
</div>


If you want to run a macro in Excel, save a macro of this...


Sub SheetNames()
    Columns(1).Insert
    For i = 1 To Sheets.Count
        Cells(i, 1) = Sheets(i).Name
    Next i
End Sub

<div>
This thread has a follow-up thread which includes an AHK script for obtaining a list of Sheet Tab names and therefore does not require vbs, etc.<br />
<br />
The follow-up thread is located here:<br />
<a href="https://www.experts-exchange.com/questions/28979485/Make-a-file-test-vbs-using-vbscript.html" rel="ugc">https://www.experts-exchange.com/questions/28979485/Make-a-file-test-vbs-using-vbscript.html</a>
</div>


This thread has a follow-up thread which includes an AHK script for obtaining a list of Sheet Tab names and therefore does not require vbs, etc.

The follow-up thread is located here:
https://www.experts-exchange.com/questions/28979485/Make-a-file-test-vbs-using-vbscript.html [https://www.experts-exchange.com/questions/28979485/Make-a-file-test-vbs-using-vbscript.html]

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
<b>Is there a way, in Excel (2010), to create a list of all sheet tab names in a given workbook?</b><br />
<br />
The list I've got in mind would be somewhat similar to the list which can be created with a DOS command of all filenames contained in a particular folder.<br />
<br />
Thanks
</div>
</div>


Hello,

Is there a way, in Excel (2010), to create a list of all sheet tab names in a given workbook?

The list I've got in mind would be somewhat similar to the list which can be created with a DOS command of all filenames contained in a particular folder.

Thanks

Create a list of all sheet tab names in a given Excel workbook

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.