Hello
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) 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
xlApp.Activesheet.PasteSpecial (Format:="HTML" , NoHTMLFormatting:= true )
but gives an error "Expected ')'". I'm not used with VB. Any Idea?
Thanks in advance
Pablo