Hi: So, how do you know what FILE.HTML to open? Do you pick the one with the most newest date? or the oldest date? or some other criteria, like the word "final" in the name? If you have some logic that you use to manually pick the name, another approach would be to read the folder where the HTML file is stored and pipe the directory output from the folder to a file that you can read with SAS. Assuming the HTML file you want to read is the one with the most recent date, you should be able to use Program logic to get that name and create a macro variable from that name. I believe there have been several examples of getting the names of all the files in a folder already posted in the Forums. But even simpler would be to ask your colleagues to create the file with a unique name -- something like: file_15APR2022.html -- I realize that naming convention would only work if you are running your program on the same date that they are creating the HTML file, but there are other ways to manipulate dates with macro variables that might work. You have such an open-ended question, we really need some more context around how you decide to pick THAT HTML file out of the folder that contains multiple HTML files. Cynthia
... View more