VBA Rubberducking

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

Duga

00:00

RELOAD!

[rolfl/MicroBench] 3 commits.

Mat's Mug

@Duga Uh, wtf?

Mat's Mug

00:23

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

Duga

00:55

[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

03:33

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

06:22

ObsoleteCallStatementInspection is broken. FML.

like, what else is broken????

ugh

TTGTB

4 hours later…

RubberDuck

10:31

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

Simon André Forsberg

11:21

@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

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

13:41

> 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

13:57

@Mat'sMug Magic

RubberDuck

@skiwi black magic.

Mat's Mug

14:23

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

15:01

Yeah green checky on SO. =)

Mat's Mug

grats!

RubberDuck

Factory Class FTW.

3 hours later…

Mat's Mug

18:05

> 53+22 downloads - 75 total!

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

RubberDuck

18:18

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

18:26

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

19:55

Monking

Mat's Mug

hi!

hey @PetLahev!

1 hour later…

Phrancis

21:08

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

21:49

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

22:39

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...