VBA Rubberducking

10:41 AM

carp

been using git for my Excel development.

I've got 2 files in my master branch that it says are untracked.

They should be in a different branch, but git won't let me switch to the correct branch to add them.

What are the appropriate steps to fix this?

I can't move the files, they don't seem to physically be on disk where I've CD'd to for my project

Yes, yes they are. I haven't had coffee yet this mornig.

Would it make sense to physically move the files elsewhere
switch to the correct branch
move the files back to the proper `git` directory
add/merge/whatever the files into the proper branch?

Vogel612

11:07 AM

yea, that should work

Thanks, @Vogel612. Is that the "proper" way of doing it? Is there a "proper" way of doing it, or is it "whatever works"?

Interesting. I did that, and when I went to copy them into the working directory for the proper branch, Windows nicely told me they were already there. A git diff indicated that the files I had are identical to the versions in the branch I'd just checked out.

If I switch branches away from a branch with a new file, does git not delete that file from the working directory?

hrm, no, it seems that when I check out a branch, my working directory contains exactly what should be in that branch.

I think I hosed myself by exporting the code from Excel with those modules while working in the wrong branch.

This is gonna be a pain!

When working in VBA, I really need to drop all code modules, then import whatever's on disk. That will be the only way to ensure that my current [Excel|Access|Word|whatever] file is true to the branch I'm on.

#joy

Duga

11:36 AM

[rubberduck-vba/Rubberduck] 41646F6C666F starred us

3

^there's a fun ID to remember... goes to find his hex converter.

finds hex to ASCII converter instead: "Adolfo"

12:38 PM

don't you mean AD01F0?

Q: Excel VBA - Currency Conversion Function (Historical Date)

maaaybe...

Quack Exchange

1:42 PM

0

I am using this sub which works fine but outputs a table with rates Option Explicit Public Sub GetTable() Dim sResponse As String, html As HTMLDocument, ws As Worksheet, clipboard As Object Set ws = ThisWorkbook.Worksheets("Sheet1") With CreateObject("MSXML2.XMLHTTP") .Open...

1:58 PM

grrr... working from home today and my git notes are at work.

to merge with my local master I need to:

1) commit to my branch
2) check out master
3) git merge <branch>

right?

@FreeMan i felt the need to be smart assy... but then i felt the need to be lazy, good luck

eh?

2:16 PM

with your git stuff

Hosch250

Unless you have unsaved work on your local, you don't need to commit.

Wondering if anyone knows whether the p-code is different for Foo!Bar compared to Foo.Items("Bar") -- more in particularly whether Bar gets compiled as something else than a string literal when using bang operator.

@this huh, why would it be? assuming it is a compiler-assisted default member call, that is

I mean, I'd expect it to be 100% equivalent. unless... unless the p-code isn't as low-level as I imagine it :/

2:36 PM

@Hosch250 I did. thx for the confirmation

@MathieuGuindon I didn't have a reason to expect it to not be same; just was wondering if it was possible.

depends if it has its dedicated opcode, or if the compiler is the one doing the "translation", I'd guess

that said I know nothing of p-code, other than the name

new RD feature: op-code / p-code viewer

2:57 PM

> Rubberduck /> View Disassembly

lol

@this you know SQL data types better than I do... did I just stick a foot in my mouth here?

But, TINYTEXT is not a VARCHAR, as a TEXT data type it's closer to being a blob of bytes, which probably explains the 16 you were getting instead of the supplied string - so the ordinal parameters worked better than the named ones. Consider avoiding the more exotic data types and sticking to VARCHAR. If the reason for TINYTEXT is a performance concern, see "TINYTEXT is probably never a good idea". — Mathieu Guindon 55 secs ago

everything is a blob of bytes, mug

the hell.. tinytext?

MySQL

uhh

neat...

wouldnt use it

Pretty much.

3:20 PM

do you guys often access Acitve directory for permissionsy stuff?

or to get user data

Hosch250

Never, but my work uses it.

I did that long ago

long, long time ago

Hosch250

I don't work on that side of it. The web side has it's own user/permission/etc data.

and for the same reasons - I prefer to use SQL Server permissions whenever possible

ah, i never use web stuff

3:22 PM

@KySoto I don't. When I set up a new app/db I have the sysadmin create a new security group and I setup the login and perms for it in SQL Server, but I never needed to query AD directly

doh spot the mistake:

i = 26
Select Case i
   Case i = 26
     'doesn't execute...
End Select

yep my day's going along swimmingly

Should be Case 26..

hmm

IKR?

that's Case True i.e. Case -1, and that's not 26

3:25 PM

the joy of working with a loosely-goosely typed language, I suppose

well i made a thing that i thought was neato burrito

Public Enum adProperties
    adpSam = 1
    adpName = 2
    adpEmail = 3
    adpDisplayName = 4
    adpUPN = 5
    'i can add more as needed.
End Enum

Public Function getADPropertyName(ByVal argIn As adProperties) As String
    Dim out As String
    Select Case argIn
    Case adpSam
        out = "sAMAccountName"
    Case adpName
        out = "name"
    Case adpEmail
        out = "mail"
    Case adpDisplayName
        out = "displayname"
    Case adpUPN
        out = "userPrincipalName"
    Case Else

@MathieuGuindon Yep, exactly. I had to debug step before I realized my boneheaded mistake

i went and bleeped out my domain info from the function