`public sub foo(` resulted in `public sub foo()))`. Can't get a repro on it right now...
`With Activesheet.Range("` becomes `With Activesheet.Range("|") with cursor where vertical bar is. Trying to delete `)` results in `With ActiveSheet.Range("A1"|"` cursor in between "".
Context
The Visual Basic Editor (VBE) does a good job at completing member scopes, for example when you type this and hit ENTER...
Private Sub DoSomething
You get this for free:
Private Sub DoSomething()
End Sub
The problem is that VBA is a very, uhm, blocky language, and the VBE doesn't ...
@IvenBach if it works reasonably well for you then I'll implement the settings and make it opt-out. Otherwise I'll implement the settings and make it opt-in.
Microsoft bought Minecraft, people thought Minecraft would go Xbox-exclusive. Not only did that not happen, Minecraft now supports multiplayer across all different platforms except PS4 (Switch coming soon).
Microsoft. Are. Not. Evil.
(Anymore.)
So I finally got around to toy with @Camtasia (try it out!!) and made a little video previewing the new/upcoming autocomplete feature =)
#vba #autocomplete #autoindent
https://www.youtube.com/watch?v=jGtEzpSoC3Y
with the settings working and the user's ability to selectively disable autocompletes, I'm rather tempted to merge the PR as-is now.. works well enough for a "phase I" to me
I got nerd-sniped. A Rubberduck user put up a feature request on the project’s repository, and I thought “we need this, yesterday”… so I did it, and the result crushed all the expectations I had – the prerelease build is here! There are a few quirks – but rule of thumb, it’s fairly stable and works pretty… Continue reading Autocomplete Enhancement…
2018-06-05 11:31:30.4982;TRACE-2.2.6730.19673;Rubberduck.Common.LogLevelHelper;
Rubberduck version 2.2.6730.19673 loading:
Operating System: Microsoft Windows NT 10.0.16299.0 x64
Host Product: Microsoft Office 2016 x86
Host Version: 16.0.4678.1000
Host Executable: EXCEL.EXE;
2018-06-05 11:31:30.5201;TRACE-2.2.6730.19673;Rubberduck.App;Checking for legacy Smart Indenter settings.;
2018-06-05 11:31:30.7573;TRACE-2.2.6730.19673;Rubberduck.Common.Hotkeys.Hotkey;Hotkey for the associated command Rubberduck.UI.Command.Refactorings.CodePaneRefactorRenameCommand…
if I have text = "skldf""", how do I delete the last two "" :-D Delete, Backsspace Select those 2 and press delete/backspace, nothing works :-) And can't set it off because I can't get ot Settings :-)
New issue for this too?
Ah, figured it out. 3x backspace, 1x del. But can't put the cursor on the new line and then back on the first line :-) that will generate two more "" again :-D This will be fun.
> Hi guys, in the last build (and few before but not the one that fixed the building through VS) I've noticed that when I click on RD - Settings, the Settings windows does not appear.
Excel opened VBE opened (RD load just fine) Click on RD - Settings Copied Trace Log from user/appdata/...rd/log folder.
So I just tried the same process on my Laptop... (i'm building it in Laptop from the same OneDrive folder so I didn't even "pull upstream", because it was already pulled.
so I had a interesting observation. When I tried to run with no explicit registration, I found out that Castle Windsor will try to instantiate a QualifiedSelection.
That worries me as I think that is knowing too much - QualifiedSelection shouldn't be a part of the registration/resolution, at all, I'd think. It came up only because I was passing in a null for a model that used QualifiedSelection in its ctor, so CW went and tried to construct the model, but couldn't new up the QualifiedSelection being a value type, rather than a reference type.
I kind of expected CW to throw an exception about not being able to resolve the model because it's not supposed to be registered, rather than throwing an exception about unable to new up the QualfiiedSelection. Is that reasonable expectation?
Sooooo.... Everything is pulled from upstream/next without a problem. But when I open VS, this happens.
[Failure] Could not find file 'C:\Users\SecretUser\OneDrive\GIT\Rubberduck\Rubberduck.Core\obj\Debug\UI\Settings\GeneralSettings.g.cs'.
[Failure] Could not find file 'C:\Users\SecretUser\OneDrive\GIT\Rubberduck\Rubberduck.Core\obj\Debug\UI\Controls\GroupingGrid.g.cs'.
[Failure] Could not find file 'C:\Users\SecretUser\OneDrive\GIT\Rubberduck\Rubberduck.Core\obj\Debug\UI\CodeExplorer\CodeExplorerControl.g.cs'.
[Failure] Could not find file 'C:\Users\SecretUser\OneDrive\GIT\Rubberduck\Rubberduck.Core\obj\Debug\UI\Controls\LinkButton.g.cs'.
Build log ends well though...
1>------ Build started: Project: RubberduckCodeAnalysis, Configuration: Release Any CPU ------
2>------ Build started: Project: Rubberduck.Resources, Configuration: Debug Any CPU ------
3>------ Build started: Project: Rubberduck.Interaction, Configuration: Debug Any CPU ------
3>C:\Users\SecretUser\OneDrive\GIT\Rubberduck\Rubberduck.Interaction\Properties\AssemblyInfo.cs(39,32,39,39): warning CS7035: The specified version string does not conform to the recommended format - major.minor.build.revision
@this Well, ... I think that the first time I tried to apply cs-CZ language and after some Pull the Settings didn't appear, I manually set that to en-EN in User/appdata/roaming/rubberduck/rubberduck.config
The reason why I manually changed it was because it didn't appear after I made a Pull when I had the language changed to Czech. Or something like that.
@mansellan I've cracked some hefty VB6 FRM files, with images and custom controls and property bags, so I'm pretty sure my parser can handle them all. This is the first time I've been able to engineer a FRM file with a blob that starts at a non zero location.
OK, @MathieuGuindon, so now my lazy fingers want to type Dim myColl as Collection and I want autocomplete to add a new line with Set myColl = New Collection and ditto for Scripting.FileSystemObject and Scripting.Dictionary, and maybe MSXML.XmlHttpRequest too. Heck, it might need to be a user-configurable list of instantiable types.
It can ignore the resolver, and naively copy the type you declare. If you're not explicit enough, you get the unexpected type, and it's your own fault.
mixed bag for me. I like the idea of autocompleting the Set statement but I also think about other half time they'll come from a function call or something like that so the autocompletion would just get in the way
and to be honest, I struggle to see the benefit of keeping dim next to the set. Lot of time, I find that I need them in a block, and dim them in middle of block just feel wrong.
@MathieuGuindon Or, you type `Dim myColl As New Collection, and it autocorrected to the 2-line declare and instantiate. It does reinforce a bad approach, but it also magically fixes the inspection before it has even occurred.
you either will have to just pretend that Dim is a way to mark the "scope" or put the fiction aside entirely.
@ThunderFrame Correct.
The Dim at the top of procedure at least does away with the wrong notion. And if the list is so long, it's one big code smell. But if you have Dim sprinkled all over, it's also a code smell (screaming for a extract method).
@FreeMan IKR. But, TBH, I think that once the first working Avalon PR is merged, there'll be feverish development, as so many possibilities become realisable. The project will effectively morph from a project that tinkers at the edges of a 20yo IDE, to being a project that is an IDE, and one that can have any modern feature you can think of.
because of the lack of a framework (or decently-tooled std library), IME VBE code is more likely to end up needing imported modules, or every new project reinvents the wheel
Yeah. COM ecosystem is stagnant. I think VBA wouldn't have been so successful if not for VB6/COM where we used to be able to ride on their coattails. Now that's gone....
and frankly MS has difficult time understanding it's not the language, it's the framework that makes or break the productivity.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4058?src=pr&el=h1) Report > Merging [#4058](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4058?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/06bf68b741885945080a957226080de4837d3199?src=pr&el=desc) will **increase** coverage by `<.01%`. > The diff coverage is `0%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4058?src=pr&el=h1) Report > Merging [#4058](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4058?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/06bf68b741885945080a957226080de4837d3199?src=pr&el=desc) will **not change** coverage. > The diff coverage is `0%`.
#FunFact: Edgar's the one who said that quote about BASIC: I think of the company advertising "Thought Processors" or the college pretending that learning BASIC suffices or at least helps, whereas the teaching of BASIC should be rated as a criminal offence: it mutilates the mind beyond recovery.
though I learned Apple Basic because that was the only option I was aware of at the time. Forgot everything I knew about it until I had to pick up VBA about 10 years ago because people couldn't understand how to put a grey highlight in a cell in a spreadsheet...
I got nerd-sniped. A Rubberduck user put up a feature request on the project’s repository, and I thought “we need this, yesterday”… so I did it, and the result crushed all the expectations I had – the prerelease build is here! There are a few quirks – but rule of thumb, it’s fairly stable and works pretty… Continue reading Autocomplete Enhancement…
hrm... If I'm naming my procedure GetSomething one might presume it's a function that returns a "Something" that it claims to be getting. Might need to refactor some code...
removing whatever parameter was being used ByRef to return the Something will also generate compiler errors that identify what call points need to be updated...
But you don't KNOW where the file is located, unless I'm missing something completely obvious. Therefore, you can't. This looks like an X-Y problem: trying to find a solution for X when the problem is Y. If you bring up the reference.pdf from the "front end", then you can easily know where the file is located and don't need to prompt or assume anything. Is the "front end" an Excel worksheet? Some VBA project? A .NET application? — Mathieu Guindon1 min ago
Context
The Visual Basic Editor (VBE) does a good job at completing member scopes, for example when you type this and hit ENTER...
Private Sub DoSomething
You get this for free:
Private Sub DoSomething()
End Sub
The problem is that VBA is a very, uhm, blocky language, and the VBE doesn't ...
VBA Rubberducking
VBA Rubberducking