Ñðåäà, 27 Ñåíòÿáðÿ 2017 ã. 14:15
+ â öèòàòíèê
Ãîñïîäà, çäðàâñòâóéòå.
Åñòü êîä âûáðîñà äàííûõ â âîðä ïî ïðèíöèïó íàõîæäåíèÿ êóñêà òåêñòà.
Êîãäà òî ÏÅÍÑÈÎÍÅÐÊÀ ïîìîãëà, çà ÷òî åùå ðàç åé ñïàñèáî.
Set App = CreateObject("Word.Application")
' app.Visible = True
App.Documents.Add OpenFiles
Set odoc = App.ActiveDocument
With App
' ïðèñâàèâàíèå çíà÷åíèé
j = 0
Do While j < i ' íàñòðîéêà ôîðìàòèðîâàíèå âûäåëÿåìîãî è ðåäàêòèðóåìîãî êóñêà
.Selection.Find.ClearFormatting
.Selection.Find.Replacement.ClearFormatting
With .Selection.Find.Replacement
.Font.Color = 0
End With
With .Selection.Find
' Debug.Print xm(j), ym(j)
.Text = xm(j)
If ym(j) = " - " Then
.Replacement.Text = " "
Else
.Replacement.Text = ym(j)
End If
.Wrap = 1
.Format = True
.MatchCase = False
.MatchWholeWord = False
.MatchWildcards = False
.MatchSoundsLike = False
.MatchAllWordForms = False
End With
' .Selection.Find.Execute Replace:=2 ñðàçó áûëî òàê
' If .Selection.Find.Execute() = True Then - âû÷èòàë íà ïðîñòîðàõ ïðî ïðîâåðêó ïåðåä çàìåíîé
' âûëåòàåò çäåñü
If .Selection.Find.Execute() = True Then .Selection.Find.Execute Replace:=2
' Replace=wdReplaceAll=2 - çàìåíÿòü âñå íàéäåííûå
j = j + 1
Loop
App.Selection.HomeKey Unit:=6
DoEvents
End With
Ðàáîòàëî íåñêîëüêî ëåò íà íåñêîëüêèõ êîìïüþòåðàõ(íî íå ìíîãî)
ñòàëî ÈÍÎÃÄÀ áèòü îøèáêó â
.Selection.Find.Execute Replace:=2
ïîðûëñÿ íà ïðîñòîðàõ, âû÷èòàë ïðî ïðîâåðêó íàéäåííîãî ïåðåä çàìåíîé è ïåðåïèñàë
If .Selection.Find.Execute() = True Then .Selection.Find.Execute Replace:=2
íî ïðîáëåìó íå ðåøèë
îøèáêà
5833
An error occurred while saving undo information
 àíãë íå ñèëåí, ñ òðàíñëåéòîì - Îøèáêà ïðè ñîõðàíåíèè îòìåíèòü èíôîðìàöèþ
Êòî íèáóäü ñìîæåò ïîäñêàçàòü, ÷òî íå òàê?
http://www.sql.ru/forum/1272673/eksport-v-word
-
Çàïèñü ïîíðàâèëàñü
-
0
Ïðîöèòèðîâàëè
-
0
Ñîõðàíèëè
-