Hi,
I have a big spreadsheet in Excel 2007 that contains 60,000 lines. I have named my range as "database". In another spreadsheet, I would like to build a macro that will import the range "database".
Does anyone know what is the faster way to process?
The current VBA procedure that I have is to simply open the file containing the range "database" and to copy/paste the information...
This takes a lot of time to process.
I have read online that we can get that done by refering to an ADODB connection?
Thank a lot!
I have a big spreadsheet in Excel 2007 that contains 60,000 lines. I have named my range as "database". In another spreadsheet, I would like to build a macro that will import the range "database".
Does anyone know what is the faster way to process?
The current VBA procedure that I have is to simply open the file containing the range "database" and to copy/paste the information...
This takes a lot of time to process.
I have read online that we can get that done by refering to an ADODB connection?
Thank a lot!
