VBA Code

[ykbhatia]

This is required for a Word Document. I have a 500 pages word document. I want to run a VBA code to lookup a number on the page and add preceding numbers to it and convert it to a different font and paste it on that page.

Eg.

Page 1

Number: 123456

Need to lookup the number add 01000 to it i.e. 01000123456, change the font and past it on an area on the same page. This needs to be done to all the 500 pages of the document.

Can anyone provide a solution for this as I am not too familiar with VBA.

Thanks.

 

[Norie]

This is required for a Word Document.

So you posted it in an Access forum?.

Seriously though I would suggest you turn on the macro recorder (Tools>Macros>Record new macro...)
when you do this find/replace/format manually for a few pages.

That should generate code that can be adapted for all 500 pages.