Hi all,
having a local xlsx with 20mb worth of data (~400k x 20), what's the fastest way to get it in a master-workbook? The current time it takes to open-copy-and close the workbook lies in the ~12sec
Simple Copy-Paste seems like it might be slow. Reading to an array seems faster. I was wondering if there's yet another performance increase to be found - seems to me as if the longest time is spent by opening the file itself. Does anyone perhaps have some experience in reading a files contents without even opening it? Some ADODB perhaps?
Thanks and best
Bishonen
Bookmarks