I have a macro where it needs to saveas the file as Xlsx and its works fine, however in few names i have issue.
I have the file names in column A and this would be used as file name while saving.
for example :
UVVSA SA DW CV this saves as UVVSA SA DW CV.xlsx
But the issues is that...