VBA Rubberducking

Duga

12:01 AM

RELOAD!

[rubberduck-vba/Rubberduck] 3 commits. 2 closed issues. 3 issue comments. 22 additions. 23 deletions.

[Minesweeper] Games Played: 121, Bombs Used: 71, Moves Performed: 15602, New Users: 11

FreeMan

12:02 PM

Anyone use Azure Boards?

Considering it for my team of me (oh, and the other guy...) for both coding & non-coding tasks.

I'm sure it's massively overkill for that, but since we're moving to Teams and it integrates and we really don't have anything else at the moment, it might be reasonable.

Could, of course, use a private GH repo, but not everything is coding/code based.

FreeMan

12:22 PM

Oh, and I see that AB integrates with GH. Of course, MS bought GH...

mansellan

12:52 PM

Yep our team uses Azure Boards, works really well and has a decent selection of extensions available in its marketplace.

Team of 15 or so

@M.Doerner not as far as I recall, just that I had no use for it at the time so no execution paths led to it.

FreeMan

@mansellan Thanks. We've got a team of 2, so I'm sure it'll be massively overkill for what we need, but it's better than what we've got which is, at the moment, scraps of paper, random emails, and poor memory...

mansellan

I don't think it matters that it's overkill, from what I see it can scale from a one-man-band to a global team of hundreds (thousands?). Admin overhead is minimal.

and the integration with Teams (once you install the relevant Teams addin) is superb

FreeMan

I can see setting it up, adjusting, configuring and customizing being a total productivity killer for several days.

Or, I'll just use it bog standard and tweak as I go. ;)

mansellan

yep, depends how far you wanna go with it. It's pretty usable straight out of the box but very tweakable too.

FreeMan

Yeah, Teams... What's the difference between Add and Add to a team?

mansellan

1:00 PM

hmm, never noticed that. you mean when installing addins?

FreeMan

@IvenBach pssst don't forget the time cost!

@mansellan yeah.

I suppose I should get it setup first, then try to add the add in...

mansellan

not sure sorry, been a while since I added one

FreeMan

no worries.

mansellan

It's certainly much easier to get along with than JIRA, which we were using before.

I used to be a big Atlassian fan, but these days it all just seems too heavy.

FreeMan

AB - It's about 1000x what we need, but it's free, it's there, and it integrates with Teams.

that makes it as good a starting point as any other...

mansellan

1:04 PM

Actually I wouldn't be surprised if MS bought Atlassian at some point, seems a smart move.

probably not just atm though, their market cap is pretty high with the lockdown

(still pocket change for MS though)

A DBA is hosting a talk. He starts by laying out some printed cards, "Sirius A", "Canopus", "Beetlegeus", "Proxima Centuri"... He then turns to the audience and says: "Please select a star from the table".

BigBen

boooooo

mansellan

@this waves

this

1:22 PM

\o

FreeMan

@mansellan Please step away from the keyboard...

thing that make ya wonder:

I'm pretty sure we've all got accounts, though, through our corporate $$$$$ with M$

mansellan

yep probably, comes bundled with a lot of MS stuff these days.

M.Doerner

@FreeMan We are using Azure DebOps for the project of about 60 people I just work at.

Works out quite fine, both for the big teams and the very small ones.

FreeMan

good to know, thx

tried logging into azure.devops.com no problem. tried creating a project:

> You do not have sufficient permissions to create a new project. Please contact the organization administrator for support.

not so helpful... :(

added the azure boards "bot" to Teams, tried signing in. says signing-in... for a couple of minutes now...

sigh...

this

2:44 PM

I've never came a good naming solution for cases like those... Note that because it's an event handler, I can't control the Cancel's naming.

Private Sub Form_BeforeUpdate(Cancel As Integer)
  Cancel = ConfirmUserChoice()
End Sub

the design requires that it returns True when the user wants to cancel, so saying it's ConfirmUserChoice seems funny. I could say CheckIfUserWantsToCancel but that's a mouthful.

mansellan

@FreeMan might be a firewall issue, iirc you're in a locked-down env? my work isn't in a regulated sector.

FreeMan

2:56 PM

@mansellan Could be. Or could be that I don't the correct rights or... I'm trying to get in touch with someone here who can give me permissions or slap my hand for trying.

this

TBH, the permissions is a disfeature of Azure thing.

I've still yet to find a simple solution. I have a hack that involves adding a project's "team" to the group in order to grant the individuals (whom are members of the group) the permissions of the project's "team".

That group now has 100+ "teams" and it does take a while to load it when I add yet another. Seems totally convoluted and unnecessary but that was the only way I could grant everyone in my company the permission to view and do whatever on all projects. :\

I really hope there's a simpler way and I just suck at googling it up but in my past research, nobody had any clear idea on what to do.

FreeMan

For all I know, they've restricted it to corporate "project management" and us mere plebes aren't allowed to use it.

but... I'm asking.

Or, they never thought about opening it up because nobody's actually used it at all.

this

the default is lock down everything

FreeMan

I think we just bought everything MSaaS because it's there...

this

in the early days, I used to have to invite each individual to a project's team so they could access it (which wasn't what we wanted. We have no need for such micromanagement)

until I came up with the group hack mentioned above so that I didn't have to deal with individuals. I shouldn't have to grant permissions to individuals; only groups.

FreeMan

3:14 PM

Starring that as a potentially useful hack if & when I get access...

IvenBach

3:29 PM

@FreeMan #words. Meant financial cost.

FreeMan

You could spend the time making money...

FreeMan

4:01 PM

well, there goes the Azure Boards dream... All the $ we spend with M$ doesn't include licensing for it unless you pay extra.

I'll figure out something else, at least for now...

this

you mention Boards. I don't actually use it. Do you have DevOps?

(it's so hard keeping tracking of what's what)

FreeMan

I guess we do, but it's only available for people who are paying the licensing.

DevOps, that is

FreeMan

4:51 PM

Wow! Just pulled current origin/master into an old branch. Everything merged w/o any questions!

A) I hadn't done that much, and B) the bits I have done were well contained, since this is a new feature branch

go, go Gadget git!

BigBen

One of the helpful folks in chat.stackexchange.com/rooms/14929/vba-rubberducking might be able to address your question more in detail though. — BigBen 2 mins ago

this

I don't get it. why is it closed?

seems to me that it's reasonable to ask when it is allocated in VBA?

BigBen

Yeah I wavered on that.

It was partially asking for where to find documentation but I kinda regret voting to close tbh

I'd vote to reopen actually.

It could be reworded better to not ask for documentation.

this

going to try and improve

BigBen

just voted to reopen

this

5:02 PM

i don't have enough privs to answer so it'll have to wait until it's reopened and my proposed edits is approved.

BigBen

I voted to approve the edit.

this

actually seems to me better to mark ti as a dupe

3

Q: When are VBA Variables Instantiated

I'm hesitant to ask, but there's no documentation that I can find for VBA. Relevant (but I don't think a dupe): C++ When are global variables created? In Java, should variables be declared at the top of a function, or as they're needed? C++ Declare variables at top of function or in separate...

BigBen

well it's closed now but I left that as a comment, yeah

I agree, that seems to cover what we need

thanks for finding!

FreeMan

5:27 PM

approved the edit, VtRO

just to watch it get closed as a dupe ;)

BigBen

hahahahahahahhaahh

Quack Exchange

5:58 PM

0

Q: Workbook _open copy-paste reference sheet (30k+lines) from other workbook on change only

Working on finding a way to reduce in-cell formula size and memory usage of my excel workbook, i came up with the idea to "load" (copi-paste) the reference sheet i was mentioning a lot with a workbook open. To make it more efficient i had a loop that verifies if the sheet has changed and only cop...

vba excel memory-management memory-optimization

Quack Exchange

6:48 PM

0

Q: Employee name auto-complete on card scan

Im currently running an employee name substitution on card scan. Overall the code takes the entry trough the gun scan, "scan" trough the hidden reference sheet to find a match and then input the actual complete name. I had to implement that feature to my code so that names are always written the ...

vba excel autocomplete

IvenBach

7:03 PM

> ' Don't know what it does come w the code i found online

LOL reading that comment.

Quack Exchange

8:30 PM

0

Q: How to copy and paste a filtered range more effeciently

Hello everyone so I have this bit of code here that works for copy and pasting an autofiltered range I just wanted to see if anyone knew a more efficient way to do so as it does take quite a while to complete it the way I have it now. I looked into trying to do so with a copying into an array but...

performance vba excel

Peter M Taylor

9:27 PM

Howdy ya all...just leant MS accepting dev related issues now on Github. “ It doesn't matter if you're developing applications FOR Windows or applications that you plan to deploy on Linux, Android, IoT devices, servers, containers, or cloud - if you're building code ON Windows, we'd love to hear from you.”

Duga

[rubberduck-vba/Rubberduck] BZngr assigned BZngr to issue #5542: ExtractInterface Refactoring can provide implementation options

Peter M Taylor

source github.com/microsoft/windev and this article mspoweruser.com/…

Transcript for