How to run micro file for un formatted excel data

I have a un formatted excel data, so i have one macro excel(.xlsm) to format the data how can i solve this by using ui path.
tired excel application scope with execute macro but getting "macro are disabled which i made enabled in file options"

Thanks in advance

1 Like

Can you share the Sample Excel with Macro ?

New (24.7 KB)

Try above code its working. (22.8 KB)