Send entire row to text file on condition of cell value being Y

This code was used on a project recently to allow data from a worksheet to be output to a csv file with the name Output_ and todays date without the ‘\’s. The code is a good example of taking the data if the value in column AS is ‘Y’ or ‘y’. It also adds the current date to the same row in column AQ to show the most recent update.

This code example can actually be shortened to use a loop to run through and grab the values from the row and put them in the text file. I will add this solution or provide on request, but for now this code is how the client ordered/requested it so that changes could be made if necessary.

Feel free to use or adapt the code for your own use or contact us for further assistance.