Devam Ediyor

Minijob Visual basic

Below find a simple VB macro in Word 2010 that searches for the string "btr" and replaces ALL with the string "butter".

I need a macro that reads a table (excel), looks up the string in column 1, cell1, and replaces it with the word in column 2, cell1. And so on.

Loop until the table is empty.

The purpose of this is of course to take a Word doc full of abbreviations and replace them all in one go. (Autocorrect doesn't work for me.)

Thanks!

Hevilba

Sub Makro1()

'

' Makro1 Makro

'

'

[url removed, login to view]

[url removed, login to view]

With [url removed, login to view]

.Text = "btr"

.[url removed, login to view] = "butter"

.Forward = True

.Wrap = wdFindContinue

.Format = False

.MatchCase = False

.MatchWholeWord = False

.MatchWildcards = False

.MatchSoundsLike = False

.MatchAllWordForms = False

End With

[url removed, login to view] Replace:=wdReplaceAll

End Sub

Beceriler: Visual Basic

Daha fazlasını görün: excel autocorrect, autocorrect excel, makro, excel visual basic, visual basic word replace, word macro basic, macro 2013 2010, 2013 excel visual basic, excel 2013 visual, excel 2013 macro, excel table 2010, visual basic word find, loop table, loop excel visual basic, visual basic 2013, visual basic excel 2013, replace excel macro, text table excel, excel 2013 visual basic, word macro find, word macro visual basic, macro word 2010, macro excel 2010, replace visual basic excel, 2010 word macro

İşveren Hakkında:
( 12 değerlendirme ) Germany

Proje NO: #4429406

Seçilen:

sumon355

Hello, I am very much interested to do this work. Thanks

1 gün içinde 40€ EUR
(4 Değerlendirme)
2.0

5 freelancer bu iş için ortalamada 80€ teklif veriyor

omaralieissa

Hi, i can make you a C# program which will make the same task and with nice GUI, thanks.

1 gün içinde 100€ EUR
(3 Değerlendirme)
2.6
seaanddream

Hi, your excel vba coding expert is ready to help you. regards.

in 2 gün içinde50€ EUR
(2 Değerlendirme)
1.6
himanshuapanchal

I can help in this. Please check my expertise

in 5 gün içinde150€ EUR
(0 Değerlendirme)
0.0
AAMSONS

Hi, VBA Expert here to help you on your office 2010 Macro problems... Lets start working on it right away. Thanks

in 3 gün içinde60€ EUR
(0 Değerlendirme)
0.0