Saveas XLSX

[nianchi111]

Hi All,

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 if I have a "," or" ." in the name it is not saving the file as Xlsx.

CRZYZ LGIST, S.A. DE C.V. this saves as CRZYZ LGIST, S.A. DE C.V. and file type as FILE.

Is there any solution, please help me.

Thanks,
Vimal Vikraman.

 

[Scott Huish]

Can you post your code?

 

[Logit]

.
Untested here but a viable resource :

https://superuser.com/questions/901...aracters-in-a-file-names-before-saving-in-vba