BZngr

:)

Ah, OK thanks...so it's a substantial impact. But also sounds like it is probably not worth spending much mental time on until the RD3 design/implementation is a lot further along. Gotta say, the progress on RD3 is really quite amazing. :)

Just curious about the impact of the new RD3 architecture on the existing RD test suite. For testing, will the LSP and DB be in separate processes for testing as well?...and, regardless of where they reside, would they be spun-up/down for each test?

Onward to 2023! Happy New Year all!

@MathieuGuindon Yes - Merry Christmas indeed! Gotta say...it's been awesome watching RD3 progress reports and screen shots scroll by. Happy Holidays to all!

@Duga I'll come back to this one if it's not picked up during Hacktoberfest.

@MathieuGuindon I've made progress on the 'numerous' inspection results regarding issue described in #6039. Hope to have a PR soon-ish to explain/describe the issue. Traveling atm, so it might be tomorrow or the next day.

@Duga @MathieuGuindon That would be awesome. Started debugging for what I thought would be an obvious and quick solution late last night, but got nowhere and ran out of steam.

You will need to have Excel load a debug version of the RD dll.

In VS, attach to the Excel process after RD has loaded. Set breakpoint(s) in the C# code and invoke logic in the VBIDE that would call C# code of interest.

Debug=> Attach to Process... in visual studio. That's how I/we test RD code from within the VBIDE. I think it is the process you are describing.

@Greedo This is awesome. I too have been trying to wrap my head around the RDv3 descriptions and how it might be organized (with little success). Thanks for sharing.

@Duga not sure resolver is the correct label.

Sure! I've recently been trying to keep my line lengths around 80-ish lately - creates all sorts of new formatting 'decisions'. :)

@BigBen FWIW I've landed on lining up the parameters the same as the function body much like your initial example - except that I would include the function's ') As ShapeRange' statement on the same line as the last parameter. Then, I add a blank line between the last line of the function declaration and the first line of the function body for a clear distinction between the end of the declaration and the start of the code.

@Duga miss a step in your PR process...pay the price.

@Vogel612 Thank you!! That worked perfectly :)

:)

Yeah...that was EF

In general, I prefer PredeclaredId classes to modules because PredeclaredId member references must be fully qualified.

As a 'simple' utility class/module - it would seem (to me) that one has no advantage over the other.

@FreeMan Yes - PredeclaredId classes provide a default instance that can be used directly. For the most part, a PredeclaredId and a regular module can be used in an identical manner and both reside in the global namespace. That said, PredeclaredId class modules cannot be used as macro entry point - which is a key difference. Another is that, unlike regular modules, PredeclaredID classes can expose/implement interfaces as well as generate and handle events.

@IvenBach Sorry to hear that. My condolences.

FWIW - When I request it's Definition' from the VBE, it identifies Color` as a member of LoadPictureConstants in the ObjectBrowser

They are static strings within TestCodeGeneratorStatics.cs in the Unit Testing Project

@FreeMan Yes...I was wondering if perhaps the Parse somehow did not complete. Moving the Declaration to below the Private Type Declaration just gave the Parser another run at it - and enough time had passed that other changes probably had been made.

Yeah...definitely a bug

Grabbing a straws...maybe move the Declaration below the Private Type Declaration

@FreeMan Maybe declare as Public or Private rather than Dim?

That really looks awesome!

:)

SFSOD? Save for some other day?

Sooo - my system keeps coercing me to upgrade to Windows 11...anybody here know of reasons to resist?

Or did he indent to close the intender issue?

:)

Dropping in a 5600 line module has to make an audible sound.

Wow...is it the only module in the project?

Here's to putting both 2020 and 2021 behind us. Happy New Year!

Happy Holidays!!

@SimonForsberg Looks to me like the comment was edited that many times.

Note to self: work on chat markup skillz

shrugs shoulders

I was about to say - that vba module is way beyond my skill set.

I'm guessing Controls on a worksheet

'sheets that represents "code" and not "data"'...could you elaborate?

Just did an experiment where I imported everything from my repo into an empty workbook. It succeeded except that some References are not restored - just couldn't compile immediately. Thought I had tried that before with no success(?)... I may have to rethink my git workflow - my biggest concern was recovering from a corrupted xlsm.

Yeah...just kinda taking a poll. I do...but it comes with some downsides. I elected to store them because I just end up managing copies of those files somewhere else..but that comes with some downsides as well.

@FreeMan do you keep the .accdb. .xlsm, etc files in your repository as well as the exported text files?

Agreed!