Could be a new video type like TechHelp or FastTip

Day1 was fun, anyone else completed it?

Yep just finished it with VBA. Not sure if I cheated though, I pasted the value list into a table, maybe I was supposed to import that part with code.

What language did you use Alex?

Oh fab, I think that's fair, that's just the util stuff.

Prob would be worth having a procedure to import data from a text file as each day you get a different input and you can test on the sample one then the actual.

You got it up on GitHub?

I picked C# again.

Nope, I'll make a GitHub tonight for this and see how many I do lol

I'd love to see it,
Also don't forget to use VCS so I can easily see the code.

I don't know what I'm doing but I think I shared it LOL.

SPOILER ALERT, vba solutions HERE

I'll need to go back and look at the videos I think you made about GitHub for how I'm supposed to do it LOL.

Do you have the plug-in in Access?

Probably not, havent really ever used GitHub.

No, the VCS access add-in.

See videos.

I'll check them out tonight and fix it. Thanks

I haven't watched yet, but I found out how to clean it up a little bit I think, uploaded vba Day 2 part1/2. Really easy day, I even coded more than I had to I think. See how many days VBA can last.

Kevin Scott either of you doing it?

No, at least not at the moment.

🤘📰✂️

Not me.  In case you haven't noticed I've been MIA quite a bit lately.
Slammed at work.  The Monday, Tuesday and Wednesday of last week we logged almost 500 phone calls. Our busy  time of the year!
Life is good though - just busy.

Alex did you do day3?
I have a lot of lines that have no matching characters if split in the middle

One of my lines is
LTmnZTgMmbWWGWZQZb
There is no matching letters on the left 9 to the right 9

Am I missing something?

I don't want to talk about it LOL. There is a Z. I'm just blind

Did you brute force it?

Yea, I was actually having some trouble with this one getting it to match characters correctly, it was picking and choosing where it wanted to match. I had about a page worth of code trying to get super technical with it, then dumbed it down to the most basic possible and it worked lol. Swear that didn't work the first time ;). Uploaded D3P1 working on P2 now.

🧝 Day 4 was fun, and Part 2 was a quick addition.

I think this is it for VBA boys LOL.

Alex any ideas?

Did you try a Stack to push and pop from?


Dim stack as Object
Set stack = CreateObject("System.Collections.Stack") 'Create Stack

stack.Push "Hello"
stack.Push "There"
stack.Push "Mr"
stack.Push "Smith"

peekAtTopOfStack = stack.Peek()
doesContain = stack.Contains("htrh") 'Result: False
doesContain = stack.Contains("Hello") 'Result: True
    
'Get item from the top of the stack (LIFO)
topStack = stack.Pop()  'Result: "Smith"

'Clear the Stack
stack.Clear

Set stack = Nothing


No I did not, I didn't know there was a stack object. I was trying to brute force code it with pages of code lol. I'll try something like that. Thanks

Break it down into simple problems first.
How to I add items to a stack, how do I move from one to another.
Work on parsing the commands, how would you then call that against your collection object.

Day 6 - 🧝☎️

Yea did day 6.

Part 2 i did with reallly ugly code though lol.

Coming back to day 5 when I have some free time.

Day 6 - Part 2 was one input change for me, which was lucky, or well thought ahead, who knows.

Day 7 - Fun stackoverflow

Day 8 - 🌲

Day 9 - 🌉

I'm falling behind getting busy at work lol. I'm almost done with day 7, day 8 looks interesting, still need to go back to that stack too lol.