Moderatori: Anthony47, Flash30005
Sub WordSummary()
Dim TabNum As Long, I As Long, CLine As Long, NxLine As Long, myDoc As Document
Dim dRan As Range, TData, TRData, NrRows As Long, NrCols As Long, IStyle
Dim XlApp, XlWb
Set myDoc = ActiveDocument
TabNum = myDoc.Tables.Count
Set XlApp = CreateObject("excel.application")
XlApp.Visible = True
Set XlWb = XlApp.Workbooks.Add 'Open("C:\Users\Utente1\Documents\VALLE_PROT.xlsx") '<<< Il vero percorso del file XL
For I = 1 To TabNum
With myDoc.Tables(I)
Set dRan = .ConvertToText(Separator:=vbTab, _
NestedTables:=False)
TData = dRan.Text
'Restore:
myDoc.Undo
'Cerca ultima riga & ultima cella:
TData = Mid(TData, 1, Len(TData) - 1)
RData = Split(TData, vbCr)
NrRows = UBound(RData, 1) 'UBOUND delle righe
TRData = Split(RData(NrRows), vbTab, , vbBinaryCompare)
NrCols = UBound(TRData)
If NrCols > 0 Then
' crow = Selection.Information(wdFirstCharacterLineNumber)
Selection.MoveDown Unit:=wdLine, Count:=1, Extend:=wdMove
IStyle = Selection.Style
Do
Selection.MoveDown Unit:=wdParagraph, Count:=1, Extend:=wdExtend
If Len(Selection.Text) > 5 Then Exit Do
Loop
mytag = TRData(NrCols)
mytext = TRData(NrCols - 1)
mylev = Len(mytag) - Len(Replace(mytag, ".", "", , , vbBinaryCompare))
mynext = NextR(XlWb.sheets(1), 6)
XlWb.sheets(1).Cells(mynext, 2 + 2 * mylev).Value = mytag & Chr(10) & Chr(10) & Selection.Text
XlWb.sheets(1).Cells(mynext, 1 + 2 * mylev).Value = mytext
End If
End With
Next I
'
Set XlApp = Nothing
MsgBox ("Completato..." & vbCrLf & "Formattare il file Excel e salvarlo")
End Sub
Function NextR(xxSh, xxCol) As Long
Dim myN As Long
On Error Resume Next
myN = xxSh.Cells(10000, xxCol).End(-4162).Row
On Error GoTo 0
NextR = myN + 1
End Function
Torna a Applicazioni Office Windows
Inserire add.in nella barra di avvio veloce in excel 2003 Autore: Ricky0185 |
Forum: Applicazioni Office Windows Risposte: 4 |
Excel: problema con date se devo unirle a testi Autore: valle1975 |
Forum: Applicazioni Office Windows Risposte: 5 |
sal vare doc in word in PDF editabile Autore: danibi60 |
Forum: Applicazioni Office Windows Risposte: 2 |
confrontare e evidenziare 2 fogli excel Autore: niccia |
Forum: Applicazioni Office Windows Risposte: 7 |
Visitano il forum: Nessuno e 23 ospiti