Search and replace a line of text in a CSV file

Hi, I was wondering how I would go about finding and replacing a line of text in a CSV file on a server.

Basically I have two variables in my Workbook:

1 – Unique Username
2 – Time

I would like to run a macro which prompts for the username to be entered and the new time.

Once this information is gathered, it can search the CSV file for the Unique Username and replace the line of text with the new information

The CSV file is formatted like this:

“Unique Username”,”Time”

Is there some VB code which could do this?

Thanks,
Tom

This could simply be done by importing your CSV into Excel

Then filtering for the required Name, amend the time or as many entries as you need.

Then convert back to a CSV

Store the file back to the server.

Easier and more versatile?