Convert the extension of excel in to macro enabled files

[srikaran1289]

we had files in folder and need to convert the extension of only excel files in to macro enabled files is that achievable ?

[sandyarpa767]

Hi @srikaran1289 ,

Use for each file in folder and use property ony extension of files u require so that u will avois reading files of diff extensions and follow the below approach

Convert .xls to .xlsm

Hello everybody, I have problem for convert .xls to .xlsm. I use activities “move file” for rename extension but my outputfile have a problem of format, cant’ open … Have you ever had this problem ?

Regards
Sandy

[vrdabberu (Varunraj Dabberu)]

Hi @srikaran1289

Check the below thread

Convert .xls to .xlsm

@mateo.drouillard You can use Excel Application scope Read Range activity which sheet you need to write to another sheet Now use Write Range activity and give the file name as path.xlsm If the xlsm file is available in the path then it will write into that file, else it will create a new file Hope this may help you Thanks

Place this flow inside For Each File in Folder and follow the above thread process.

Regards

[srikaran1289]

Will it also work on .xlsx too ??

[sandyarpa767]

Please give it a try @srikaran1289 it should work if any challenges let us know

[srikaran1289]

itt works for .xlsx extension also @sandyarpa767

[sandyarpa767]

glad it worked @srikaran1289 , Please close the loop by marking as solution if approach works for u