I'm brand new to Access so I may be doing this completely wrong, but I have a separate query object I wrote and I am trying to only include records based on the deals that were multiselected on the form
SELECT tblIRRCashflow.DealName, tblIRRCashflow.Payment, vtblIRRCashflow.IRRDate
FROM...
Oh for sure, I wasn't looking for support, rather just curious because somehow MajorP had magically appeared on each thread with questions about his tool, so I was wondering if there was some forum function that I was missing in my typical fashion.
I hope he's just taking a break from the forum...
The Access column type is Date/Time on Access 365, can I define beyond that? Maybe I will try changing the XIRR_Wrapper() to Dates() AS Date and see if that resolves.
Is there any way to msg specific users on this forum? Combo, you have been immense help(can't stress how grateful I am) and...
It's interesting the MajorP's XIRR_Wrapper() calling Excel has Dates defined as String,
Public Function XIRR_Wrapper(Payments() As Currency, Dates() As String, Optional GuessRate As Double = 0.9)
but MajorP's homebaked has Dates() as Date
Public Function MyXIRR(Payments() As Currency, Dates()...
Well clearly that was facetious sarcasm because I couldn't hack my way out of a cardboard box, even with all the kings horses and all the kings men spoon feeding me help it seems.
Passed it a Access column name per MajorP's instructions in another thread, so it should recognize as an array. I...
When I try to use the XIRR_Wrapper() option I get a "Compile error: Type mismatch: array or user-defined type expected" on the "Dates" parameter of the XIRR_Wrapper function? Any thoughts?
I tried testing the MyXIRR() option because I am a super smart next level international hacker/coder, and...
Ahhhh I see. Thank you for the prompt response and patience with me, combo; as you can see I am a total noob when it comes to code. Now that you have pointed it out I am like "unagi" and I can see the forest that I couldn't see for all the trees in the way. I will give it a go, I imagine it...
Combo,
Thanks for the response. If you are using the excel library you need parts of the third section? I thought the third section is only MajP's proprietary code. Any thought on the GetGoodGuess() function part? Thanks.
Andy,
Thank you for the prompt and helpful response, although I might need some time to digest because I am slow on the uptake, but if I use the early binding and activate the reference checkbox is that sufficient or do I need to add code to create an Xcel object?
Any thoughts on the...
I am brand new to Access and have only basic VBA experience coding macros in Excel, so apologies if I am being obtuse, but I am really struggling trying to get this(https://www.tek-tips.com/viewthread.cfm?qid=1789559) to work. Can I paste the code exactly as written for the two functions and it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.