Storm swung through my area, and internet is crap now :(
Setting up a new computer. My mom's 10yo MacBook Pro died, I bought a new computer, and sold her my old one since I needed a bit more memory on my C drive.
Makes it hard to download stuff with bad internet :( It's so bad that ReCaptcha won't even load.
I passed my interview today with HR, and I've got one with the company architect tomorrow over lunch.
If that goes well, I'll have a third one with the unit mentor (basically a kind of HR-person who makes sure nobody works too much overtime and helps keep people on track for their personally-set goals to help keep them happy, and stuff).
> When I double-click a Code Inspection result, Excel goes "Not responding" and a few (3 or so) minutes later wakes up. Are 4318 findings a lot in a 30K line project?
This is not practically usable at present. Of course I could disable many of the default observations but as a first run it's useful to run through them ... if I could only run. I might try exporting to Excel and writing a macro to jump from the finding to the place in the code, without RD running.
@IvenBach you need to set up a web cam and aim it at your glass wall. You could win millions on one of those funniest videos shows! Once you do, you can work on RD full time!! :)
Even if you don't, you can share with us for pure entertainment purposes.
> This seems to be duplicating #4928. As it stands, you want to disable automatic inspections after reparse. You can still get inspection results if you refresh from the Code Inspections toolwindow. For all other cases, Inspections will not be run.
> Sure, but I have to run Inspections first to get the results, then unload RD and run my little SheetChange macro (on the sheet where I pasted the copied results ) that jumps to the offending line much more quickly than RD. My question is, is there a simple toggle rather than Unload? How about the performance? Would you expect a three minute wait after a double-click? If that's just how it is, I'll use this workaround.
Following these instructions for setting up my ForEach Loop in SSIS. In Figure 3, he shows setting the Result Name to 0. Is there any particular reason for doing so? Is it "convention"? Will it break if I don't?
@MathieuGuindon not that this comes as a surprise to you, but I marked a method with '@obsolete, parsed & looked at inspections and the call was properly flagged. #itworksheretoo
@Vogel612 the TW gets very flakey with lots of results - repro'd with the battleship code on 2016 x64. Ok maybe not 3 minutes, but much, much longer than it should be - freezes everything for a long time on first double-click.
> I notice a similar but much smaller delay for a Word project I have which currently has about 10k loc. I think this issue is mainly when you expose an existing project to rubberduck. It should be possible to switch off code inspections for each module with an annotation '@IgnoreModule' so that you can expose modules/classes 1 at a time and deal with a smaller number of issues. Unfortunately, this annotation doesn't seem to be working as expected at the moment.
> I notice a similar but much smaller delay for a Word project I have which currently has about 10k loc. I think this issue is mainly when you expose an existing project to rubberduck. It should be possible to switch off code inspections for each module with an annotation '@IgnoreModule' so that you can expose modules/classes 1 at a time and deal with a smaller number of issues. Unfortunately, this annotation doesn't seem to be working as expected at the moment. (See github.com/rubbe
> `'@IgnoreModule` works here just fine in Access on build .4734. I had .4729 installed yesterday, and wasn't in the VBE extensively, but don't recall having had issues with it of late (#4965 not withstanding).
I just tested it out to confirm - I get 18 inspection results in some "borrowed" code without it, and no mention of the module in my inspection results with it. (Tested in Access because I had a project open.)
> Noting another that I just came across, to see if there is One Change to Fix Them All:
```VBA ErrorHandler: With Err LogManager.Log ErrorLevel, Strings.Join(Array("Navigation failed for: ", this.SiteValues(CStr(ClinicIDLinkKey)), ". Number: ", .Number, " Description: ", .Description), vbNullString) Dim errNum As Long errNum = .Number Dim errDesc As String errDesc = .Description End With
IWebDownloader_NavigateToDownloadLocation = False Err.Raise Fai
> Following my comment on #4990 I've done a bit more investigation. It seems that there is a specific inspection which is not ignored by '@IgnoreModule. This inspection result is the 'Public member name contains an underscore. Unfortunately, vbWatchdog seems to have a large number of this type of memeber.
> Following my comment on #4990 I've done a bit more investigation. It seems that there is a specific inspection which is not ignored by '@IgnoreModule'. This inspection result is the 'Public member name contains an underscore. Unfortunately, vbWatchdog seems to have a large number of this type of memeber.
> @daFreeMan. Found the problem. Its the inspection result 'Public Member name contains an underscore' that is being ignored by '@IgnoreModule' annotation.
> @SystemsModelling the freeze with the inspections toolwindow is definitely not normal.
> Barring review comments (and assuming a successful build...), that's everything I intended to go into this one. Note that I had to disable group virtualization to handle the expand and collapse all buttons, but when I did the second round of performance testing it turned out to be "acceptable" for the ~3000 inspection result project I tested on. Not instantaneous grouping changes, but sub 1 second. If
Hi Guys. A little help? I'm adding my own classes into Public UserControls as Scripting.Dictionary but sometimes my script results in error and I thought that when VBA script (excel) ends, it will clear all data. Like in Python and so on. But to my surprise no... The dictionary still holds my custom Class so when I wanted to add it it told me "key already exists..."
What's the best way to guarantee that everything is clean when I start my script even after some unhandled error.
Another way that came to my mind is to create a custom class clsMyControls that would imitate Dictionary, had a Private Sub Class_Terminate() that would empty it but I'm not sure if the Terminate would fire if some unhnadled error occured...
Or if there is another, a better way... There are no tutorials for "structure your big application this way:" :-/
For past 2 years I was adding it into collection (without Key) and just lately discovered that I had so many duplicate custom classes in those collections it shocked me...
My ideal program workflow
1) form is opened, all controls are initialized as my custom classes and added into some form of a collection (dictionary) with key: "FormName@ControlName"
2) when another form from the initial form is opened, controls again initialized as my custom classes and added into the same collection with key: "AnotherFormName@ControlName"
3) When I close the second form, all custom classes are deleted from the Dictionary
4) If some unhandled error occurs when I'm modifying the code or in production, the Dictionary with my custom classes are emptied.
it's a global variable, it won't die until you tell it to
(or make code changes that invalidate the compiled code)
@SonGokussj4 you could add the items with Set collUserControls("key") = value, that's basically a "add or update" that won't throw a "key already exists" error
or, explicitly clear the dictionary at one point, or explicitly End execution
> So, I started again, reloaded RD, opened the Code Inspections, waited a minute, clicked a finding and it was there in a second or two. Repeat, same result. Scrolling a page down takes a few seconds but not annoyingly so. I don't know what's different this time, so next time I start from scratch I'll be more methodical about recording the time so I know what part of the log corresponds to what I'm doing.
but a have a very poor support for it - citation needed, ideally not coming from some hater that believes VBA is a toy language. Not supporting class inheritance is hardly making a dent in OOP support. Here's some full-blown OOP VBA code that's arguably better written than many implementations written in Java, C#, or other inheritance-supporting languages. You can't write a Model-View-Controller app in a language that has "poor support" for OOP. Consider removing that useless jab. — Mathieu Guindon40 secs ago
@MathieuGuindon As I read the accepted answer, I thought it was yours. Might be worth inviting the author over to see if (s)he's interested in a little side project!
Which I would assume means that the project wasn't freshly parsed. However, it certainly looked freshly parsed. I clicked the parse button and it worked OK.
but if you do modify data or need some particular client-side functionality (e.g. disconnected rs), then you can't just assign from cmd.Execute; it won't work the way you expect it to work.
The worst thing about ADO is that it will never give you a runtime error if you gave it some nonsensical settings; it just silently substitute with what it think is valid.
Some testing seems to work just fine w/o the added .recordset. Plus, the insertRS was not being used for anything. That was essentially the last line of the method
I'm wondering - if one sets up a git repo on a virtual machine that may be used by different users (using a generic user profile), what's the best way to ensure that each commit requires author name/email to be supplied?
> **What** Functions and property getters in VBA/VB6 don't *need* to explicitly return anything in every execution path, or at all actually. Let's implement an inspection that flags functions and property getters that wouldn't compile in VB.NET because *not all code paths return a value*.
**Why** This inspection would be useful for code that needs to easily portable to .NET, and could potentially prevent bugs. It's different than "Function return value is not assigned", which doesn't care f
@IvenBach be sure to check your voter subscription status, might have a [bad] surprise at the polling office in November otherwise. hth does a SS# randomly get "cancelled" anyway?
> Since I was "wishing", I thought I would add another item to this request. When an item in the Type declaration is an Object also include the Class Init and Terminate procedures with an instantiation of the object(s) and setting them to Nothing.
hi guys... i'm still on v2.2.6693.19208... i accidentally docked the Find References pane... what's that trick to undock panes that absolutely under no circumstances should ever be docked..? =-)
i seem to remember editing some file with a text editor...
DuckCheck: When using Excel.Range.Find(What:=vbNullString, SearchFormat:=True then using Excel.Range.FindNext(previousFoundCell) is it ignoring the supplied format?
@IvenBach Okay cool, and you're probably completely correct in doing it this way, but do you expect to have results returned for searching formats of vbnullstring?
That seems like something that could only be returned for cell values, not numberformats.
what really gets my goat is that they should have had written it as a table-valued function. Heck, even a scalar function would have been tolerable, since it's much more reusable
but no, they had to write it as a one-row sprocs. I'm not going to write a INSERT INTO...EXEC around that one-trick pony.
@Vogel612 (mod hat) - does this comment come off as snark?
There's no such thing as "once in a while" with code. Either it works, or it doesn't. Any money bets the problem is the data. Watch for leading/trailing spaces in your inputs, and/or consider Trimming the string input before the comparisons - again seriously consider using StrComp instead of an implicit and bug-prone Option Compare setting. Good luck! — Mathieu Guindon2 hours ago
That's the fun thing about those implicit voodoo conversions; even if you've explicitly cat it, it can get cast again downstream (e.g. re-formatted on Excel spreadsheet as already suggested).
Yes. In fact Axel Schreiner provides his book "Object-oriented Programming in ANSI-C" for free which covers the subject quite thoroughly.
.gif)
VBA Rubberducking
VBA Rubberducking