Using Visual Studio The 10 names on the txt file Robert Smith John Adams Charles

Question

Using Visual Studio

The 10 names on the txt file

Robert Smith
John Adams
Charles Xavier
Clark Kent
Eric Clapton
Pat Benetar
Abraham Lincoln
Paul Revere
Jimi Hendrix
Angelina Jolie

Description: For this lab, you will write a program that reads in a list of ten names from a data file (lab12data.txt). It will then ask the user for a name to search for, and inform the user if the name is on the list. It will then ask the user if they want to search for another name, and if so, repeat the process. Example C:Windows system32 cmd.exe hat name do you want to search for: Clark Kent The name Clark Kent was found on the list Do you want to search for another name/N>?Y What name do you want to search fo Bruce Wayne The name Bruce Wayne was not found on the list Do you want to search for another nane

Explanation / Answer

folder_location = Application.ActiveWorkbook.Path

i2 = 0

strFile = Dir(folder_location & "")

While strFile <> ""
If Right(strFile, 3) = "csv" Afterthat
file_to_analyse = Split(strFile, "@")
If Right(file_to_analyse(0), 8) = date_we_want_to_analyse_on Afterthat
found_files_to_analyse(i2) = strFile
i2 = i2 + 1
End If
End If
strFile = Dir
Wend

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.