Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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.