VBA Rubberducking

« first day (1683 days earlier) ← previous day next day → last day (1497 days later) »

9:15 PM

"Simple" as in "spoon-feed me with some code I can copy-pasta into my VBA editor and walk away with a working multi-threaded solution"? Nope, there isn't. — Mathieu Guindon 27 secs ago

Comintern

If you think the .NET solution is "complex", then any VBA solution is going to completely redefine your definition of "complex"... — Comintern 6 secs ago

Mathieu Guindon

^ 100x

IOW the whole code dump is irrelevant and that's a discussion forum post

or the whole code dump is what the OP is asking SO to "make MT"

Comintern

Not to mention that I linked to a working solution...

Mathieu Guindon

VBA in Excel is inherently single-threaded - any MT solution is going to be a rather complicated hack involving VBScript or some other means of executing VBScript/VBA code out-of-process, and somehow synchronizing it back into one place. Or, a complete rewrite in .NET code that offloads the HTTP requests to background threads, and synchronizes the results back onto the main/UI thread to write the output to Excel or yield it to some VBA code. There is no "simple" solution for this, other than using the right tools for the job - VBA was never really meant to do massive-scale web-scraping. — Mathieu Guindon 22 secs ago

VTC+move on...

FreeMan

9:35 PM

I made a functional suggestion.

Comintern

Hire a bunch of workers in SouthEast Asia. Have them run your queries and add them to a shared workbook. No code required, and doesn't violate Google's ToS.

Hosch250

Google's ToS is there to be violated.

OK, now I have a really good idea.

I'll set up a website with the ToS that Google's bot can't link to it.

Mathieu Guindon

wrap Google search with an API? bad idea.

Comintern

Provision a bunch of servers on Amazon and run your code on all of them?

Hosch250

When I find that site on Google's index, I'll sue them.

Mathieu Guindon

9:40 PM

uh-huh

Comintern

I think they might be able to outspend you on legal fees.

Mathieu Guindon

isn't that already handled by robots.txt or something?

Hosch250

@MathieuGuindon It is, but that's not a legal requirement.

@Comintern Probably.

IvenBach

~~Probably~~ Guaranteed.

Knowing more has allowed me to see the shores of "Excel shall not go there". As well as all the people are trying to drag their boats across that poor coral reef.

KySoto

10:06 PM

Hosch250

LOL!

KySoto

my co-worker sent me that

and im like... a-yup

Hosch250

I've never gotten around to setting up assembly, but I've worked with it a bit.

Mathieu Guindon

the funny thing is that there's a photograph that's also on the track, seeing what's coming

KySoto

ive... viewed it

Hosch250

10:08 PM

As in, I've had to read programs for school.

Mathieu Guindon

#meta

KySoto

actually, that reminds me of this one thing i found

Mathieu Guindon

(train is likely just parked at the dock though)

Hosch250

@MathieuGuindon They have lights on the front when they are running.

Mathieu Guindon

(or headed in the other direction)

Hosch250

10:08 PM

I don't even think that train is turned on.

KySoto

bayfronttechnologies.com/mc_tutorial.html

i never finished it

but its a bit over my head

Hosch250

Heck, I wonder if that track is even used, considering the weeds.

Most tracks in use are regularly sprayed, or something. They never have that many weeds.

That might be a museum.

Comintern

Do they actually spray them? I'd always assumed there was so much crap that had leaked from passing trains (oil, coal dust, etc.) that nothing would grow there.

I don't think I've ever seen a maintenance crew doing weed control.

IvenBach

A refactoring is a change that is intended to make the code perform better or to make the code easier to understand. It is not intended to alter the behavior of the code, and therefore the tests are not changed.

We recommend that you perform refactoring steps separately from steps that extend functionality. Keeping the tests unchanged gives you confidence that you have not accidentally introduced bugs while refactoring.

Why couldn't I have found that when I first tried unit tests? I could have but I wouldn't have understood or appreciated what its saying. docs.microsoft.com/en-us/visualstudio/test/…

1 hour later…

Duga

11:44 PM

[rubberduck-vba/Rubberduck] DiogoRNeves created comment on issue #2252: uninstall new version RubberDuck reinstall old version fails

> That worked like a charm! Thank you! Everything is back up and running!

Mathieu Guindon

Ugh. Spent the better part of last month writing a small WPF CRUD app, having constant issues with DataGrid columns not being part of the visual tree. Gotta love XAML. cc @this, you were right all along, my life is a nightmare and I'm so far down the damn rabbit hole I'll never get out of it and I ... screw it, tonight I'm working on RD.

Duga

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #2252: uninstall new version RubberDuck reinstall old version fails

> @DiogoRNeves awesome! Sorry for the troubles, ....this version should update without any issues when you're ready to update to a newer build.

Mathieu Guindon

Some SCP whack-a-mole bug-hunting should help with the mood...

Comintern

I know the feeling. My last "quick" CRUD app with a DataGrid turned into a rabbit hole as soon as I got the change request to allow zoom-in...