Posting here in hopes that it is the right forum...
I'm not sure if this question has been asked before, but I have been googling/troubleshooting for over 8 hours and I'm at still at a complete deadend-- apologies in advance if I'm asking something that has already been answered.
I have a vba cod...
> Thanks for questioning the use of `dynamic`. Even though it _worked_ as part of the origin quickfix, your comment made me consider/realize something. Now that the work is done in a refactoring action, the model parameter is not guaranteed to be coming from (and vetted by) the inspection/quickfix processing. So, removed the use of `dynamic` and added a guard clause to enforce explicit input expectations.
I've also added unit tests for the two quickfixes. They basically test that the q
@Duga yeah...probably need some expert assistance. (using VS2019)
From AV details: MSBuild auto-detection: using msbuild version '15.9.21.664' from 'C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\bin'. C:\projects\rubberduck\RubberduckCodeAnalysis\RubberduckCodeAnalysis.csproj : warning : Unable to load the service index for source https://api.nuget.org/v3/index.json. C:\projects\rubberduck\RubberduckCodeAnalysis\RubberduckCodeAnalysis.csproj : error : Unable to find package Sunburst.NET.Sdk.WPF. No packages exist with this id in source(s): Microsoft Visual Studio Offline Packages, nuget.org
@FreeMan OMG, it's still a thing? That was already a thing since what? 2000? I wonder how many poor little tykes went there on their school projects about their favorite president...
@BZngr based on the error message, I'm going to say AV is borked, esp. if your environment builds.
@BigBen what do you mean? Isn't everyone in the White House supposed to do adult things like issuing orders, meeting with diplomats and paying bills?!?
C:\Program Files\dotnet\sdk\2.2.110\Sdks\Sunburst.NET.Sdk.WPF\Sdk not found. Check that a recent enough .NET Core SDK is installed and/or increase the version specified in global.json.
hmm not sure if that did anything.. I signed out then back in to make sure it's all set up. I still see the Rubberduck project but that goes to bclothier/rubberduck
if I change URL manually to rubberduck-vba/rubberduck, I see other builds but I can't see anything to start a build manually
clicking on the Rubberduck takes me to bclothier/rubberduck. If I manually change the url to rubberduck-vba/rubberduck, I still see bclothier in top left
Does anyone please have tips on how to preserve code formatting when pasting into Excel in a readable fashion? Into a worksheet that is. I was hoping to paste nicely formatted code into a text box but it all goes horribly mushy.
@Freeflow Interesting. Without that, I get a "invalid use of paramarray" which is a pretty weird error message.
@QHarr Don't use Excel? ;-)
I would imagine that you might need to make use of monospaced font & paste into the formula bar rather than into the cell but not sure if that'll do the trick.
dealing with just the line breaks in Excel is a pita already.
@this OTOH, if the other procedure takes ByVal args As Variant, then CVar() is not needed. It's only if it's ByRef, do we get the invalid use of paramarray.
Probably because the ParamArray is locally scoped and passing it ByRef would potentially cause memory leaks so they cut corners and disallowed the ByRef use.
@this Lol.... It is for candidates to submit their test answers but Excel is likely to be the vehicle for answer submissions even for the other languages part.
i hear ya. Found out this week that a license we have doesn't allow us to visualize the data in question outside of Excel (e.g. in Power BI). Time to (ab)use Excel even further.
VBA Rubberducking
VBA Rubberducking