Link to home
Create AccountLog in
Avatar of Svgmassive
Svgmassive

asked on

Rename Columns in a closed workbook

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

By "column names" do you just mean the value(s) in say row 1 of a worksheet, so just data on the sheet?  Or are these Data Tables that you have created in Excel?

Please upload a sample of the workbook involved.


»bp
ASKER CERTIFIED SOLUTION
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Svgmassive

ASKER

Sorry the values in the first cell in each column--header names