> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4025?src=pr&el=h1) Report > Merging [#4025](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4025?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/864bc3c426016edab66b24b4095de24c484167de?src=pr&el=desc) will **decrease** coverage by `0.08%`. > The diff coverage is `7.54%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4025?src=pr&el=h1) Report > Merging [#4025](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4025?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/864bc3c426016edab66b24b4095de24c484167de?src=pr&el=desc) will **decrease** coverage by `0.08%`. > The diff coverage is `7.54%`.
> # [Codecov](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4025?src=pr&el=h1) Report > Merging [#4025](https://codecov.io/gh/rubberduck-vba/Rubberduck/pull/4025?src=pr&el=desc) into [next](https://codecov.io/gh/rubberduck-vba/Rubberduck/commit/864bc3c426016edab66b24b4095de24c484167de?src=pr&el=desc) will **decrease** coverage by `0.08%`. > The diff coverage is `7.39%`.
@MathieuGuindon It worth it to pick up Crystal Reports? I'm not averse to learning how to do it with SSMS/Reporting but I don't know how long it'd take. It's not like I'm still trying to learn C# or anything...
Some of them would say I'm half a duck
I may be used if you want to try your luck
I inspired your sweetest dreams, will say the most accurate
But for only 15 of them, it was worth a rate
Some of them tend to collect me
Even if I'm usually just worth a few penny
Ilia L found ...
Sheets("sht1").range("$B$"&Last_Used_Row&":$B$1047658").ClearContents
Kept getting "expect list seperator" error. Anyone know whats wrong? Been at it for hours
every day I get 5 to 30 Appointment emails with almost the same content from which I need to create the Tasks in Atlassian Jira. I wrote a macro to automate this process. I've never written anything in vba before and would be grateful for correcting my code. This macro works.
There is a function...
Public Property Get Bar() as Long Bar = this.theBar End Property Public Property Let Bar(ByVal RHS as Long) this.theBar = RHS End Property ```
Attempting to rename `Bar()` to `thisBar()` generates a warning. Ignoring the warning and continuing does produce a correctly renamed Getter/Letter and compilable code
, then the .Show method needs to switch and determine what to do; by exposing methods like Confirm we eliminate the enums and essentially bake the vbYesNo knowledge into the Confirm method, which by contract will be asking the user something and we need to know if they're ok with that - we only care for some boolean value in that case.
even so, they never should have overloaded the enums for messageboxes like so - the flags for icons, for the default buttons and the prompts should have been 3 separate enums, at least.
@IvenBach and here's a good reason why it's horrid -- they use both non-bitmask and bitmask flags in the same enum, so if you did something silly like vbYesNo Or vbYesNoCancel, it won't work and give out undefined behavior.
Yeah, I noticed that.
In VBA-landia, when I shadow the Msgbox, I'm stuck with the nonsense enums they use, though. (this is done primarily so that we can get prettier msgbox without updating the code)
@MathieuGuindon I won't argue, however that it does feel weird to read "vbOkOnly Or vbExclamation" --- I still remember the first time I encountered that.... "WTH? Computers can't make arbitrary choices like that! How the hell is it choosing?!?"
@MathieuGuindon Hence undefined behavior. If you don't know what's in that black box it's anyone's guess. Now I better understand that term. Thank for that explicit note.
@IvenBach which is why when you're dealing with win32 API (rather any API but more particularly the low level ones), you must read the specifications and adhere to it.
> I kneejerk use `MsgBox "This will show the third button selected", vbYesNoCancel + vbDefaultButton3 + vbInformation` without thinking about it. Was corrected to use `MsgBox "This will show the third button selected", vbYesNoCancel Or vbDefaultButton3 Or vbInformation`.
@this and VBA-virus by PowerPoint presentations about baby angels and how rich & forever lucky you're going to be if you forward this attachment to 7 people in the next 7 hours
@MathieuGuindon Wow... OK, scratch that whole thing. The inspections were somehow out of sync. I swear I double-clicked the inspection in the screen shot and that it highlighted that row. After a compile, parse, it's now showing legit ones where I forgot to include the .Value2 on the LHS of the assignment.
VB6 - so it's collecting the reference 'C:\Windows\SysWow64\COMDLG32.oca'. there are 13 types reported by GetTypeInfoCount, but when it tries to call GetDocumentation for index 4, COM throws DISP_E_BADINDEX.
Just one example, its a regular occurrence, and always on the same indexes. It's like some are 'missing' for documentation.
@mansellan I'd log the error along with enough information to know what library is involved and what index we're skipping, and do everything possible to keep processing the library and collect as much as possible
@MathieuGuindon ok cool. tempted to put try/catch on this method, looks like its not caught till the overall member loop in LoadModule. So its likely missing all the other meta atm.
``` PM> set-executionpolicy remotesigned Execution Policy Change The execution policy helps protect you from scripts that you do not trust. Changing the execution policy might expose you to the security risks described in the about_Execution_Policies help topic at https:/go.microsoft.com/fwlink/?LinkID=135170. Do you want to change the execution policy? [Y] Yes [A] Yes to All [N] No [L] No to All [S] Suspend [?] Help (default is "N"):y set-executionpolicy : Access to the registry key 'HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\PowerShell\1\ShellIds\Microsoft.PowerShell' is denied. To change…
I was to. But we had some "security controls" in our firm and... Because I'm technically not "IT", they stripped me from Admin privilegies on Windows Virtual Machine... Funny though, on host (Linux) I've got full access.... :-D
@DainIronfootIII I'm thinking for the past few months if I should "hack" my way through into adding local admin. :-D Maybe it's finally a time. It's time consuming. I'm calling them sometimes 3-times a day....
Would it be reasonable to request a right-click menu on each inspection in the Code Inspections window that lists all the options? I keep right-clicking out of conditioning, and having some options under the Fix menu and other options in the descriptive text below is... unconventional.
> Windows has managed to condition most of us to right-click things for our current options. Having some of the Code Inspection fixes available under the `Fix` menu button and other fixes available in the descriptive text of the CI dialog is just... unconventional.
Adding a right-click, context sensitive menu to each inspection result that lists all legal options for that result seems to be much more consistent with current (from, oh, 2000ish) Windows design.
Some of them would say I'm half a duck
I may be used if you want to try your luck
I inspired your sweetest dreams, will say the most accurate
But for only 15 of them, it was worth a rate
Some of them tend to collect me
Even if I'm usually just worth a few penny
Ilia L found ...
Sheets("sht1").range("$B$"&Last_Used_Row&":$B$1047658").ClearContents
Kept getting "expect list seperator" error. Anyone know whats wrong? Been at it for hours
VBA Rubberducking
VBA Rubberducking