find and replace a number that's always in a table and always adjacent to a cell with known text

		Microsoft Office Forums > Microsoft Word > Word VBA
find and replace a number that's always in a table and always adjacent to a cell with known text

01-16-2021, 03:35 AM

macropod

Windows 10 find and replace a number that's always in a table and always adjacent to a cell with known text

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,467

Simply change:

Code:

    .Close SaveChanges:=True

to:

Code:

    .SaveAs FileName:=Split(.FullName, ".doc")(0) & ".pdf", FileFormat:=wdFormatPDF, AddToRecentFiles:=False
    .Close SaveChanges:=False

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

Tags

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Find and Replace rows in a table based on bold text.	OfficeAssociate99	Word VBA	2	07-26-2017 06:32 AM
Select Cell Text to paste into Find/Replace	CBarry	Word VBA	2	02-16-2017 04:37 AM
Increase number in cell, based on value in adjacent cell	scottyb	Excel	3	02-02-2017 03:51 AM
VBA Table – Search All Tables - Find & Replace Text in Table Cell With Specific Background Color	jc491	Word VBA	8	09-30-2015 06:10 AM
Word VBA Find Table Text Shading Colour and replace with another	QA_Compliance_Advisor	Word VBA	10	09-19-2014 08:36 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:32 AM.