How can I automate Ctrl+K hyperlinking of excel through Alteryx?

[Kartik21]

I have a excel task in which I have to do hyperlinking by using keys 'Ctrl+K' and I have to do it manually for more than 200 files which takes me 4 to 5 hours. How can I automate this by using Alteryx?

[Deano478]

@Kartik21 why not just use VBA in excel for this?

[Kartik21]

@Deano478 If you have a VBA code for this which is working, please share that with me. It will be really helpful.