Recent content by SoLost1

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.

I still have not been able to get it to work. Can anyone please help this poor moron?

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...