Search results for query: *

a question at least. How can i start the query under a macro, my macro tells me he doesn`t know the VBA-macro?

Hey guys, IT WORKS, after I summate the values single day before the code starts. Then I just have per day one value and the ordering works now. Thank u for your Inputs. Data Inputs:

Hi I am on work today. @Combo: Thats what makes matter I think. The first Payment for XIRR must be negative, therefore the code doesn`t work with the automatic. But how comes the Code changes position of my table value?? I just use the pick up method from MajP as like: Do While Not rs.EOF...

Hi Combo, I don't know why, but it works with this date Format. I grap the immediate window for the variables which works: and i get the correctly result for controll2 = 0,0495...But that Payment Array Comes from stupid typing..In normal way, I will declare the Array as a variant, then it...

Hi, i am back from Tests. @Combo: I tried your way and sadly it doesn´t bring me to result. After that, I tried with manually Inputs and IT WORKS. Furthermore, I noticed it doesn`t make difference in Dates when I write it manually or from code. It is the Payments that makes error... But what...

Hi Guys, I build my macro according to the thread http://www.tek-tips.com/viewthread.cfm?qid=1740838 and don't get any results but Errors. I googled since 2 days for some Inputs. At least the Problem can come from some data Settings. I tried all the ways I know but it just didnt work... my...