ExcelBanter - Reading Excel Table in VBA

on 9/21/2011, Mike supposed :
Hi everyone,

1) Which is faster: VB.Net or VBA? I heard conflicting answers...
2) Using VBA, how an excel table with Name Box, e.g. "Prof", can be
read?

Thanks,
Mike

I expect they both read a table the same speed, depending on the
methodology used. I recommend you simply 'dump' the entire table
(range) into a variable of type 'Variant':

Example:
Dim vTableData As Variant
vTableData = ActiveSheet.Range("<TableDataAddressOrName")
'do stuff with the data...
'dump the data back into the worksheet
ActiveSheet.Range("<TableDataAddressOrName") = vTableData

However, VBA runs within Excel whereas VB.Net does not and so requires
'automating' an instance of Excel to use VB.Net. Also, you require a
licensed copy of the VB.Net programming language software. VBA comes
with MS Office as its built-in macro language and so is free.

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup! comp.lang.basic.visual.misc