![]() |
|
#1
|
|||
|
|||
|
Hi All,
I'm new into macro thing. Currently given a task to convert over 50000 data from notepad to be copy to word and run a given macro. Appearently there still need of human intervention which I believe can be improve on the macro end.. Attach below is the macro provided to me. I'll humbly delighted if the macro can be shorten from its original.thanks in advance. Cheers!! Kilosub Sub Macro1() ' ' Macro1 Macro ' Selection.EndKey Unit:=wdLine, Extend:=wdExtend Selection.Delete Unit:=wdCharacter, Count:=1 Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=5 Selection.TypeParagraph Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=4 Selection.TypeParagraph Selection.EndKey Unit:=wdLine, Extend:=wdExtend Selection.Font.Bold = wdToggle Selection.HomeKey Unit:=wdLine Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph ActiveWindow.ActivePane.SmallScroll Down:=14 Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=2 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=5 Selection.TypeParagraph Selection.MoveRight Unit:=wdCharacter, Count:=18 Selection.EndKey Unit:=wdLine Selection.MoveLeft Unit:=wdCharacter, Count:=13, Extend:=wdExtend Selection.Font.Bold = wdToggle Selection.HomeKey Unit:=wdLine Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=5 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=4 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.Font.Size = 7 Selection.MoveUp Unit:=wdLine, Count:=1 Selection.Font.Size = 7 Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveUp Unit:=wdLine, Count:=1 Selection.Font.Size = 7 Selection.MoveDown Unit:=wdLine, Count:=2 Selection.TypeParagraph Selection.TypeParagraph ActiveWindow.ActivePane.SmallScroll Down:=5 Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 Selection.TypeParagraph Selection.MoveDown Unit:=wdLine, Count:=1 End Sub |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Looping Question | Steve B | PowerPoint | 0 | 01-19-2011 10:44 AM |
| Looping video | tomasball | PowerPoint | 0 | 10-30-2010 02:38 PM |
| Unbreakable looping | Dixon | Outlook | 0 | 09-23-2009 02:10 PM |
How to Advance from Looping SWF Animation?
|
BSquared18 | PowerPoint | 1 | 07-04-2009 01:56 PM |
| Looping though Custom Properties in VBA | suekay | Misc | 0 | 05-19-2006 06:10 AM |