Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sending more than one char to one excel sheet

Hi Everybody

I need to send chars to excel sheet, this chars (mora than one) must be on the same excel sheet, I try ussing a Macro

Sub ExportaConsolidado

set obj1 = ActiveDocument.GetSheetObject("CH13")

obj1.SendtoExcel

set ob2 = ActiveDocument.GetSheetObject("CH12")

obj2.SendtoExcel

End

this works, but, at this point, two excel sheets was create, one for every char (2), so, I need that only one excel sheet contain CH13 and CH12.

Thank you in advance.

2 Replies
hectorgarcia
Partner - Creator III
Partner - Creator III

try using this one I found in other forum, it works great!!!!

Hector

Not applicable
Author

thank you Hector!

I will try whit this.