I have a bot that takes an excel file and makes it an access database. There are list of filenames of files that need to be moved. i have a column that says file name and it will say filename, however i don’t have the full name of the file as each day there will be a date added to the file. example it will say filename “date” or filename_”date”.
how do i get the bot so see the filename variable matches the filename in the table?
