VBA Rubberducking

Phrancis

00:24

Damn, sounds like a shit load of snow, @Mug

Mat's Mug

nah, just ~10cm of wet white crap

RubberDuck

People in Georgia be like "It's the Snowpocolypse!"

Mat's Mug

lol

That was Buffalo a few weeks ago!

RubberDuck

Okay.... Yeah. That was legit though.

My buddy lives there. I got pictures.... crazy.

Mat's Mug

00:40

2 meters... never seen that. Crazy indeed

RubberDuck

We got snow like that when I was kid. Like two winters in a row.

Mat's Mug

Most I've seen was 2007-2008, we had almost 2 meters.... for the whole winter!

It beat the 1971 record

@RubberDuck what was that question mark for?

Phrancis

@Mat'sMug I remember hearing from family that it was really bad that season

Mat's Mug

"La tempête du siècle"

Phrancis

@RubberDuck Didn't think Ohio got much snow. I know here in Indiana we barely ever get any. And when we do... panic!

(especially if you're the one Canadian on the road who knows how to drive in snow)

RubberDuck

00:46

2 hours ago, by Mat's Mug

I've updated R1 to "pre-release"

Wasn't sure what that meant.

Mat's Mug

Ah, it's no longer listed as a "release", rather a "pre-release" like the others :)

RubberDuck

Oh. Ooops. Sorry.

Mat's Mug

And @Phrancis - spot on! I always find it funny when I see Americans panic over 1-2 cm of snow.. mind you, you guys aren't really equipped for it either

@RubberDuck np. It bothered me to see it labeled "latest version" ;)

Phrancis

Americans make it sound worse than it is. Mostly those soccer moms and rednecks driving around in their SUV or pickup truck who don't understand the concept of a speed limit.

RubberDuck

posting a CR later tonight Mug.

Mat's Mug

00:51

Great!

Phrancis

I can drive in 1-2 cm of snow in my 83 Capri just fine, and that's possibly the worst vehicle to drive in the snow

Mat's Mug

Try with slicks

Phrancis

That... would be a bit tricky ;-)

RubberDuck

Here's a hint.

[ComVisible(false)]
public interface IHostApplication
{
    void Run(string target);
    long TimedMethodCall(string projectName, string moduleName, string methodName);
}

Mat's Mug

Yes!!

RubberDuck

00:53

My wife just got home. bbl

Mat's Mug

lol! Later ducky!

Phrancis

Later man

@Mat'sMug We should have a beer next time I make my way up there around Montreal. You sound like a fun guy to have a beer with!

Mat's Mug

Sure!

Phrancis

I just found out on Monday my brother is moving from Quebec to Montreal. He works for Ubisoft (bastard)

Mat's Mug

Woah nice! Top-notch studio of the video gaming industry!

Phrancis

00:57

Yeah, I think he got to work on some Assassin's Creed and such

Mat's Mug

Probably. But he can't talk I guess :)

Phrancis

I can't imagine how much freaking code has to go into a game like that. WOW.

I heard that lua is pretty popular for videogames

Mat's Mug

I thought it was still all/mostly C++

Phrancis

We considered it for Cardshifter, but I think it's going to be mostly Java now

Mat's Mug

Because Simon says ;)

Phrancis

01:02

May be so. There's something special about the way Lua handles data-related stuff, I think it's mostly being used as an alternative to XML and DBMS

Mat's Mug

Hmm

Gotta handle the kids.. bbl :)

Phrancis

Have fun!

RubberDuck

And there's the popular question badge. I can quit programmers now.

Phrancis

Did you award the bounty?

RubberDuck

Nah. There's 5 days left.

Phrancis

01:12

in The 2nd Monitor, 6 mins ago, by Phrancis

Hello. I think this question would be better fit for DBA.StackExchange. It will likely get closed as off-topic here, as there is no code to review. — Phrancis 44 secs ago

Need some VTC, looks like everyone's AFK next door :)

Approach (3) on there is actually pretty close to what we have in mind for game stats and replays on Cardshifter. Seems best to me, anyways

Mat's Mug

01:36

@RubberDuck wut, you have another bounty up??

RubberDuck

Rewarding an answer on programmers.

@Phrancis VTC'd.

RubberDuck

02:03

0

Q: Drying Up Very Similar Implementations of an Interface

Work continues on the Rubberduck VBA Editor Add-in. I have a need to call some VBA code from the add-in with Application.Run. Unfortunately, the Application part of that refers to the particular Office Application that is hosting the VBA editor. So, if I'm working in Excel, Application refers to ...

Phrancis

Awesome comment...

    var stopwatch = Stopwatch.StartNew();
    //access supports only single project; I would think it could handle Module.Procedure syntax, but it blows up with a com exception if I try.
    _application.Run(methodName);

RubberDuck

haha thanks.

Figured it'd save Mr. Maintainer a headache down the line.

Mat's Mug

(cough) thanks!

Phrancis

That's a kind thought :)

RubberDuck

=;)-

Mat's Mug

02:11

now what if you have Module1.Method1 and Module2.Method1?

Phrancis

Blows up?

RubberDuck

Honestly haven't tried it yet.

Plausible deniability?

2

Mat's Mug

easy enough: test explorer > new test module > new test method; new test module > new test method; run all tests > brace for exploding rubberduck

RubberDuck

Exploding Rubberduck

Mat's Mug

lol

Phrancis

02:16

Exploding ~~bear~~ duck traps...

RubberDuck

hahahahahahahahahaha..... oh that's rich buddy.

> If you are calling a procedure in another database use the project name and the procedure name separated by a dot in the form: "projectname.procedurename".

Access Application.Run

Mat's Mug

huh?

RubberDuck

Yeah. Exactly

Mat's Mug

not sure I get it

> (As a side-note: Scala would offer you structural typing in that case, which AFAIK will use reflection internally.)

wtf, Scala?

rest of answer works though.. but please don't put Abstract in abstract class names... Base suffix is well enough

I deleted my draft

one thing though

I think TimedMethodCall should return a TimeSpan - and yes, that's my bad ;)

RubberDuck

02:38

This looks to be exactly what I'm looking for, but what does Scala have to do with it? We're developing this in C#... — RubberDuck 2 mins ago

@Mat'sMug Eh, call it out so I don't forget.

Mat's Mug

#108 is all yours! :)

Mat's Mug

02:55

@ticker oh come on! RTFM!

RubberDuck

Link?

Phrancis

-1

Q: set a cell values with 0 at left vba

Im trying to introduce a value like "0001" to a cell with vba but all I set is 1 with no 000 this is my code Dim iRow As Long Dim ws As Worksheet: Set ws = Worksheets(BD_PRODXSIST) With ws .Range("A" & iRow).Value = "0001" End With Set ws = Nothing

excel vba excel-vba cell-formatting

@RubberDuck ^

Mat's Mug

^^ my downvote

RubberDuck

Isn't Value2 also an option?

Mat's Mug

depending on what's actually needed, I'll go either for the apostrophe (if it needs to be text), or a cell format (if it needs to be numeric)

RubberDuck

03:06

I was thinking of .Text, but it's read only.

@Mat'sMug I added a link to the PIAs on the Build/Install page of the wiki. Figured it'd prove useful.

Mat's Mug

great!

RubberDuck

And I'm just going to open an issue on the access thing. There's no way to fix it, so I'll just flag it won't fix and write something up.

Mat's Mug

@RubberDuck any idea how I can have an icon with a caption, without having a button.. on a CommandBar?

RubberDuck

Hmmmmm not something I ever thought about.

Short answer is no. No idea.

I mean, everything on the command bar is a control.

Mat's Mug

yeah, but I can't create a Label just like that...

BTW I'm making Menu.SetButtonImage public and static

@Phrancis lol

Phrancis

03:25

Wrong room :)

Althought, FFVI for iOS is freaking awesome

Mat's Mug

that's US III?

Phrancis

Yup

Mat's Mug

of course it's awesome!

RubberDuck

For iOS?

Ohhhhh gimme gimme gimme

Phrancis

They also have it for Android

Mat's Mug

03:27

$15 or so?

I think I saw it when I bought FF1

Phrancis

Something like that, yes

The graphics revamp on FFVI is awesome. Then add quicksave and other features

Entering Zozo now... weird place

Mat's Mug

(zozo song playing in my head now)

ugh

not exactly what I had in mind

I think I'll go with FaceId's for the toolbar... but damn inconsistent icons will get on my nerves

Phrancis

@Mat'sMug ^

Mat's Mug

^^ NOT!!

I think I like the SNES characters better

Phrancis

I got over nostalgia real quickly

RubberDuck

03:42

Oh wow

Mat's Mug

not too bad...

Phrancis

@Mat'sMug ^

Mat's Mug

memories...

Phrancis

03:58

Yeah... About to go to the Opera House, I think. Celes' shining moment

"You're an esper!?"

Mat's Mug

an yet another encounter with the evil octopus

> Tentacle

Phrancis

That bastard

It plays really good on touchscreen, @Mat'sMug - If you have a device and a little time to spare, I really recommend picking it up

> Fucking tentacle

Mat's Mug

IIRC he turns your PC's into imps too

Phrancis

04:14

If they're alive afterwards, they may turn into imps. That would be the least of my worries, if they are still alive ;-)

Mat's Mug

@ticker dynamic UI in VBA? hmm..

Mat's Mug

04:35

^^ getting there...

Mat's Mug

04:46

@RubberDuck pushed to master

RubberDuck

Ohhhhhh what goodies do we have now?

Oh that's cool.

Adding Unit Test support for Office Apps is this easy now.

    [ComVisible(false)]
    public class ExcelApp : HostApplicationBase<Excel.Application>
    {
        public ExcelApp() : base("Excel") { }

        public override void Run(string target)
        {
            base._application.Run(target);
        }

        protected override string GenerateFullyQualifiedName(string projectName, string moduleName, string methodName)
        {
            return string.Concat(projectName, ".", moduleName, ".", methodName);
        }
    }

Mat's Mug

Nice!

RubberDuck

Yeah. New guy hooked me up.

(So I fixed the code he posted....)

Phrancis

@Mat'sMug I messed on first try (as expected) but this is what it looks like

Mat's Mug

THEY CHANGED THE LYRICS!!

or.. you messed up???? how could you?!!!

Phrancis

04:59

A little of both

Mat's Mug

lol

Phrancis

They changed the lyrics a bit. I also haven't played this much since I was a teenager

Mat's Mug

if you mess up the opera, wait till the dinner with the emperor! (a worse place to F-up, if you ask me!)

Phrancis

Seems like they shortened the time limit. Failed 3 times so far.

Mat's Mug

was 4 minutes IIRC

and it's not supposed to be easy ;)

RubberDuck

05:05

Just pushed @Mat'sMug. Let me know when you get the PIAs installed so I can merge. Heading to bed.

Phrancis

Oh wait, if you pause it keeps counting down. Wtf.

Mat's Mug

good night! I'll just finish this VariableTypeNotDeclaredInspection implementation and then I'll merge - but you can still go ahead and merge @RubberDuck, I'm working in the CodeInspections branch :)

@Phrancis that's to "penalize" you for using items and magic to replenish yourself between fights!

Phrancis

Wait... I just "powered" through it and it still didn't let me complete it... wtf.

@Mat'sMug There are not even fights, it's just singing and dancing. Pick the right lyrics, move to the right place to dance... meh. Try again, I guess.

Mat's Mug

huh? so how does the 1-ton thing gets dropped on stage and the fight with Ultros begin then?

maybe I'm mixing things up

it's been a little while ;)

Phrancis

I'm just not there yet, I'm at the opera performance just before :)

Mat's Mug

05:16

ah

Phrancis

Seems to timeout way quicker than it used to, either a bug or on purpose

Guess I need to just hurry the f*** up, hopefully that works

Phrancis

05:48

Meh, just had to hurry the hell up

Mat's Mug

^^ there's still a "bug" with the selection though

#dammit

Phrancis

@Mat'sMug ^ imp'd

Mat's Mug

06:03

lol

Phrancis

Fucker

Mat's Mug

TTGTB - good luck!

Phrancis

Bonne nuit :)

RubberDuck

15:06

crickets

Phrancis

15:19

Monking

RubberDuck

Hey @Phrancis

Mat's Mug

15:39

monking!

RubberDuck

hEY mUG.

Opps. SQL CASE

Mat's Mug

cAPS iSSUE

lol

RubberDuck

@ticker's slow today.

And I'm feeling unmotivated.

WAKE UP @TICKER!

Mat's Mug

15:56

@RubberDuck I don't think he/it heard you :/

RubberDuck

haha must not have.

RubberDuck

16:10

in The 2nd Monitor, 54 secs ago, by Malachi

Why do java programmers have to wear glasses?

Because they don't see sharp.

Mat's Mug

16:26

@RubberDuck TICKER!! You're up!

booo

Phrancis

That's a pretty crappy question

Stack Exchange

0

Q: Code Reliability, Building an OPC client in excel

This is my first question on here, so bare with me. I am pretty deep into building a very multi-faceted little app in excel with VBA. It does a number of tasks all centered around using OPC to get tag values from several PLC's and doing various things with the info, like publishing a webpage (u...

excel vba

Mat's Mug

16:41

Hi @StackExchange!

Phrancis

I'm browsing random SE sites and found this gem on Bitcoin.SE

"What do you mean? Pay who? – Nick ODell" Go away little man, I'm not interested in playing your little games. — Simon 21 hours ago

Mat's Mug

have I just stuck a foot in my mouth here?

Why not integrate the data from these CSV files then? Seems like a much simpler approach than trying to programmatically extract data out of a pivot table - SSIS/Informatica is going to do a better job at it anyway ;) — retailcoder 7 mins ago

60M rows...

Phrancis

Extracting data programmatically out of a pivot table... is... Goofy, at best? Pivot tables are intended for humans, not machines...

Mat's Mug

^^ my thoughts exactly

Mat's Mug

17:21

1

Q: Calculating Due Dates based on Frequency using VBA

So, right now I have this Excel sheet where there is a last revision date. I have named this column "LastRevisionDate". And then I have a column named "RevisionFrequency" . The "RevisionFrequency" contains a drop-down menu (data validation) consisting of terms, Annually, Semi-Annually, and Quarte...

excel vba excel-vba format

RubberDuck

Hi! Welcome to Code Review! You've spit out a lot of acronyms at us. Could you explain what an OPC and PLC is? — RubberDuck 9 secs ago

Mat's Mug

In Quebec OPC would be "Au Plus Crisse" (ASAFP)

Phrancis

Haven't heard that in a long time!

Using Google-Fu is was able to determine OPC is OLE for Process Control and PLC appears to be a Programmable Logic Controller — Phrancis 14 secs ago

@RubberDuck ^

RubberDuck

Nice. Thanks @Phrancis.

#112 Unit Testing to Support All Major Office Applications help-wanted

Phrancis

18:03

@Mat'sMug :

0

Q: Ingredient selection for Canadian Poutine dish

Poutine is a simple dish traditionally from Québec, Canada. It is traditionally made with French fries, topped with fresh mild white cheddar curds (quite unlike American white cheddar which is quite sharp) and with a tangy and salty brown gravy poured on top of it all. It looks something like thi...

ingredient-selection gravy

Mat's Mug

19:44

@Phrancis when you're in Montreal, we'll have a poutine with that beer!

Phrancis

@Mat'sMug That sounds awesome!

RubberDuck

It's still only useful to download chrome... =;)-

2

Malachi

@RubberDuck does this work on Open Office Apps?

RubberDuck

Probably not.

More than likely not.

Malachi

lol

didn't think so. I don't have office at home....

find me a way to hack office 2010 license and I will have it on one of my home machines at the least....lol

Phrancis

19:56

@Malachi Dude even I have MS Office at home, and I'm not a Mac. Get with the program ;-)

2

Malachi

I don't need it with things like Google Drive and Open Office

it saves me like $100 when buying a computer... at least

RubberDuck

Open Office is okay if you don't want to shell out for MS Office, but I can't deal with the way their IDE works. Not sure if the new project is better or not. Haven't tried it.

Mat's Mug

I installed Open Office once. About a week before I decided to spend a little bit to get Office 2010 Home. Living a happy life since.

Transcript for