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

macro send to ecxel

Hello,
I want a macro that allows me to save the active list in an excel file or txt

for example a list contain the values ?? AB and C goal is to register A1 B1 C1 over AB and C.

thank you

I found the code:

Sub ttttt
Set xlApp = CreateObject ("Excel.Application")
Set XLDOC XLApp.Workbooks.Open = ("D: \ tt.xls)
'xlApp.Visible = True

'This Is The qvw tab
Set s = ActiveDocument.Sheets ("Copy of Main")
ActiveDocument.Sheets ("Copy of Main"). Activate
ActiveDocument.ClearCache
'ActiveDocument.GetApplication.WaitForIdle
'ActiveDocument.GetSheetObject ("LB07"). Restore
ActiveDocument.GetSheetObject ("LB07"). CopyTableToClipboard true

'This Is The sheet in Excel
Set xlSheet XLDOC.Worksheets = ("Sheet1")
XLSheet.Paste XLSheet.Range ("A2")



Set xlApp = Nothing
= Nothing Set XLDOC
= Nothing Set xlSheet


End Sub

I manage to register the list in Excel to read it all here but not the active list.
plus I can not excel opens (read only) is there not a way to close it.

Thank you

0 Replies