导出cdr文件中的文本到excel

Sub ExportTextToExcel()
    '获取当前打开的 CorelDRAW Document 对象
    Dim cdrDoc As Document
    Set cdrDoc = ActiveDocument

    '获取当前选定的文本对象集合
    Dim textSelection As ShapeRange
    Set textSelection = cdrDoc.Selection.Shapes.All

    '如果当前选定对象不是文本对象，则给出提示并退出子程序
'    If Not textSelection.Type = cdrTextShape Then
'        MsgBox "请先选择一个或多个文本对象。"
'        Exit Sub
'    End If

    '创建新 Excel 工作簿和工作表
    Dim excelApp As Object
    Dim excelWorkbook As Object
    Dim excelWorksheet As Object
    Set excelApp = CreateObject("Excel.Application")
    Set excelWorkbook = excelApp.Workbooks.Add
    Set excelWorksheet = excelWorkbook.Worksheets(1)

    '将选定文本复制到 Excel 工作表中
    For i = 1 To textSelection.Count
        excelWorksheet.Cells(i, 1).Value = textSelection(i).Text.Story.Text
    Next i

    '显示导出成功提示，并保存 Excel 工作簿并关闭应用程序
    MsgBox "文本已成功导出到 Excel 中。"
    excelWorkbook.SaveAs "E:\cdr\TextExport.xlsx", FileFormat:=51
    excelWorkbook.Close
    excelApp.Quit
End Sub