@wooowwooty
Welcome to Uipath Community
First of all save the macro code in a .txt file manually
then
Use open excel application scope and give the specific filepath
then use invoke VBA activity inside it
Provide the .txt script file path
run the macro
Attached SC for your reference
