Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Where can I get Macro Script to format and excel export

I have been creating a macro script to export to Excel however am battling to format the excel file in the Macro script.

SOme of the things I want to be able to do are:

Centre Align

Create borders

fill cells with colour

Insert a logo

etc

2 Replies
marcus_sommer

The best way is google and you find sites like this:

http://www.functionx.com/vbaexcel/cells/Lesson2.htm

- Marcus

Not applicable
Author

Thanks Marcus, that I will surely give a try.

Was googling myself comotose yesterday and couldn't find things like the link you sent me!