@FreezePhoenix It would be, absolutely. But that would require managers and PMs that understand that code needs to be maintained, not just added-to. That's rare.
yeah, but all that means is that devs start padding their estimates. it gets slower and slower, and the managers have no clue why. till one day, more time gets spent fire-fighting than developing. cue the death march...
TBF, there's some recognition at my current gig. not enough, but still...
Public Sub LineContinuationsInBetweenMemberCalls()
Debug.Print Application _
.WorksheetFunction _
.Proper( _
Selection.Value2 _
)
End Sub
^ #TIL. Checking with ducky and there aren't any inspections that come up. It feels like there should be some inspection alerting the user to this abuse of line continuation.
Any licensing concerns if R package compared to python used for data science purposes as I curious to use R tally up from a codebase for reporting and discovery. R is part of GPL 2 though and was discussed earlier when Chris dropped by. Just gather thoughts as I’m learning R on the side thanks to a free ebook discussing the basics...
My goal was to do a discovery from RD codebase to make a small list of variables and compare the effect of those variables over a timeline against a number of Github issues.
Public Sub LineContinuationsInBetweenMemberCalls() Debug.Print Application _ .WorksheetFunction _ .Proper( _ Selection.Value2 _ ) End Sub
an abuse of line continuation.
How about considering the reverse proposition, that there is an inspection for line length with the fix being the insertion of line continuation characters if a line is too long.
E.g a fix along the lines of
Public Sub LineContinuationsInBetweenMemberCalls() Debug.Print Application.WorksheetFunction.Proper( Selection.Value2, Parameter2, Parameter3, Parameter4 )
> **Description** I found your addin is quite awesome, but there are nearly nobody used this addin here in China. If you will start to do it, i can help translate. but i need you to tell me, which tool should i use, or which files should i translate.
and i guess the locale files are: RubberduckUI.resx, RubberduckUI.Designer.cs, Templates.resx, and many of the resx files in source code. am i right? my email is loquat520@qq.com
Hi folks. What is going on with VBA under the hood? My application went real slow.
I initialize every control on form as custom Class that has Events and other properties, methods but then when I click on that control, the load time (Combobox's roll out, selecting items) or OptionButton changing what Opt is selected in one group got slow.
When I don't initialize my custom control, it's fast
ElseIf TypeName(Ctrl) = "OptionButton" And IgnoreOpt = False Then
Dim myOpt As clsUserOptionButtonNew
Set myOpt = New clsUserOptionButtonNew
myOpt.InitializeWithValues Ctrl, parentForm:=frm
Set collUserControls(myOpt.collectionName) = myOpt
This is my Class
Option Explicit
'@Folder("Classes.Controls")
'@MemberAttribute VB_VarHelpID, -1
Private WithEvents pMyOptionButton As MSForms.OptionButton
'=======================================================================================
' TYPE DECLARATIONS
'=======================================================================================
Private this As TView
Private Type TView
Ctrl As MSForms.OptionButton
ctrlRawName As String
parentForm As UserForm
dict As Scripting.Dictionary
I noticed that when I comment out the ***"_MouseMove" event***, it is blazingly fast. But whatever I have in MouseMove, it just drastically slows the control.
(I want to show a special text within special textbox on the UserForm when my mouse is over a control. (each of them has it's own "help text"))
@SonGokussj4 My speculation is that when your code is handling the _onMouseMove event, it's slowing your processing down because it has to call your code every time the mouse moves a pixel. I'm not sure if it's called for every pixel of movement, or just each group of moves, but I'd imagine it has to be for every pixel.
If it's not every pixel, how would your code know that the mouse has moved across the region of interest and should, therefore, trigger whatever it is you're after.
If you're going to do _onMouseMove, it should probably be some very small, very tight code because it's going to be called a lot.
@IvenBach You posted a series of git learning links a couple of weeks ago. I skiwied them, but didn't bookmark 'em, and now they're lost.
You mind reposting? I'll be sure to bookmark, not just open this time.
> I'm trying to add '@Description attributes to api declarations with conditional compilation, like this:
``` '@Description("API: Destination and Source can be byVal pointers or byRef variables, length is LenB(dataType)") #If Win64 Then Private Declare PtrSafe Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef Destination As Any, ByRef Source As Any, ByVal length As Long) #Else Private Declare Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef Destination
@FreeMan not every pixel, no. I'm not sure exactly how fine the resolution is but the mouse move event does get missed if you swipe your mouse very quickly across narrow enough area.
@this Yeah. Because of this I can't depend on it to fire "onmouseNOTover" event... Vba is stupid in this way.
@FreeMan I get that. I just implemented geometrically faster way of showing informations I want so I will test that on my ComboBoxes, which were slow as hell. OptionButtons just got faster :-) I hope it is because of the immensive calling and not other "hidden" things.
@FreeMan I would gladly read that as well. Using Git every day but not master in any way. Just got used to creating branches and merging them into my next/master branch.
> More translations are always welcome! Keep in mind that resources that aren't translated will appear in the fallback en-US language, so it's important to keep the translations up to date as more features and inspections are added.
You will need Visual Studio 2017 (Community Edition is free; also note, Rubberduck won't build in VS2019), and to do the French translations I use [ResXManager](https://marketplace.visualstudio.com/items?itemName=TomEnglert.ResXManager), which makes it easy to loc
> Rubberduck is only seeing the "live" code (IIRC with whitespace in place of the "dead" code), so stuff around conditionally compiled code is always going to be a rough edge.
Does it work better if you put the annotation inside the conditionally compiled block?
```vb #If Win64 Then '@Description("API: Destination and Source can be byVal pointers or byRef variables, length is LenB(dataType)") Private Declare PtrSafe Sub CopyMemory Lib "kernel32.dll" Alias "RtlMoveMemory" (ByRef
> I thought that might be the case. No, that change doesn't solve the problem; I'm getting errors in the log like this one:
``` 2019-06-28 14:46:41.1293;ERROR-2.4.1.4694;Rubberduck.UI.Inspections.InspectionResultsViewModel;System.NullReferenceException: Object reference not set to an instance of an object. at Rubberduck.Parsing.VBA.AttributesUpdater.AddAttribute(IRewriteSession rewriteSession, Declaration declaration, String attribute, IReadOnlyList`1 values) in C:\projects\rubberduck\Ru
> I will have to test this case. It might be that the attribute gets added outside the procedure, which would cause the VBE to ignore it.
Another possibility is that it gets added in the wrong branch of the conditional compilation.
I think part of tge problem is that we require annotations to be above the member and the VBE demands attributes to be inside or right below the member.
> I will have to test this case. It might be that the attribute gets added outside the procedure, which would cause the VBE to ignore it.
Another possibility is that it gets added in the wrong branch of the conditional compilation.
I think part of the problem is that we require annotations to be above the member and the VBE demands attributes to be inside or right below the member.
I have a program that read thousands of lines and return the value that I need. The problem is that request take a lot of time probably like 1min just to search and paste the value, even when I'm saving the code it takes a lot of time...
I think it is around this line that the code is slow :
If...
> I'd be curious to see the trace-level logs for the initial parse and a subsequent refresh.
Some code constructs are inherently ambiguous and break the parser's SLL prediction mode; when that happens the entire module is reprocessed using the slower but more accurate LL prediction mode, and such occurrences would be in the trace-level logs.
For example, avoiding `foo!bar` bang notation can go a long way towards improving parser performance *across 350 modules*, among other things. Looking
@Freeflow It is more the continuation between the . access operator that don't feel right. I often use continuation between arguments. But never have I used it between an object and the .Foo method.
@FreeMan remember to bookmark. If you Skiwi a tab you'll get it read within 2-3 hours. At worst by end of day. I still don't know how the real Skiwi does it with so many tabs open.
> **Rubberduck version information** The info below can be copy-paste-completed from the first lines of Rubberduck's log or the About box:
Version 2.4.1.4742 OS: Microsoft Windows NT 10.0.18362.0, x64 Host Product: Microsoft Office 2013 x86 Host Version: 15.0.5115.1000 Host Executable: MSACCESS.EXE
**Description** When I try to rename a Module or Class using the rubberduck.rename function access hangs / stops working and I've to kill the process. Though, the rename has worked. S
> Rubberduck doesn't pop a success message, although that's a possible enhancement - it does kick off a reparse of the affected modules though. Is it possible to attach a log file? The spinning duckies are running on the UI thread, as is every COM member call (i.e. the actual renaming and writing of the affected modules) - it's possible the duckies freeze for a bit, but hanging the host process isn't expected indeed. Presumably the logs contain information about any error that might have occurre
> Version 2.4.1.4742 OS: Microsoft Windows NT 10.0.17134.0, x64 Host Product: Microsoft Office x86 Host Version: 16.0.11629.20246 Host Executable: POWERPNT.EXE
**Description**
RD Auto-completion doesn't put cursor within auto-completed double-quote when writing a Case statement in a Select Case construct.
**To Reproduce** Steps to reproduce the behavior: 1.Type: Case= 2. Add the first double-quote: Case=" 3. VBIDE converts it to: Case Is =" 4. RD adds the closing double-quote
Talking about reddit, I read a hilarious story on the military stories channel yesterday.
About these guys doing op force, and they were getting beat up by the main force.
The NCOs were all dead, but one yelled from beyond the grave "It's your team now".
At that, one of the guys who was kind of known for not being too bright, leapt from cover and charged the vehicles the other team was in.
He climbed on top of one of the vehicles and disabled the gun.
When the other vehicles dropped their ramps to let the infantry out, he used the gun against them (they story said their MILES gear rang out like satan just got married), then pretend-threw a grenade into the cab of the of the truck and won the fight.
The NCOs on the other team were furious, and his NCOs just lay where they were "killed" and laughed.
Then they grouped up and laughed themselves silly that night listening to everyone's version of the story.
> **Justification** Managing source code for VBA Projects is currently inelegant. Committing binaries to Git repositories prevents the use of diff tools, and manually exporting/importing modules is tedious and time consuming.
**Description** * **Export** The feature should allow the user to Export all modules in a specific VBA project to a specified folder on a per project basis. This will allow exporting directly into a Git repository. Additionally, the Exporter should be able to delete a
Minor performance improvements for InspectionResults View
Ignoring an inspection type no longer triggers a full reparse. Grouping behaviour changes are in a defer-cycle to avoid a rerender without any grouping.
Hrm. I'm trying to push to my remote repo and getting a regjected message. "Updates were rejected because the tip of your current branch is behind its remote counterpart". Thing is I've already git fetched and git merged confirming that it's up to date.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4956?src=pr&el=h1) Report > Merging [#4956](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4956?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/4f387a27228c881a76258dce1aba8f35c73ed847?src=pr&el=desc) will **decrease** coverage by `0.04%`. > The diff coverage is `23.68%`.
> This doesn't seem to be solved in the PermissiveAssert class (still failing rather than inconclusive). At any rate, for that I think the test result should be passed to reflect what VBA does.
400 is the best choice in both cases. If you want to further clarify the error you can either change the Reason Phrase or include a body to explain the error.
412 - Precondition failed is used for conditional requests when using last-modified date and ETags.
403 - Forbidden is used when the se...
Hmmm, that suggests 422.
The context is, I have a bunch of JS validations.
But those can't always be trusted, so I'm putting them on my backend too.
> Consider that Charles Frederick, Duke of Holstein-Gottorp and the one that all Russian emperors after Catherine were descended from, would have been king of Sweden had his aunt not stolen the throne from him. > The Holstein-Gottorp men had bad luck with women. Charles Fredrick son Peter the III of Russia was himself deposed and killed by his wife Catherine II, or Catherine the Great after only in power for 6 months.
I have a program that read thousands of lines and return the value that I need. The problem is that request take a lot of time probably like 1min just to search and paste the value, even when I'm saving the code it takes a lot of time...
I think it is around this line that the code is slow :
If...
VBA Rubberducking
VBA Rubberducking