I want to automatically copy paste individual cells one at a time into
another program, as I cannot block paste columns from one program to the
other.

Is there any way I can configure a macro to operate outside Excel, copy a
cell, paste into a second program's spreadsheet and repeat this operation for
a column of figures?