| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Total Field Count
I have connected an excel workbook to an access database. Is there a
function in VBA that will return the total field count of an access table? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Total Field Count
Assume you use data=Get External Data (or Import External Data)
Assume table is returned starting in cell A1 of Sheet3 and there is no other data on the worksheet =CountA(Sheet3!1:1) will give the number of fields (columns) -- Regards, Tom Ogilvy "Markantesp" wrote in message ... I have connected an excel workbook to an access database. Is there a function in VBA that will return the total field count of an access table? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Calculated Field From a Running Total Field | Excel Worksheet Functions | |||
| how do I take a sub total field and calculate sales tax to it | New Users to Excel | |||
| calculate count on 2006 total, 2005 total, etc... | Excel Worksheet Functions | |||
| How do i count numbers and letters to find a total count of all | Excel Worksheet Functions | |||
| Total Field Always Visible | Excel Worksheet Functions | |||
Hybrid Mode
