VBA Rubberducking

« first day (297 days earlier) ← previous day next day → last day (2883 days later) »

Duga

12:00 AM

RELOAD!

[rolfl/MicroBench] 3 commits.

Mat's Mug

@Duga Uh, wtf?

Mat's Mug

12:23 AM

@SimonAndréForsberg nice!! About time! ;)

Duga

12:55 AM

[retailcoder/Rubberduck] retailcoder opened issue #353: Renaming an interface breaks implementations

> Consider an `IView` interface specifying a `Show` member:

Public Sub Show()
End Sub

An implementing class would have a method like this:

Implements IView

Public Sub IView_Show()
End Sub

So, renaming `IView` to `ISomethingElse` would result in this implementation:

Implements ISomethingElse

Public Sub IView_Show()
End Sub

...which breaks the code.

[retailcoder/Rubberduck] retailcoder added label bug to issue #353: Renaming an interface breaks implementations

[retailcoder/Rubberduck] retailcoder added label refactorings to issue #353: Renaming an interface breaks implementations

3 hours later…

Stack Exchange

3:33 AM

Q: VBA find function too slow, faster method possible?

In column A, I have many strings ~ 32000 cells each containing unique string values. I then have columns C to as many as 30/40 columns which all contain approximately 400 rows of text. •Check column (j) for any text not present in column A •If true then add new string to column A •Run comparison...

3 hours later…

Mat's Mug

6:22 AM

ObsoleteCallStatementInspection is broken. FML.

like, what else is broken????

ugh

TTGTB

4 hours later…

RubberDuck

10:31 AM

Yikes @StackExchange! Can anyone say "follow up required"?

Simon André Forsberg

11:21 AM

@Mat'sMug daylight-savings-time. Had to adjust @Duga's schedule to compensate for that, as UTC does not use DST but @Duga do.

1 hour later…

Mat's Mug

12:23 PM

Abstraction. The difference between a cryptic script and maintainable program. You need to understand that there is no difference as far as running the code is concerned - you could be writing it in assembly, wouldn't make a difference. But abstractions make code human-readable and therefore easier to work with. Functions/procedures should do as little as possible; you have a "god method" here, that knows everything. Also, how do you know the Find is your bottleneck? My experience has been that the biggest bottleneck is writing to cells in a loop. — Mat's Mug 14 secs ago

RubberDuck

@Mat'sMug Yeah. I really doubt Find is the bottleneck..

1 hour later…

Mat's Mug

1:41 PM

> 51+22 downloads

@RubberDuck I found major regression issues with code inspections while revieweing that code.

Putting the new features on ice, gotta fix those - we can't release with broken inspections!

RubberDuck

I saw. Let me know if you need a hand, but work on my end will be slow going this week.

Mat's Mug

Just edited my answer with 1.2's inspection results

My current build found 73 issues; most are false positives

RubberDuck

Ouch. What happened? Is the grammar broken, or did changing the grammar break the inspections?

Mat's Mug

Not sure. Grammar seems to pick stuff up correctly.

But the new Declarations listener seems to be missing things. Fixing this will also make the rename refactoring work better.

I don't understand how ObsoleteCallStatementInspection broke.

skiwi

1:57 PM

@Mat'sMug Magic

RubberDuck

@skiwi black magic.

Mat's Mug

2:23 PM

I smell a soon-deleted SO question:

Does your code compile? — Mat's Mug 1 min ago

Strikes you as elegant, strikes me as "WTF". — Mat's Mug 20 secs ago

> marked as duplicate by Jean-François Corbett, RubberDuck, Mat's Mug, Community♦ 23 secs ago

that bot is sentient.

It's non-standard, and feels like a hack that's abusing what Select...Case is intended to do. It might be just me, but I prefer my Select...Case not to read backwards (i.e. with the condition where it's meant to be, not in each case branch). — Mat's Mug 48 secs ago

RubberDuck

3:01 PM

Yeah green checky on SO. =)

Mat's Mug

grats!

RubberDuck

Factory Class FTW.

3 hours later…

Mat's Mug

6:05 PM

> 53+22 downloads - 75 total!

we'll be at 100 by 1.3's release...

RubberDuck

6:18 PM

We're above and beyond upgrades then. =)

Mat's Mug

well x86 1.21 was 65 downloads, so not really

skiwi

How 'difficult' is it to update?

RubberDuck

Point taken.

@skiwi Point & click.

It's not.

Mat's Mug

well if you're not following @rubberduckvba or paying rubberduck-vba.com a regular visit, it's a bit harder to keep up ;)

skiwi

I mean for IntelliJ I need to reinstall the entire thing for an update...

I won't be updating for some time!

RubberDuck

6:26 PM

I fixed that between 1.0 and 1.1 I believe.

Mat's Mug

and I broke it with 1.21 x64 ;)

1 hour later…

Phrancis

7:55 PM

Monking

Mat's Mug

hi!

hey @PetLahev!

1 hour later…

Phrancis

9:08 PM

You know the other day when I had 863 records to cancel and it took like 30 minutes?

Now I have to cancel 2300 more! GROAN

Mat's Mug

9:49 PM

ouch

Phrancis

I'll get with my DBA tomorrow and see if it can be done via the SQL DB directly... Hate to sit here for like 2 hours watching this stupid scroll bar

Stack Exchange

10:39 PM

Q: Excel VBA - Code Optimization copy data to another worksheet

I have the following but it takes long time to run, it is a simple wherein the user select a file and data from Sheet1 is copied to another workbook. Sub ImportApp(ByVal filepath_Report As String, file_name1 As String, wsOutput As Worksheet) Application.ScreenUpdating = False Set wbReport = Work...