![]() |
|
#1
|
|||
|
|||
![]()
Hello all members. I need some help/or ready solution for my problem.
There is ms word document with somethin' data. I need clean all data from document and paste my text or data in that doc with vba macros. I alredy have some solution but workn't with big document(50-60 pages) and not delete any data exclude text : Code:
Sub CleanData() Dim curCharIndex As Integer Dim charCount As Integer curCharIndex = 1 charCount = ActiveDocument.Characters.Count While curCharIndex <= charCount ActiveDocument.Characters(curCharIndex).Select If Selection.Type = wdSelectionNormal Then Selection.Delete charCount = charCount - 1 Else 'Skip it curCharIndex = curCharIndex + 1 End If Wend End Sub Maybe there is any way emulate marking all text(Ctrl+A) and delete that text(by DEL button) from word document not so dirty like my solution. I'm sorry for my poor english. Thanx, with best regards, egyp7 ![]() |
#2
|
||||
|
||||
![]()
Why are you bothering with this? Surely you could just create a new, empty document?! Still, if that's what you want, try:
Code:
Sub CleanData() ActiveDocument.Content.Delete End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
thank for answer macropod, i already find way clean document data and paste my content. my solution look like :
Code:
Sub doc_clean_paste() Word.ActiveDocument.Range.Select Selection.WholeStory Selection.Delete Unit:=wdCharacter, Count:=1 Dim doc As Word.Document Set doc = ThisDocument doc.Range.InsertParagraphAfter doc.Range.InsertAfter "Text Added at " & Time End Sub |
#4
|
|||
|
|||
![]()
This does the exact same thing.
Code:
Sub SameThing() With ActiveDocument .Content.Delete .Range.InsertAfter vbCrLf & "Text Added at " & Time End With End Sub These two instruction do the same thing. Word.ActiveDocument.Range.Select Selection.WholeStory You take seven lines to do what can be done in two. |
#5
|
||||
|
||||
![]()
Or even one:
Code:
Sub SameThing() ActiveDocument.Range.Text = vbCrLf & "Text Added at " & Time End Sub
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
VBLearner | Word VBA | 1 | 03-09-2014 08:42 PM |
importing Access data to a Word document | WayneCusack | Word VBA | 2 | 12-24-2012 12:26 AM |
![]() |
cory_0101 | Office | 1 | 09-27-2012 07:15 PM |
![]() |
provlima | Word | 2 | 05-25-2012 01:12 PM |
![]() |
Charles Kenyon | Word VBA | 2 | 05-17-2012 11:18 AM |