Private Function TryGetWorksheet(parent As Workbook, name As String) As Worksheet
Dim result As Worksheet
For Each result In parent.Worksheets
If result.name = name Then
TryGetWorksheet = result
Exit Function
End If
Next
End Function
Reminds me of that one conversation - the guy did not want to use OERN why? because he has his VBIDE set to "Break on all errors" so it's easy for him to debug, so he prefer to code code without any OERN or anything that would potentially raise an error.
@Comintern I wouldn't be surprised if OERN version sucks for small enough set, but if the set can grow, then OERN should start to look better. I'd be surprised if it sucks in all situations.
Right. When I have no idea of what how many I will have, I just grab me a collection class, and call it a day.
TBH the OERN vs looping to find a document in a document collection is likely mirco-optimizing anyway. Not many people will run around with 2000 worksheets Excel file... I hope.
With Access, we have multiple collections, so even for a file with 500 tables, the worst is more likely to be the query collection or possibly the form collection but I've never seen it go more than 1000 in a single collection.
Dumb question -- in C++ the default behavior is basically OERN. It's usually on the programmers to check the return on every single function call. This is cheap compared to handled exception, right?
@this actually, red is my favorite colour (or it least it was when I was a kid and that stuff mattered). The 3 of them were talking and that little corner-of-the-eye-glance at the avatar to see who what saying what just wasn't working. Too much cognitive load. Like naming variables a, b and c...
@Vogel612 What's funny is that I didn't realize it was a hand until just now. I thought it was some bird (like the kindergarten turkeys). The "Vogel" is misleading.
I swear it's the user-name that pointed me in the wrong direction though. If it didn't translate to "bird612", I probably never would have made the connection.
> Orleans is a framework that provides a straightforward approach to building distributed high-scale computing applications, without the need to learn and apply complex concurrency or other scaling patterns.
Sounds like it's for script kiddies to generate rainbow tables, LOL.
> an even-toed ungulate mammal that chews the cud regurgitated from its rumen. The ruminants comprise the cattle, sheep, antelopes, deer, giraffes, and their relatives.
The VBA code "WaitUntilF9Key" detects the "F9" key pressed when its pressed and not until it is pressed. The "WaitUntilLButton" fires right away, not when the left keypad button is pressed. Why would this be? Tkx
Option Compare Database
Option Explicit
Private Declare Function GetAsyncKeyState L...
@Comintern often, in early stages of the programmer's lifetime, they just blindly copy'n'paste any random API from an API repository. Anyone else remember the "VB API heaven"?
but lot of times, they're just promiscuously swapping around API declares, without even linking to the source documentation. And they act surprised when it doesn't work the way they thought it'd.
Hi folks :-) So I finished the translation in time and for today I tried to turn on english comments.... What an idiot :-D There are so much helpful statements that simplify the translation... That should be somewhere written on wiki - let the english comments column turned on... :-D
Oh and - is it possible that somewhen in the future, you will be focusing on quicker RD parsing? For my project, it takes about 30 seconds. Don't know if that's normal :)
so... I've made a dll now. Dumpbin still claims it's 32 bit, but I can't see how it can be. The compiler will be emitting 64-bit code, and it's linked FM20 which I've confirmed to be 64-bit
I think whatever in the VBE is creating the obj file is hard-coded to emit the x86 flag in the COFF header, even though the payload is actually 64-bit. Does that sound plausible?
If I'm right, 64-bit COM Dlls authored in VB are acheivable
And probably exes to - iiuc that's pretty much just a linker option
@mansellan for regsvr32 to work you have to have the appropriate entry points. Is that a thing ODE does?
@SonGokussj4 not sure, I only had a quick glance - i see few of your modules have >1000 lines of code
whether that is a contributing factor or not, I'm not sure. Someone else here (@MathieuGuindon ? ) said that generally, it's faster to parse 1000 small code modules than it is to parse 100 large modules
@this I struggled with it on that - with just class modules, it kept saying "no public creatable object" - I guess it was trying to set the entry point. Fettling the class attributes didn't work. So I added a form, fettled its attributes, then it let me build. Guess that's no good for COM though?
yeah. I would really need someone to review my code and give me some pointers... I'm not saying you or Mat. I know you guys have a ton of work. Bud I don't suppose I can just post the whole project to the stack-overflow review.
Or maybe, here's a thought, one could disable some of the resolvers capabilities from a settings menu :-) So that It won't take me 1 minute but only 20 seconds when I don't need inspections or tests or something like that. And when I do, I would just turn it on in the settings.
oh, BTW, I remembered one more thing - we did observed a parser slowdown at one point because it in fact wasn't doing something right. It only seemed quick before becuase it was skipping a crucial step... lemme find that issue...
ok, again, I'm going blind here because I honestly don't know what to expect from ODE. I never counted on it making DLL that would be compatible with the regsvr32
what little I know about it is that in order to register it for COM use at machine level, you must have DllRegisterServer and DllUnregisterServer methods
ok, so lets evaluate. this thing was meant to be used in conjunction with 2 specific ActiveX designers - Data Environment and Data Report. I know that those can magic-up a public-creatable class in the project. It's possible they also add the relevant entry points, and include the regsvr methods.
VBA Rubberducking
VBA Rubberducking