Hi I need some help, I recorded a Macro which imports an excel file using the XML Data import function in the data ribbon. the code is below, but the issue i am having is on the name of the file. I have bolded the area that changes daily. the file name changes everyday. is there anyway to...