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

mbcohn · #1 04-01-2021, 01:04 PM

And now I'm getting a run-time error. I'm not sure why. I can't figure out what about the situation has changed. I went back through the thread and re-pasted every bit of code and every change to be sure, and I also moved the files from one location to another. I've also tried restarting Word, and my computer.

The error says: "Run-time error '5174': Sorry, we couldn't find your file. Was it moved, renamed, or deleted?"

The line of code that this error happens on is:

Code:

 Set wdDoc = Documents.Open(FileName:=strFolder & "" & strFile, AddToRecentFiles:=False, Visible:=False)

I feel like this must be something happening on my end outside the program, but I can't imagine what it could be.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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