I have some code that exports a database to an Excel file and I was wondering how I could go about formatting the excel file. I am looking to make the top row bold and filterable and then auto fitting the columns. I have tried looking for examples but I guess I'm looking in the wrong places.
Heres what I have for my export. Thanks!
Set db = Client.OpenDatabase(CYPYsmzn)
Set task = db.ExportDatabase
eqn = ""
task.PerformTask Client.WorkingDirectory() & "Exports.ILB\" & SheetYear & "-Expenditure Analytical.XLSX", "Comparative Summarization", "XLSX", 1, db.Count, eqn
Set db = Nothing
Set task = Nothing
Last seen: 3 hours 46 min ago
Joined: 07/29/2021 - 10:01