Code:
Dim WkBkA As Excel.Workbook
Set xlApp = New Excel.Application
xlApp.Visible = False
Set WkBkA = Workbooks.Open("C:\Temp\" & " NIE & " Weekly Summary - " & Tod & ".html") 'develops the file name and location
WkBkA.Sheets(1).Rows(1).Delete 'Deletes first row
WkBkA.Sheets(1).Rows(1).Font.Bold = True 'Bold formatting
WkBkA.Sheets(1).Columns(3). 'Modify output column header to new string
WkBkA.SaveAs ("C:\Temp\" & NIE & " Weekly Summary - " & Tod), 51 'saves the new file
Excel.Application.Quit
I'm looking to modify the column name I've googled and such already but all I get is ranges in excel or the simple formatting changes like bold.
Thanks