What is the easiest way to migrate VBA code to Calc

I’ve had a quick look at installing Python with a view to translating modules from Excel VBA, But it looks as though it might take forever and a day to unravel what I need to do to start learning Python. Is that really the best way to go?

If you already know Excel VBA, it should be easier to learn OO Basic and translate your VBA code to OO Basic.