by Cristiano Couto. (6 Submissions)
Category: Microsoft Office Apps/VBA
Difficulty: Advanced
Date Added: Wed 3rd February 2021
Rating: (4 Votes)
Very fast code, with few lines, load entire worksheet into MSFlexgrid using arrays and Excel VBA. Also has a example about Commond Dialog API.
*** MSFlexgrid has some limitations over number of rows and cols (allocation memory), but you can load a huge worksheet into array (in a single line of code), in that case, the only limitation is your free RAM.
Download Excel TO Flexgrid (3 KB)