Running a macro outside of Excel

[Zakynthos]

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?

[Rich_z]

Yes you can, although the language that you are using needs to be OLE enabled.

As an example here is a procedure that manipulates an Excel spreadsheet without the user even seeing Excel at all:

Please Login or Register  to view this content.

And so lower level code from one of the procedures:

Please Login or Register  to view this content.

What language are you trying to do this in ? I can perhaps give you some pointers.

Regards

Rich