topic Macro export excel PasteSpecial in QlikView https://community.qlik.com/t5/QlikView/Macro-export-excel-PasteSpecial/m-p/546408#M204109 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I'm trying to use a macro to export a table into an axcel template. If i use PasteSpecial respects the style (what i'm looking for)&nbsp; but transforms the numbers into text, and if i use only Paste did not respect the style in excel. I've tried to use this </P><P>xlApp.Activesheet.PasteSpecial (Format:="HTML" , NoHTMLFormatting:= true )</P><P>but gives an error "Expected ')'". I'm not used with VB. Any Idea?</P><P>Thanks in advance</P><P>Pablo</P></BODY></HTML> Fri, 20 Sep 2013 07:40:34 GMT 2013-09-20T07:40:34Z Macro export excel PasteSpecial https://community.qlik.com/t5/QlikView/Macro-export-excel-PasteSpecial/m-p/546408#M204109 <HTML><HEAD></HEAD><BODY><P>Hello</P><P>I'm trying to use a macro to export a table into an axcel template. If i use PasteSpecial respects the style (what i'm looking for)&nbsp; but transforms the numbers into text, and if i use only Paste did not respect the style in excel. I've tried to use this </P><P>xlApp.Activesheet.PasteSpecial (Format:="HTML" , NoHTMLFormatting:= true )</P><P>but gives an error "Expected ')'". I'm not used with VB. Any Idea?</P><P>Thanks in advance</P><P>Pablo</P></BODY></HTML> Fri, 20 Sep 2013 07:40:34 GMT https://community.qlik.com/t5/QlikView/Macro-export-excel-PasteSpecial/m-p/546408#M204109 2013-09-20T07:40:34Z