Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading Excel Table in VBA
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reading SQL Table into Excel and calculating/inserting group line (with VBA)? | Excel Discussion (Misc queries) | |||
Reading SQL Table into Excel and calculating/inserting group line (with VBA)? | Excel Programming | |||
Reading formatting from Word table in C# | Excel Programming | |||
Excel 2000 reading the group names from a pivot table | Excel Programming | |||
Reading PivotCache for Pivot Table | Excel Programming |