Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (1)
2 Replies

Re: Where can I get Macro Script to format and excel export

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

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

- Marcus

Not applicable

Re: Where can I get Macro Script to format and excel export

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!

Community Browser