After further research, i realized it can in fact be done without using
'VBIDE' & 'VBProject.VBComponents'.

The built in excel VBA command is 'Application.RecordMacro([code to
record])'.

See Excel VBA help for 'Application.RecordMacro' for more info.
thankyou to me!