How to get data on screen.

[BlitzMX]

Hello

I have this VB 6 application with about 400 records, it takes forever to extract to an excell sheet.
Is ther an easy way to get everything into a string or directly into excell? (Maybe clipboard and then Past it.)
I have Visual Basic Express installed.


Thank you

 

[JohnH]

With Excel automation it is a lot faster to get/set a range using an array than cell by cell: How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays
It may be possible for you to export to Excel using OleDB too, research it.

 

[BlitzMX]

With Excel automation it is a lot faster to get/set a range using an array than cell by cell: How to automate Excel from Visual Basic .NET to fill or to obtain data in a range by using arrays
It may be possible for you to export to Excel using OleDB too, research it.

I cannot do that, this VB app is not mine. It belongs to the company i need a way to extract it the way it is presented.
Kinda "Select all" from all this textboxes, How do i do that?