Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Limitations in UDF:s
Hi there!
I have user defined functions for accessing data from a db. I have a update button instead of getting the data directly from the UDF for some reasons. I want to store the data in a recordset and then use the filter property to get the correct data for each cell. Now the limitations of the UDF (cannot change the excel environment) also seems to be valid to recordsets in VBA. I can not use filter property or find method, but MoveNext seems to work. I guess it is because filter property change the recordset whereas MoveNext does not. But why are there limitations at all on recordsets?I can't see a recordset interacting directly with the sheet, disturbing calculations and dependencies? By the way, does anyone know a book or site about programming add-ins with user defined functions and data access? I found a great deal from here, but I am always eager to learn more. Thanks in advance Clarkie |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel limitations | Excel Discussion (Misc queries) | |||
Macro limitations | Excel Discussion (Misc queries) | |||
Tab Name Limitations | Excel Discussion (Misc queries) | |||
Limitations in MS Query? | Excel Discussion (Misc queries) | |||
VLOOKUP Limitations | Excel Worksheet Functions |