LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default UDF in Excel 2007 for Filter or Query

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Query Wizard problem with Access 2007 extensions Showdad Excel Discussion (Misc queries) 0 December 4th 08 05:57 PM
DataFilterAuto Filter in excel 2007? TIJ New Users to Excel 2 November 13th 08 03:28 AM
Excel 2007 Auto Filter Filter Django Excel Discussion (Misc queries) 2 September 9th 08 10:52 PM
Excel 2007 / MS Query - editing existing query to another sheet Hotpepperz Excel Discussion (Misc queries) 0 June 13th 08 06:53 PM
Query from microsoft query- Excel 2007 טבלאות אקסל 2007 Excel Discussion (Misc queries) 0 December 24th 07 10:47 PM


All times are GMT +1. The time now is 07:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright 2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"