« first day (1749 days earlier)      last day (214 days later) » 

12:01 AM
RELOAD!
[rubberduck-vba/Rubberduck] 1 opened issue. 1 closed issue. 8 issue comments.
Minesweeper: Games Played: 49, Bombs Used: 17, Moves Performed: 6734
 
 
3 hours later…
 
Keep the star shower going mug.
 
 
1 hour later…
3:51 AM
I second the encouragement for writing a book on C# possibly Matt offering specialised skills with integration of frameworks like RD has.
 
4:30 AM
@Hosch250 Sent follow up email.
 
 
1 hour later…
5:52 AM
> The headline of the web page reads "From unit testing to **source control**, from code inspections to refactorings, programming in VBA will never be the same."

However, #3758 triggered the removal of source control (git) from the project - the recommendation is to use the Export feature and then version control the resulting file(s) or structure. Maybe changing the phrase above to read something like:
"From unit testing to code export *(allowing source control with your preferred tools)*,
 
 
2 hours later…
7:40 AM
> **Rubberduck version information**
Version 2.4.0.4618
OS: Microsoft Windows NT 10.0.17763.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11425.20140
Host Executable: WINWORD.EXE

Code Inspection for naming clashes 'Something' hides 'something'

This inspection has recently appeared. I get 10 such clashes reported. ( are down to me but one is confusing

Warning: Project 'Normal..Normal' hides enum member 'scrrun.dll;Scripting.___MIDL___MIDL_itf_scrrun_0000_0000_0001.N
> **Rubberduck version information**
Version 2.4.0.4618
OS: Microsoft Windows NT 10.0.17763.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11425.20140
Host Executable: WINWORD.EXE

**Description**
If the contents of Code Inspector are dumped into a text editor then the sequence of items in the text editor does not match the sequence as presented in the Code Inspection Window View.

The text editor I used was Notepad++.

This is a minor slightly irritating issue but as i
 
8:03 AM
> **Rubberduck version information**

Version 2.4.0.4618
OS: Microsoft Windows NT 10.0.17763.0, x64
Host Product: Microsoft Office x64
Host Version: 16.0.11425.20140
Host Executable: WINWORD.EXE

I have an inspection warning

Object Variable assignment requires 'Set' Keyword (281) results.

Its doesn't appear to be possible to expand this item so I can't investigate what is causing the problem. The code in question compiles without any issues.
Now I could allow Rubberduck to Fix t
 
8:18 AM
> Is only Normal only the name of the file or also the name of the VBA project (as shown in the VBE)?
> Is Normal only the name of the file or also the name of the VBA project (as shown in the VBE)?
> As far as I can tell it is just the file

![Normal](https://user-images.githubusercontent.com/24568897/54740399-314efc80-4bb3-11e9-923f-107e6f40eddb.jpg)
> I tried to implement fix all occurences but this highlighted something odd.

If I refresh RubberDuck and select the 'Set' error message above I don't get any messages at the foot of the window.

If I click on another message 'Function is not used' I get the appropriate information about why the error is flagged and possible options to fix the problem

If I then go back to the ' Set' error message , the ' Function not used' warning is not cleared (hence my thinking I could 'fix' all occu
 
 
1 hour later…
10:05 AM
0
Q: Stop flickering / refactor code for Excel ScreenUpdating false on Copy Paste to another worksheet

PoetoeI am beginner and still learn about programming on macro VBA excel. I need help from community to solve my problem on macro code on excel Sub export_data() With Application .ScreenUpdating = False .Calculation = xlManual 'sometimes excel calculates values before saving files End Wit...

 
10:38 AM
> Based on your screenshot the project name is `Normal`. Consequently, the inspection result is correct. Inside this project the identifier `Normal` will refer to the project instead of the enum member `FileAttribute.Normal` from the `Scripting` library.

However, the identifier name returned as part of the result is not the expected one. It seems to show the actual name from the type library instead of the user-facing one exposed in the object browser.
 
 
1 hour later…
11:58 AM
Hi guys
I'm doing a "quick project" to modify an existing VB6 program to have a different approach for selecting files from a form.

After 2 days I've finally remade the functions to be VB.NET compatible and it works. :)
But I noticed that it takes 10 minutes to finish...

The only thing it's doing is to "look at string within 1st cell on each row and modify it to another string" for 3100 rows...

I think it should take like 2 seconds. Not 10 minutes. Any idea how to speed it up?
It's not my code.
I know VBA has something like "disable recomputing on each change" but I don't seem to find it for VB.NET.
 
 
1 hour later…
1:23 PM
> I've used the most excellent "Clean Project" feature many times with success but this time I accidentally initiated Clean Project while in break mode. As a result my project now has twice the number of modules and classes with, for each existing module or class, another like component exists in the project with with a name of "Module1", for instance, or "Class1" where the "1" increments for each component.
At the moment it seems I'm screwed (will have lost an hours work) in that I cannot ope
 
@Duga Does another clean fix it?
 
1:48 PM
> The original issue - grouped inspections - is a known and old and irritating issue, therefore a dupe, but I can't find the/an older one.

Not sure about what you've got in the 2nd issue
 
@QuackExchange Beginner indeed! GoTo!
 
@Duga What is 'Clean Project`?
 
> Methinks this should be in the MZtools forum. Not rubberduck.
 
2:12 PM
@Duga Ha. Another bug for MZtools
 
2:29 PM
@M.Doerner I was wondering what I'd missed...
 
 
1 hour later…
3:35 PM
> Considering that Rubberduck does not have a "Clean Project" feature, I'd say this is not in the right place...
> Issues around aggregated inspection results are mostly quite aged by now.. I'm not even sure all of these still apply, but we currently have open the issues: #4561, #3597, #3172 and #2900. There is probably some overlap between these...
 
@Duga Used the wrong link.
 
 
2 hours later…
5:44 PM
0
Q: Optimization of VBA Code (loops)

DanI've added a timer to my code and the bottleneck comes when I'm looping through 47 rows and inputting data from a dictionary that I previously loaded with values. Since i use these files for a lot of different things I've set up public variables in order to avoid setting them up for every new co...

 
 
2 hours later…
8:09 PM
im having a dumb dumb
i am attempting to execute a parameterized query
but its telling me
"You tried to assign the Null value to a variable that is not a Variant data type."
but when i dump the parameter values... nothing is null
wat
 
 
1 hour later…
9:11 PM
Its so bizarre, no one is here.
 
9:34 PM
> Oooff, sorry. I thought CP was your great would.

Thanks

On Thu, Mar 21, 2019, 10:01 AM Freeflow <notifications@github.com> wrote:

> Methinks this should be in the MZtools forum. Not rubberduck.
>
> —
> You are receiving this because you authored the thread.
> Reply to this email directly, view it on GitHub
> <https://github.com/rubberduck-vba/Rubberduck/issues/4871#issuecomment-475240281>,
> or mute the thread
> <https://github.com/notifications/unsubscribe-auth/AM6nzubsDlIpcZWzZTe1qgvqpAn
 
10:07 PM
@QuackExchange Had to fill in for Mug while he's on his vacation.
 
10:30 PM
@IvenBach that's half a blog post...
 
10:53 PM
I tried...
My writing's not the best and I have to get better at it somehow.
 
It was intended as a compliment :)
 
I accept it.
I'm working on understanding C# to one day be able to do the same.
I'm breaking myself of a "think in Excel" mentality.
 
11:15 PM
@Vogel612 I ended up including so much because I remember past-Iven WTFing so hard over trying to figure stuff out. That's why I included images to make it easier as that's what really connected a lot of dots for me.
 
@IvenBach Time for me to connect the dots of WTH my PR has failing tests
 

« first day (1749 days earlier)      last day (214 days later) »