Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello, I'm new to programming in Excel but I have in VB.net. I was having
problems finding solutions in VBA and decided to try VSTO. Still lost... Here's the problem: I need to create a function (that can be added into a cell within the workbook on a seperate worksheet). Our company is currently working with a Program that uses an Excel workbook as it's data source and formulaes/functions. The Spreadsheet/Data table is already within the Excel workbook, what I need is to be able to query the data or filter using criteria(es) from another part of the workbook and then with the results of the array/filtered table get the MIN/MAX/AVG of one specific column (which is actually being called by the external Program, this is why I need a UDF). The query/criteria changes multiple times in multiple areas of the workbook which will then be exported by the external program. I'm becoming very familiar with vba and can't figure out to how program Excel in VB.net. HELP!!! Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 Query Wizard problem with Access 2007 extensions | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
Excel 2007 / MS Query - editing existing query to another sheet | Excel Discussion (Misc queries) | |||
Query from microsoft query- Excel 2007 | Excel Discussion (Misc queries) |