VBA Rubberducking

« first day (234 days earlier) ← previous day next day → last day (2946 days later) »

RubberDuck

00:04

Nice!

5 hours later…

Duga

04:58

[retailcoder/Rubberduck] retailcoder pushed commit c209b1d1 to LexicalTokens

> added ConstDeclarationNode, refactored/renamed VariableNode to DeclaredIdentifierNode.

9 hours later…

RubberDuck

14:27

Okay. I've got a big wtf this morning.

It seems that this is case sensitive, but it shouldn't be and I can't find anything that says it is.

Dim fso As FileSystemObject
fso.CopyFile "\\Server\Share\Path\to\source.ext" "C:\path\to\destination.ext"

Tells me the file doesn't exist if the name is named "Source.ext"....

Mat's Mug

15:10

It's possible FSO is case-sensitive. Try native VBA functions, I don't think these are.

FileCopy

RubberDuck

I mean, it's okay. I'm just shocked.

And I can't find any docs calling out this behavior. Hell.... I can't find anything on the net calling out this behavior.

Mat's Mug

interesting

VBA: the language you never completely learn even after a decade of abuse

1 hour later…

Phrancis

16:37

My only experience with referencing files is with HTML, and it's always been case-sensitive, I'm not surprised VBA would be like this too...?

RubberDuck

What's weird @Phrancis is that fso.FileExists() isn't case sensitive.

Phrancis

Well that is uncanny.

Chrismas007

Morning all

might not be very active over the next 2 weeks.

Just put in my notice this morning

Headed to new adventures

Phrancis

@Chrismas007 Sometimes one needs to just go and move on to new things... Best of luck!

RubberDuck

16:52

@Chrismas007 Congratulations!

Does anyone know what the hell this OP is talking about?

Q: Is there a way to programatically enable the Microsoft Scripting Runtime when opening a PPT Presentation?

I have a PPT using VBA and it requires the Microsoft Scripting Runtime be enabled. I have some customers that are not tech savvy and may not be able to follow the instructions I placed on a banner in the opening slide to enable it. Is there a way to do it programatically when the presentation o...

Mat's Mug

@RubberDuck Option Compare Text?

RubberDuck

@Mat'sMug Oh shit. Maybe.

in The 2nd Monitor, 13 secs ago, by RubberDuck

@Malachi does Option Compare Text work in vbscript?

Chrismas007

Thanks @Phrancis and @RubberDuck

Duga

[retailcoder/Rubberduck] ckuhn203 pushed commit 2e994774 to source_control

> abstracted SourceControlProviderBase

RubberDuck

@Duga Now I'm on track.

Mat's Mug

17:10

@Mat'sMug My notepad++ counts the word class 214 times here. Will you be implementing 214 Node classes? Are there scenarios where you can reuse the same node class? — Bruno Costa 2 hours ago

I didn't need to know this.... now I'm depressed!

RubberDuck

17:28

How do you eat an elephant @Mat'sMug?

> One bite at a time

Mat's Mug

17:52

IKR

Actually, a whole bunch of them are going to be InvocationNodes - method/function calls. I don't need a BeepNode...

RubberDuck

Why wouldn't you want a BeepNode? LOL

Mat's Mug

18:11

@RubberDuck Because I'm a lazy ass programmer that doesn't want to implement 200 classes :)

Duga

18:57

[retailcoder/Rubberduck] ckuhn203 pushed commit c5eba0e2 to source_control

> flushing out SourceControlProvider interface & implementation

Mat's Mug

19:11

@Duga interesting..

RubberDuck

It's still a mess, but it's coming together.

Duga

[retailcoder/Rubberduck] ckuhn203 pushed commit ed3781d8 to source_control

> DRYd up obnoxious using statements

Phrancis

@RubberDuck You feeling that bitter cold front yet?

RubberDuck

@Phrancis I'm stuck in Ohio when I should be on my way to PA...

Phrancis

19:26

Chrismas007

stackoverflow.com/tags/vba/synonyms

Still need 1 vote each

Duga

[retailcoder/Rubberduck] ckuhn203 pushed commit bc6a611a to source_control

> implemented Undo

Mat's Mug

@Duga Oh, that's pretty awesome!

Duga

20:18

[retailcoder/Rubberduck] ckuhn203 pushed commit 252c1539 to source_control

> procrastinating real work on this...sorry for the bad message...

RubberDuck

20:31

> Separate question, is there a quick and dirty way to reset your workbook back to a certain "saved state"? Thank you.

Yeah. Start using source control. Unfortunately, the DevTools module in that repo is a bit busted right now, and I've not had time to fix it because I'm working on Integrating the VBA Editor with Git. You can watch the Rubberduck repo to get updates on that. — RubberDuck 6 mins ago

Mat's Mug

20:50

@Duga waiting for a star...

Chrismas007

21:29

Q: Embedding local shiny web application into Excel file

I've tried to embed shiny page into Excel using Excel Microsoft Web Control, buttons, text etc. was displayed correctly, but no plot have been displayed, that not suprised me because of Web Socket issue with IE7/8 on which Microsoft Web Control is based. I wonder if there is any other way to dire...

r excel vba webbrowser-control shiny

A vba with a bounty? What is this madness?

Duga

21:48

@Mat'sMug on what

RubberDuck

@Duga Good question.

Chrismas007

22:03

Q: Sort Contacts Marked As Company

I found an aaplescript at apple's support site to sort any contact with the "Company" checkmark checked into a "Business" group: property groupName : "Business" tell application "Contacts" if (name of groups as list) does not contain groupName then make new group at end of groups wit...