Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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