<div>
By &quot;column names&quot; do you just mean the value(s) in say row 1 of a worksheet, so just data on the sheet? &nbsp;Or are these Data Tables that you have created in Excel?<br />
<br />
Please upload a sample of the workbook involved.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Svgmassive

<div>
Sorry the values in the first cell in each column--header names
</div>


<div>
<div class="content wysiwyg-content">
I would like the most efficient way to rename column names in a closed workbook.I would like to use ado if possible.<br />
Thanks
</div>
</div>


I would like the most efficient way to rename column names in a closed workbook.I would like to use ado if possible.
Thanks

Rename Columns in a closed 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.