How can I extract different tables in one excel sheet

[Anonymous]

I am working with data loaded onto qlikview, I have created multiple tables

How can i extract all these out in one click onto an excel sheet, can someone please help

[Anil_Babu_Samineni]

PFA

[Anonymous]

thank you that is correct, how can i do this on my sheet . what would i need to change .

do you have an email

[Anil_Babu_Samineni]

The only changes you need. Go to Ctrl + M and change Path your need.

Go to Setting -> Doc properties (Short cut {Ctrl + Alt + D}) - Security - "Macro Override Security" should be enabled.

[Anonymous]

thank you, how can I keep the module CTRL + M From loading after run.

Also how can I change the heading colors to cover all columns

Also how can I enable Wrap Text within this

Thank you

[Anil_Babu_Samineni]

Do you mean, You want to open Ctrl + M once Reload() got success?

I can work left of 2 parts in the evenings, As i don;t have Software in handy.

[Anonymous]

alright thank you

[tamilarasu]

Let us know if you have any issues.

[Anonymous]

Tamil babu  said he will answer the 2 parts which were to help me . that is why i said thank you

Also how can I change the heading colors to cover all columns

Also how can I enable Wrap Text within this

[Anil_Babu_Samineni]

As i promised, I disabled this? Looks like working

'sCaption=obj.GetCaption.Name.v 

'oSH.Range("A" & num_rows).Font.Bold = True

'oSH.Range("A" & num_rows+3).Value  = sCaption