Microsoft Office Forums - View Single Post - [Solved] find and replace a number that's always in a table and always adjacent to a cell with known text

Thread: [Solved] find and replace a number that's always in a table and always adjacent to a cell with known text

View Single Post

Old

04-01-2021, 02:53 PM

mbcohn

mbcohn is offline

mbcohn uses Windows 10

Windows 10 mbcohn uses Office 2016

mbcohn uses Office 2016

Office 2016

Advanced Beginner

The original poster

Join Date: Jan 2021

Posts: 32

mbcohn is on a distinguished road

Default

I made your correction to "Set wdoc" (adding the slash), but now I get "Runtime error 5, invalid procedure call or argument" on:

Code:

  FileName = Mid(myPath, InStrRev(myPath, "") + 1, _
   InStrRev(myPath, ".") - InStrRev(myPath, "") - 1)

Reply With Quote