Entering a list of names by copy/paste

I have a list of names in Excel (First names held in column A, Surnames held in column B) and I want to copy them and paste straight into my application somehow and get it to assign the names to an array. I don't want to have to create and read text files and don't want to hard code the names into my program as they will differ.

It's also important to paste say, all 30 names in in one go, not one name at a time.

I'd appreciate any help.

You've to use COM (Active-X) automation for doing that. It isn't possibile directly with B+ . You could try to make an helper DLL in C++ .

Whats wrong with exporting to CSV and knocking up a quick loop to read from that into your arrays?

Leaves you able to just edit the .xls file then too if anything changes.