I am trying to loop through a directory and load all the files within it. Its a simply bit of code, however if one of the filenames contain brackets (), the load will fail. Is there anyway to stop this happening, either by escaping certain characters or changing the load method?
for each FoundFile in filelist ('lib://Filelocation\*.xlsx')
(ooxml, embedded labels, table is Sheet1);