主题：VBA的语句如何改成狐表的？

以下几句代码如何改成狐表的？

Dim excelApp As New MSExcel.Application
Dim excelRange As MSExcel.Range
Dim Wb As MSExcel.WorkBook=excelApp.WorkBooks.open("C:\test\1.xls")

 

Dim c As Range, a As Integer
For Each c In ActiveSheet.UsedRange
If c.MergeCells Then
a = UBound(Split(c.Value, Chr(10)))
If a >= 0 Then Rows(c.Row).RowHeight = 14.25 * (a + 1)
End If
Next

想实现的功能是自动调整“合并单元格“的行高。以上代码没有效果，不知是哪有问题，老师帮忙看看

行的高度未发生变化

红袍老师？帮忙看看

 

是的知道合并单单格麻烦，所以才用代码解决，这段代码已经在EXCEL的VBA中调试通过，不知道为舍放到狐表里没效果，不知道是不是UBound函数没发挥作用？

Sub aaa()
    Dim c As Range, a As Integer
    For Each c In ActiveSheet.UsedRange
        If c.MergeCells Then
            a = UBound(Split(c.Value, Chr(10)))
            If a >= 0 Then Rows(c.Row).RowHeight = 14.25 * (a + 1)
        End If
    Next
End Sub

好的，多谢大红袍，辛苦。

改造的代码如下，功能可以正常执行，但新建的sheet1没有被删除，是不是tempWs.Delete语句放的位置不对，请老师帮忙看看

Dim App As New MSExcel.Application
try
    For Each file As String In FileSys.GetFiles(path)
        If file.EndsWith(".xls") OrElse file.EndsWith(".xlsx") Then
            Dim Wb As MSExcel.WorkBook = App.WorkBooks.Open(file)
            Dim tempWs = wb.WorkSheets.Add
            For k As Integer = 1 To Wb.WorkSheets.Count
               
                Dim Ws As MSExcel.WorkSheet = Wb.WorkSheets(k)
                Dim rg As MSExcel.Range
                For Each rg In ws.UsedRange
                    If rg.MergeCells Then
                        Dim tempCell As MSExcel.Range
                        Dim width As Double = 0
                        Dim tempCol
                        For Each tempcol In rg.MergeArea.Columns
                            width = width + tempcol.ColumnWidth
                        Next
                        tempWs.Columns(1).WrapText = True
                        tempWs.Columns(1).ColumnWidth = width
                        tempWs.Columns(1).Font.Size = rg.Font.Size
                        tempWs.Cells(1, 1).Value = rg.Value
                        tempWs.Cells(1, 1).RowHeight = 0
                        tempWs.Cells(1, 1).EntireRow.Activate
                        tempWs.Cells(1, 1).EntireRow.AutoFit
                        If (rg.RowHeight < tempWs.Cells(1, 1).RowHeight) Then
                            Dim tempHeight As Double
                            Dim tempCount As Integer
                            tempHeight = tempWs.Cells(1, 1).RowHeight
                            tempCount = rg.MergeArea.Rows.Count
                            For Each addHeightRow As object In rg.MergeArea.Rows
                                If (addHeightRow.RowHeight < tempHeight / tempCount) Then
                                    addHeightRow.RowHeight = tempHeight / tempCount
                                End If
                                tempHeight = tempHeight - addHeightRow.RowHeight
                                tempCount = tempCount - 1
                            Next
                            rg.WrapText = True
                        End If
                    End If
                Next
                tempWs.Delete
            Next
           
            Wb.Save
            App.Quit()
            Dim txt1 As WinForm.TextBox = Forms("翻译器").Controls("TextBox3")
            txt1.text = file & vbcrlf & txt1.text & vbcrlf
            Application.DoEvents()
            FileCount=FileCount+1
           
        End If
    Next

 For k As Integer = 1 To Wb.WorkSheets.Count - 1
-1之后最后一个标签不能被执行代码

多谢，问题解决。