Microsoft Office Forums - View Single Post - Subscript out of Range Error when searched for string and its line number in Text File

Thread: Subscript out of Range Error when searched for string and its line number in Text File

View Single Post

Old

01-11-2021, 05:32 AM

gmayor

gmayor is offline

gmayor uses Windows 10

Windows 10 gmayor uses Office 2016

gmayor uses Office 2016

Office 2016

Expert

Join Date: Aug 2014

Posts: 4,103

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

Your code works here, assuming that the text file in question is compatible with the search pattern e.g.

Name "John Smith"
Age "27"
Date of Birth "12/12/1993"

would show you 12/12/1993 in the message box.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote