VBA Rubberducking

« first day (2011 days earlier) ← previous day next day → last day (1169 days later) »

Duga

12:01 AM

RELOAD!

[AndaraCodes/AdventofCode2019] 2 commits. 246 additions. 10 deletions.

[MDoerner/AdventOfCode2019] 3 commits. 2832 additions. 49 deletions.

[Phrancis/AdventOfCode2019] 6 commits. 294 additions. 78 deletions.

[rubberduck-vba/Rubberduck] 1 opened issue. 3 issue comments.

[Zomis/AdventOfCode] 1 commit. 165 additions. 14 deletions.

[Minesweeper] Games Played: 81, Bombs Used: 40, Moves Performed: 9916, New Users: 12

Phrancis

Hey folks

Simon Forsberg

12:24 AM

@Phrancis Hey!

(I also just dropped in here now)

Mathieu Guindon

Hey!

Simon Forsberg

No one here doing Advent of Code?

Coding Projects and Duga Heaven :)

Minesweeper Flags, Zomis' games, PDB, MTG, Cardshifter, and al...

Mathieu Guindon

1:02 AM

@SimonForsberg hm, it was mentioned in here a few days ago, I think we have one or two

2 hours later…

Mathieu Guindon

2:35 AM

@IvenBach hope you enjoy that one!

(come on, feeds)

Blogging Duck

Rubberduck News: Document Modules

posted on December 08, 2019 by Rubberduck VBA

The first time you discovered the Visual Basic Editor and visualized the VBA project in the Project Explorer, when you first met ThisWorkbook and Sheet1, document modules were the world: your baby steps in VBA were very likely in the code-behind of ThisWorkbook or Sheet1 - document modules are the gateway to VBA-land.… Continue reading Document Modules →

IvenBach

3:12 AM

@MathieuGuindon early Christmas gift? How thoughtful of you. Didn’t know I was your favorite.

Will read it when I can. Finals are stressing me out and stealing my time.

Mathieu Guindon

Feedback welcome =)

(no rush)

Phrancis

3:28 AM

Not sure why but the spacing is off

Mathieu Guindon

Ah, that's the justified alignment

Phrancis

I blame PHP (I'm clueless about how your blog works, it's just an easy target)

Mathieu Guindon

lol

6 hours later…

IvenBach

9:15 AM

Night pond.

1 hour later…

Simon Forsberg

10:17 AM

@MathieuGuindon Doing it in VBA, I hope

4 hours later…

Quack Exchange

2:20 PM

Q: Reduce time taken for vba loop with up to 10,000 iterations

My VBA code currently loops for 5,000 iterations and takes about 25 minutes to collect the output data in the Output excel sheet. Is there a way to reduce the time taken for instance by improving the copying and pasting of values, collecting the output data in some kind of array etc.? Given that ...

Freeflow

3:04 PM

OK Second attempt

I keep runnining into an annoying idiosyncracy with my VBA c#linbray 'Kvp'. I thought I'd check the wisdom here before posting on stackoverflow.

Cnsider the following VBA code

Option Explicit

Sub AssignToKvpItem()

Dim myKvp: Set myKvp = New Kvp

myKvp.AddByIndex 42&
myKvp.AddByIndex 84&

Debug.Print myKvp.Item(CLng(1))
Debug.Print myKvp.Item(CLng(2))

myKvp.Item(1&) = 99

Debug.Print myKvp.Item(1&)

TestPassedKvpAssignment myKvp

End Sub

Sub TestPassedKvpAssignment(ByVal ipKvp As Kvp)

Oh Good grief. Maybe even a third attempt

Freeflow

3:27 PM

I keep runnining into an annoying idiosyncracy with my VBA c#linbray 'Kvp'. I thought I'd check the wisdom here before posting on stackoverflow.

Consider the following VBA code

Option Explicit

Sub AssignToKvpItem()

Dim myKvp: Set myKvp = New Kvp

myKvp.AddByIndex 42&
myKvp.AddByIndex 84&

Debug.Print myKvp.Item(CLng(1))
Debug.Print myKvp.Item(CLng(2))

myKvp.Item(1&) = 99

Debug.Print myKvp.Item(1&)

TestPassedKvpAssignment myKvp

End Sub

Sub TestPassedKvpAssignment(ByVal ipKvp As Kvp)

Debug.Print ipKvp.Item(1&)

Mathieu Guindon

@Freeflow I don't think you get an Item member for free... I think your C# class/members needs more attributes, and an explicit COM interface.

Freeflow

4:07 PM

@MathieuGuindon I'd admit I am very much a novice in c# but I did a lot a reading an research while building my library, and to be honest I'm finding it of great utility when pootling in VBA. I think I got the interface correct but there may well be some attributes that I'm missing.

http://i.stack.imgur.com/9bNCl.jpg

2 hours later…

IvenBach

6:08 PM