I see a couple of possibilities but they are not for the faint of heart.

Depending on the program you are trying to create an interface too there may
be API's that allow your program to directly access the processes of the
other. You would need to know a LOT about the other program to make that work
and get a list of the API declarations from the other program.

The other program is probably writing your records to a database. You may be
able to writh those records yourself directly to the database but that is
going to be a tough one to make happen if it is even possible.

Best chances are if your other program has the ability to import a CSV file
you cna create that CSV via code then in the other program is it a simple
import which you would have to do manually.
--
HTH...

Jim Thomlinson


"BL" wrote:

Dear all,

I need to copy an Excel spreadsheet data about 50 rows and 6 columns to an
non-office program which is in some type of form. Right now, we are use a
small Macro program to remember the keystroke to copy the data, flip between
the programs and paste the data.

I am wondering whether I can do that through VBA. Can I store all the data
in an array and switch to the program and copy the information? How can I
call the other application and continue the VBA?

Thank you.

Regards,

BL