VBA Rubberducking - 2018-05-01 (page 1 of 3)

« first day (1425 days earlier) ← previous day next day → last day (1755 days later) »

Duga

00:01

RELOAD!

[banane-io/PDB] 1 commit. 20 additions. 1 deletion.

[Cardshifter/HTML-Client] 3 commits. 145 additions. 39 deletions.

[Hosch250/CheckersWebsite] 6 commits. 74 additions. 94 deletions.

[rubberduck-vba/Rubberduck] 14 issue comments.

Tweeting Duck

I wish more people understood that the goal of Stack Overflow is not "answer my question" but "let's collaboratively build an artifact that will benefit future coders". Perhaps SO could be doing more to educate people about this.

Tweeted by codinghorror on April 30, 2018 at 10:29 PM

IvenBach

00:21

@MathieuGuindon I’ll take a look at the about window tonight. I want to polish it up and try my wing at a RD article.

Mathieu Guindon

@IvenBach sounds good!

IvenBach

00:37

@Vogel612 Derp... I just realized I don't know how to pull from my GH repo that contains your edits I merged.

Vogel612

wut?

you're going to need to explain that to me...

IvenBach

git pull upstream next is my kneejerk reaction. I have to figure out how to set a reference to my repo and pull from that to the branch that I currently have checked out.

Vogel612

you already have a reference to your repo...

it's origin

git remote -v

@IvenBach not per se a bad kneejerk, but one that won't actually get you ahead here

IvenBach

I'll give that a go when I can sit at my desk.

Hence my inclusion of Derp

Vogel612

check which branch you're pushing to (IIRC it's next) and pull that from origin.

I've set up my PR in such a way that it directly updates the branch you're working on.

well, the remote part of the branch. Now you only need to update your local copy of said branch :)

vogel.PasteSpecial Bed, Format:=xlPivot

4

Peter M Taylor

01:00

Make sure you sleep in bed not plank :) @Vogel612

As I don’t think xlPivot works for that range of furniture

3 hours later…

Tweeting Duck

03:36

@rubberduckvba Chip taught me how to code. The world is a dimmer place. I hope someone keeps his site online so he can keep on giving to the world.

Tweeted by Rubberduck203 on May 1, 2018 at 12:42 AM in reply to rubberduckvba

2 hours later…

IvenBach

05:15

The bed monster got to me before I could look at syncing...

QHarr

06:10

Morning

Duga

06:59

[rubberduck-vba/Rubberduck] bhames opened issue #3977: Dual screen - window move

> When moving the Code/Inspector/Todo Explorers onto another monitor (dual) and released then when moving again the 'wire-frame' will appear to the left of the drag point.

Duga

07:11

[rubberduck-vba/Rubberduck] bhames opened issue #3978: Explorer placement/grouping

> It would be nice to have the explorers (especially those set to start-up) to be start-up in the same location/size (& docked). As each time they start its "undocked" and in a small window, which required re-organising each time.

3 hours later…

Duga

09:47

[rubberduck-vba/Rubberduck] Vogel612 added label status-bydesign to issue #3977: Dual screen - window move

[rubberduck-vba/Rubberduck] Vogel612 commented on issue #3977: Dual screen - window move

> The "wire-frame" is not our doing. That's the VBEs doing and I highly doubt we have any say in it. Happy to be proven wrong

1 hour later…

Mathieu Guindon

11:11

CSV is exactly that. Ever opened a CSV file in Notepad? There's a reason Excel will only save/export the active sheet. And it will always properly delimit the data so a cell containing a comma won't break your file. Can't be sure of that with this approach. Exporting worksheet data to CSV is a solved problem. — Mathieu Guindon 12 secs ago

Or, keep iterating your gazillion cells and writing them to a file manually, and see you when your CSV gets mangled.

this

11:30

> I just did some testing, and the range-to-array-to-csv method is definitely slower than the Excel SaveAs method (0.9 seconds vs. 0.3 seconds when run on 1 million cells of data). Honestly though, I still favor the former approach, for the simple fact that when I want to save data from the current workbook as a csv, I want to export it, not "save" the code and all my fancy formulas in a file format that doesn't even support them.

#NIH

Duga

[rubberduck-vba/Rubberduck] retailcoder added label help wanted to issue #3978: Explorer placement/grouping

[rubberduck-vba/Rubberduck] retailcoder added label user-interface to issue #3978: Explorer placement/grouping

[rubberduck-vba/Rubberduck] retailcoder added label up-for-grabs to issue #3978: Explorer placement/grouping

[rubberduck-vba/Rubberduck] bclothier synchronized pull request #3975: Reflection API & COM management

Mathieu Guindon

@this and proper CSV handling would likely quadruple the runtime lol

Duga

[rubberduck-vba/Rubberduck] build for commit 8abb4043 on unknown branch: AppVeyor build failed

BUILD FAILURE!

[rubberduck-vba/Rubberduck] bclothier edited pull request #3975: Reflection API & COM management

[rubberduck-vba/Rubberduck] bclothier commented on pull request #3975: Reflection API & COM management

> The last set of commits fixes the event handling for parser state and it is now working.

Furthermore, we provide for retry for transient failure due to busy codebase.

Additionally a new `Declarations` collection was created to replace the array and thus simplify the navigation of the declarations in the COM.

this

@MathieuGuindon IKR! However, though the poster didn't say it, Excel's hadnling of CSV is not always right, however.

But that's usually a problem with import; I don't think I can recall a problem with ithe export, however.

Mathieu Guindon

@this and it's been doing it for over 20 years. One more reason to not even try to reinvent that wheel IMO

@Duga that's awesome, first time the COM API gets eyeballs in ages!

this

11:44

The next part is to make it non-creatable; it really should be gotten via a factory. That way we can allow hooking into the addin's RPS and thus also listen to events from that.

Mathieu Guindon

That would considerably accelerate the parsing, assuming RPS is up-to-date when the code runs

this

I did look at making the _Extension and _DockableToolWindow both non-creatable but unfortunately in both cases, they need to be directly created by VBE itself; we can't just give it an instance, so I can't really prevent that but I have an idea for preventing creation of the _Extension as we really don't want 2 castles starting a new War of Roses.

Mathieu Guindon

That would make a nice useful SO question I think

@this the analysis project needs to be referenced by other projects in the solution? That's why AV isn't building...

> C:\Program Files (x86)\Microsoft Visual Studio\2017\Community\MSBuild\15.0\Bin\Microsoft.Common.CurrentVersion.targets(1‌603,5): error : Project 'C:\projects\rubberduck\RubberduckCodeAnalysis\RubberduckCodeAnalysis\Rubberduck‌CodeAnalysis.csproj' targets 'netstandard1.3'. It cannot be referenced by a project that targets '.NETFramework,Version=v4.5'. [C:\projects\rubberduck\Rubberduck.VBEditor.VB6\Rubberduck.VBEditor.VB6.csproj]

Shouldn't it be the other way around?

this

it's only that way to force CodeAnalysis project ot get built first

otherwise, we get build error on the first time because it'll be not done building it when it start to building other projects that uses the analyzer

I used the Project Dependencies and marked all projects that has the analyzer installed as depending on that project to get that result. Have a better way?

it should be also noted that it builds locally here so there is no problem referencing .net standard. I did google briefly and it almost sounds like if one uses out of version SDK, one gets that error so it may be a matter of updating the SDK on the AV?

Duga

12:05

[rubberduck-vba/Rubberduck] bclothier edited pull request #3975: Reflection API & COM management

[rubberduck-vba/Rubberduck] bclothier commented on issue #536: Mark Interop only methods as such and create a project analyzer for them.

> This issue was made 2 years ago, and we don't have any `*Interop` namespaces now.

Do we still have a use case for this particular type of analyzer?

Note: PR #3975 will be introducing an analyzer that enforces COM attributes but we're talking about something different here.

FreeMan

anyone any good with SharePoint lists?

No specific questions yet, but good to know who my resources are... :)

this

I have used them. I may or may not have written something about it.

but that was a pretty while ago.

FreeMan

12:28

I may or may not have noted that, @this

A general question, for which the SharePoint list may or may not be the best answer:

We've got a number of locations, each with different hours. The location hours change regularly enough that determining the current operating hours becomes an issue when generating quarterly reports.

Duga

[rubberduck-vba/Rubberduck] bclothier commented on issue #2903: Proposed guidelines for COM visible RD features

> With the analyzer introduced in #3975, we are now able to enforce some of the guidelines; proposal 1 to 5 are now effectively enforced. A separate PR may be needed to enforce the rest of proposals, since they deal with a different type of problems so they need their separate analyzer.

It is suggested that we enforce this via analyzers, rather than writing a wiki article.

FreeMan

I'm thinking a list with location ID, effective date, open/close and lunch open/close columns (SP will automatically tag it with who changed & change date), and history turned on will allow me to keep track of all the necessary data and be able to produce a report of what the hours were for any particular location on any particular day.

Duga

[rubberduck-vba/Rubberduck] bclothier commented on issue #2885: RD's enums should follow COM naming conventions.

> Closing this issue since it's kind of already mentioned in the proposal #6 of the issue #2903.

FreeMan

Seem reasonable, or is there a better tool/solution? (without buying additional tooling)

Duga

[rubberduck-vba/Rubberduck] bclothier closed issue #2885: RD's enums should follow COM naming conventions.

[rubberduck-vba/Rubberduck] bclothier added label duplicate to issue #2885: RD's enums should follow COM naming conventions.

this

12:35

I suppose so. If you intend to use it as a list and no more than that, it'll be OK.

It becomes troublesome when you need to use it in conjunction with something else (e.g. to filter something else or to get a subset of report, blah blah)

Duga

[rubberduck-vba/Rubberduck] rubberduck203 closed issue #536: Mark Interop only methods as such and create a project analyzer for them.

[rubberduck-vba/Rubberduck] rubberduck203 commented on issue #536: Mark Interop only methods as such and create a project analyzer for them.

> No. This was specifically to look for places where we were using the source control COM interop interfaces instead of the internal ones. It was an architectural concern at the time, but those don’t exist anymore.

FreeMan

I'll be linking to it from Access to identify the appropriate hours to use for each report. Right now all this info is kept in a Word doc that's not really code accessible.

this

OK, and I guess it has to be a list because everyone else need to see it

FreeMan

This is intended to be a simple interface for the non-techincal to maintain the data so I can read it.

Yup.

this

I think that'll work. Access does a pretty good job of working well against the list

FreeMan

12:42

Might even write a bit of code to produce the Word doc from the list so everyone can have it in their accustomed format

thanks for the reassurance.

this

it's the trying to use list as a relational table in Sharepoint context that is kind of ...... EEEhhh.

but as long it's within Access, you'll be peachy.

FreeMan

Thought it seemed good, but I know it's always good to get other ideas.

this

that's actually the easy part, I think - just sic Access; export to Word, upload toe SharePoint document library, done.

FreeMan

@this not entirely sure what you mean by "relational table"

this

use a SharePoint list like you would a Access table or a SQL Server table

e.g. join it with bunch of other tables in a query

FreeMan

12:45

well, it's reformatting everything from SharePoint's "Excel-like" layout into the "document" layout that'll take some time.

So SharePoint doesn't like to play nice in joins? I'll keep that in mind.

Don't think that'll be a big worry, but I'll remember that

this

yes that's why I keep saying to use it like a "list", not an actual table

FreeMan

kk

this

you could join a list to another list and it'll be OK

3 lists? down down the toilet

FreeMan

lol

this

4 or more? you'll see heat death happening first

FreeMan

12:46

Kind of like users in an Access database

this

at least Access can manage up to 50 users on a shared file BE.

FreeMan

for certain values of "manage"...

in a previous life, we were running into regular data corruption with about 10.

this

if you have that much concurrency, move to SQL Server.

FreeMan

got it converted to a SQL Server back end, and most things were peachy after that

this

:+1:

yeah, Access really shines as a front-end tool. The database engine is OK; it's very convenient for local processing but I'd rather have data in a database managed by daemon than a bunch of users.... ;-)

FreeMan

12:51

Gave the users a short-cut that pulled the front end code from SharePoint each time they launched the app. That ensured everyone was running the latest fixes/features every time. There was a version check with a hard-coded FE version number that compared against the FE version number in the DB to ensure they weren't trying to run with an old front end. Gave them a big warning message then aborted. :D

Duga

[rubberduck-vba/Rubberduck] bclothier commented on issue #3978: Explorer placement/grouping

> I think we need more details because at least in my setup, it does as expected.

It might be related to the fact that you have a dual monitor. Can you re-test with only one monitor enabled and verify it persists the placement?

FreeMan

Since I'm generating a day-of-week schedule, I'll have a drop-down ("Choice") column to chose the DOW. Do those sort in the order I give them in the drop-down or do they sort alpha?

Duga

[rubberduck-vba/Rubberduck] daFreeMan commented on issue #3978: Explorer placement/grouping

> I'll note that I run dual monitor and have no issue with docked RD windows. (Win10/Office 2016 and previously on Win7/Office 2010). Don't recall any issue with that at least since the 2.0 release and possibly earlier. I'm currently running the CI releases.

If settings get wiped (which doesn't happen on reinstall anymore!), I have to go into the RD settings and remind it which windows I want open by default. I do have issue with the RD _toolbar_ not appearing on the line of toolbars that I w

Duga

13:16

[rubberduck-vba/Rubberduck] bclothier commented on issue #3978: Explorer placement/grouping

> Just as FYI - this is not a RD setting but rather a VBE setting. It keeps all the window placements in a binary format in the registry HKEY_CURRENT_USER\Software\Microsoft\VBA\X.0\Common under the key Dock. The RD codebase does not explicitly read or write to that setting.

FreeMan

13:45

Or... you discover that your scheduling package has an API. I should be able to use that to get all the hours since they should be updating open hours in the scheduling software when they change.

this

even better. ;)

FreeMan

14:08

In VBA what are the benefits/drawbacks to getting results in XML vs JSON?

I believe there's an XML parser built in to/avaliable as a reference in VBA

doubt there's such a thing for JSON.

this

Tim Hall did make a library for JSON in VBA

however it's not that detailed - it's OK for simple one level objects but anything more complicated.

my vote would be XML since it's easy to use MSXML2 library.

Mathieu Guindon

@FreeMan there is. MSXML has been around for a loooooong while

FreeMan

I could use RegEx!

ducks

Mathieu Guindon

gasp

Hosch250

knocks you out

FreeMan

14:11

well, this is a good excuse to drop one of my implementations of my IWebDriver.

Hosch250

Two easy ways to knock out someone ducking--from underneath meeting them going down, or from above, meeting them coming back up.

FreeMan

1 min ago, by FreeMan

ducks

dang.

Hosch250

And that's how programs like to knock you out.

Either when you first start, or just when you think it is solved.

FreeMan

Rubberducks

Ha!

Hosch250

@FreeMan The ~~doctor~~ duck says: No More RegEx!

FreeMan

14:13

Yeah... I've got enough to learn about submitting the API requests and figuring out the XML with MSXML - I don't need to go down that rabbit hole...

Mathieu Guindon

look into XPath

FreeMan

RegEx does have its purposes. This just ain't one of them.

this

^^

FreeMan

XPath?

Mathieu Guindon

short of LINQ-to-XML, XPath is your best friend

FreeMan

14:14

googles

this

please don't do stuff like for each node in nodes or getElementById('foo') that kind of stuff

Vogel612

XPath is really awesome

Mathieu Guindon

think of it as "query strings to pull stuff from XML"

this

basically look at selectSingleNode or selectNodes which uses XPath expression.

and for love of God, please don't write XML by hand.

has seen way too many VBA code snippets that does that....

Mathieu Guindon

yeah... write a builder instead :)

#fun

FreeMan

14:18

@MathieuGuindon ooohhhh...

Vogel612

depending on the engine you can even parameterize these

FreeMan

OK, so today is "shot" reading.

(for productive values of "shot")

Vogel612

which may allow your XML engine of choice to compile these queries (like SQL can build query plans and stuff)

this

This may be of some help if you need to write a XML from a recordset. Note that the output is fixed (basically creates an attribute centric XML with only t as the root and the r for each row.

Public Function GetXMLFromRecordset(SourceRecordset As Object, ParamArray Fields()) As String
    Dim objXml As Object 'MSXML2.DOMDocument
    Dim objRoot As Object 'MSXML2.IXMLDOMElement
    Dim objRow As Object 'MSXML2.IXMLDOMElement
    Dim fld As Object 'DAO.Field or ADODB.Field
    Dim flds() As Variant
    Dim var As Variant

    Dim lngType As Long

    If IsMissing(Fields) Then
        ReDim flds(SourceRecordset.Fields.Count - 1)
        For var = 0 To SourceRecordset.Fields.Count - 1
            flds(var) = SourceRecordset.Fields(var).Name

Mathieu Guindon

XML is typically more complicated than that though

this

14:27

Yes. The above is for my internal use and I like my XML document braindead simple.

If @FreeMan has to consume more than few XML formats, it might be better to use a XSLT so that all divergent XML sources can be transformed into only a single format and thus avoid a bunch of stringified stuff in VBA code.

OTOH, if the data is all already in SQL Server, then you probably want move all the XML work to SQL Server which has more features and means less conversions for you to do.

FreeMan

I'll be requesting XML from the website via their API then loading results into my SQL server

Hosch250

Another boring day at work.

this

oh ok, then i'd just cram it through.

forget MSXML

drop it in SQL Server. Much better that way, IMO.

Hosch250

FWIW, I'd parse the XML into a SQL data structure and use tables.

this

this is very old but it might get you oriented: accessexperts.com/blog/2014/01/14/…

please note one thing --- in that, it uses old stored procedure to "open"/"close" a XML document - that's not necessary; better to use xml.nodes method instead.

docs.microsoft.com/en-us/sql/t-sql/xml/…

FreeMan

14:41

Shut. The firehose. Off!

this

looks at the garden hose this? a firehose?

3

:p

Ok i'll stop.

FreeMan

Thanks, guys. I really do appreciate all the advice! Gonna take a while to chew through it all.

Hosch250

As far as that goes, if you are just requesting data, processing data, and dumping it into SQL Server, make a C# console app.

FreeMan

Wishes he still had tab manager in Firefox to put these all in their own group...

Step 1: find out what the heck our API key is!

puzzlepiece87

@MathieuGuindon Oh no :(

FreeMan

15:00

@Hosch250 Thanks, that might be a good beginner project...

this

@Hosch250 hey do you know off the cuff what is needed ot make .NET framework take .NET standard as a reference? It's building locally but not up in AV, so I guess it's needing some upgraded SDK, right? or is there something else?

Hosch250

Not sure.

this

k.

Hosch250

I've not done mix/match with it.

this

and to be sure, the analyzers must be .NET standard, right?

Mathieu Guindon

15:13

Look, do your thing, I'll do mine. Workbook.SaveAs FileFormat:=xlCSV is an export, and the fact that formats and formulas and code remain in the loaded document is literally a proof of that. Also FYI the C in CSV stands for "comma", not "whatever delimiter one feels like using". Anyway, feels like I'm discussing SQL injection mitigation with someone who would rather manually escape single quotes and keep concatenating their WHERE clause than do the right thing and parameterize their stuff. Have a nice day! — Mathieu Guindon 7 secs ago

#WereDoneHere

Duga

[rubberduck-vba/Rubberduck] kolci opened issue #3979: Inspection: Member Range implicitly references ActiveSheet - false positive with fully qualified arguments

> The `Range(ws1.Cells(1,1), ws1.Cells(5,5))` is a Range that is explicit. No matter what the `ActiveSheet` is, this statement will only return `Range `from sheet `ws1`.
There is no need to write the statement like this: `ws1.Range(ws1.Cells(1,1), ws1.Cells(5,5))`.
Is it possible to add this check to the inspection: If the arguments of the `Range `are fully qualified -> ignore.

Hosch250

@this Not sure. I don't think so.

this

hmm i see. the template was like that, and I just followed along.

Duga

15:41

[rubberduck-vba/Rubberduck] IvenBach commented on issue #3978: Explorer placement/grouping

> 3 monitors at work and 2 at home, neither have no issue with windows undocking. Explorers are always docked where I prefer them.

[rubberduck-vba/Rubberduck] bclothier commented on issue #3978: Explorer placement/grouping

> A thought... if monitor setup is such that it's reversed --- the primary is on the right, and the secondary is on the left, that might cause the coordinates on the left system to be negative. Would that be a possible cause?

IvenBach

@MathieuGuindon I've had a couple files before that were .CSV but in actuality were ; semicolon separated. Has anyone else ever had this come up before? The only thing I could come up with is regional settings but then the C would be a big misnomer.

Mathieu Guindon

IIRC Excel uses whatever the list separator character is, i.e. a comma in en-US locale

IvenBach

Misnomer it is then.

Mathieu Guindon

yes indeed, the C is a big misnommer. CSV is perhaps the single most abused format: it looks like it's properly specified, but for 30 years everyone has just been doing whatever the hell they want and slapped their files with a .csv extension - as a result, you can't know what's in a CSV file without opening it.

Duga

[rubberduck-vba/Rubberduck] retailcoder added label enhancement to issue #3979: Inspection: Member Range implicitly references ActiveSheet - false positive with fully qualified arguments

[rubberduck-vba/Rubberduck] retailcoder added label feature-inspections to issue #3979: Inspection: Member Range implicitly references ActiveSheet - false positive with fully qualified arguments

[rubberduck-vba/Rubberduck] retailcoder added label inspection-false-positive to issue #3979: Inspection: Member Range implicitly references ActiveSheet - false positive with fully qualified arguments

[rubberduck-vba/Rubberduck] retailcoder commented on issue #3979: Inspection: Member Range implicitly references ActiveSheet - false positive with fully qualified arguments

> `ActiveSheet.Range(Sheet1.Cells(1,1), Sheet1.Cells(5,5))` blows up if `ActiveSheet` isn't `Sheet1`, which indeed makes the inspection's quick-fix introduce a bug in this situation.

In other words, we haven't completely decyphered the full implications of `[_Global].Range` calls, and you are correct that qualifying *that* `Range` call would be redundant (that would even be inspection-worthy in its own right IMO).

However, one problem is that *it depends where that code is written*. If we

IvenBach

15:53

@this Haha. My friend write an XML generator doing that. It imported to the program they needed it to, so that meant it was all good...

UHF - We Got A Winner - HD

Duga

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.Core/Settings/HotkeySetting.cs of pull request #3976: Introducing Rubberduck.Resources

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.VBEditor.VBA/Rubberduck.VBEditor.VBA.csproj of pull request #3976: Introducing Rubberduck.Resources

[rubberduck-vba/Rubberduck] bclothier commented on Rubberduck.Main/Rubberduck.Main.csproj of pull request #3976: Introducing Rubberduck.Resources

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.VBEditor.VBA/Rubberduck.VBEditor.VBA.csproj of pull request #3976: Introducing Rubberduck.Resources

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.Main/Rubberduck.Main.csproj of pull request #3976: Introducing Rubberduck.Resources

[rubberduck-vba/Rubberduck] retailcoder commented on Rubberduck.Core/Settings/HotkeySetting.cs of pull request #3976: Introducing Rubberduck.Resources

this

@MathieuGuindon did you use R# to change to expression-body globally?

Mathieu Guindon

not globally, just on sight, in files I already needed to be in to get the thing to compile

boyscout style

this

Ok; we did reject Iven's PR in past partially because of global replacement which had some unwanted side effects.

Mathieu Guindon

yeah

Hosch250

16:07

FWIW, MS's recommended style is:

this

lol

Hosch250

public void Foo()
    => DoSomething();

this

Wait, do you even have scouts? Wouldn't you have mounties junior or something like that? :p

Hosch250

I prefer:

public void Foo() =>
    DoSomething();

Mathieu Guindon

I like mine with a semicolon, i.e. compilable ;-)

public void Foo() => DoSomething();

^ cleaner IMO

this

16:09

FWIW, if it can't be on one line, it probably shouldn't be an expression....

Mathieu Guindon

^

the second line just feels like an invite to add braces..

Hosch250

Depends.

Two lines emphasizes the declaration and the logic.

Mathieu Guindon

@this

Hosch250

One-line looks like a global variable.

Mathieu Guindon

Can't you just change the target framework of your RubberduckCodeAnalysis project to .Net 4.5? — Ryan Wilson 2 mins ago

this

16:10

hmm i'll give it try. I was just taking the template blindly which used .NET standard by default

Hosch250

@this FWIW, I wouldn't do it that way.

this

Yeah, shoot me. :p

Hosch250

I'd just include it in the project, and the users can compile it and install it into VS as an addin.

this

actually that's what I wnat to avoid

that only makes it more harder to contribute

Mathieu Guindon

^

this

16:12

or make them contribute without following our style

Mathieu Guindon

@Hosch250 it doesn't analyze anything other than RD, it belongs in RD

this

and additionally I have to get it to working in AV

Stack Duck

1

Q: Can I have an analyzer on a .net 4.5 project?

I have an OSS project on GitHub being built against .NET 4.5 on AppVeyor CI with Visual Studio 2017 (not the preview stuff, just 2017). The solution builds a COM add-in that extends a famously dreaded legacy Win32 IDE, and we've established that the earliest Windows version we need to run on, is...

c# .net msbuild continuous-integration rubberduck

Hosch250

OK.

this

very good. I'll see if I can get it to be .NET framework. Thanks for asking, @MathieuGuindon !

Mathieu Guindon

16:14

:+1:

this

I think it's OK if it's 4.6.1 - it's not going to be distributed anyway.

Mathieu Guindon

better if same runtime though

this

hmm, why?

it has nothing to do with the installed DLLs. (come to think of it, I should double check that the installer won't be bundling that)

Mathieu Guindon

makes the AV environment more predictable, but fine if it works anyway :)

this

ah, I see

Ok, i'll give that a try.

@MathieuGuindon just to clarify --

> On a local debug build, the analyzer project can be built manually, and then the rest of the solution can be built & analyzed just fine, without needing to hack up project dependencies.

the local debug already has the same project dependencies and it does build OK

in fact if the local debug didn't have that, I'll get an error consistently after a clean

Mathieu Guindon

16:28

@this huh, makes no sense... the AV error is MSBuild complaining...

this

that's why I thought there was some kind of upgrade to SDK needed

but I boy-scout promise you it has all that dependencies and it is building just A-OK locally

Mathieu Guindon

we can't have that break the CI build though

this

agreed

and I do want that analyzer running in CI, too

Duga

[rubberduck-vba/RubberduckWeb] bsacheri opened issue #53: Does Rubberduck have a ource control feature?

> Google shows a link to this page but the page has errors.
[rubberduckvba.com/SourceControl](url)

The cached version of this page is:
[http://webcache.googleusercontent.com/search?q=cache:oLO0Ksa1AkcJ:rubberduckvba.com/SourceControl+&cd=1&hl=en&ct=clnk&gl=us](http://webcache.googleusercontent.com/search?q=cache:oLO0Ksa1AkcJ:rubberduckvba.com/SourceControl+&cd=1&hl=en&ct=clnk&gl=us)

It's not clear to me if source control is a feature of the product for end users, or only showing how Ru

[rubberduck-vba/RubberduckWeb] bsacheri opened issue #54: Does Rubberduck have a Source Control feature?

> Google shows a link to this page but the page has errors.
[rubberduckvba.com/SourceControl](url)

The cached version of this page is:
[http://webcache.googleusercontent.com/search?q=cache:oLO0Ksa1AkcJ:rubberduckvba.com/SourceControl+&cd=1&hl=en&ct=clnk&gl=us](http://webcache.googleusercontent.com/search?q=cache:oLO0Ksa1AkcJ:rubberduckvba.com/SourceControl+&cd=1&hl=en&ct=clnk&gl=us)

It's not clear to me if source control is a feature of the product for end users, or only showing how Ru

[rubberduck-vba/RubberduckWeb] retailcoder edited issue #53: Does Rubberduck have a source control feature?

[rubberduck-vba/RubberduckWeb] bsacheri commented on issue #53: Does Rubberduck have a source control feature?

> I was trying to captialize the title when I hit a key that made my browser open the post a new window, thus saving the post. This is now a duplicate. You can delete either #53 or #54.

[rubberduck-vba/RubberduckWeb] retailcoder closed issue #54: Does Rubberduck have a Source Control feature?

[rubberduck-vba/RubberduckWeb] retailcoder added label question to issue #53: Does Rubberduck have a source control feature?

[rubberduck-vba/RubberduckWeb] IvenBach commented on issue #54: Does Rubberduck have a Source Control feature?

> RD did have source control feature. github.com/rubberduck-vba/Rubberduck/pull/3782 It was decided to remove in favor of maintaining, because of limited resources, as it had been somewhat troublesome feature.

[rubberduck-vba/RubberduckWeb] retailcoder added label duplicate to issue #54: Does Rubberduck have a Source Control feature?

IvenBach

16:44

@MathieuGuindon Should I migrate my comment to the non-duplicate issue?

Mathieu Guindon

@IvenBach nah

Duga

[rubberduck-vba/RubberduckWeb] retailcoder commented on issue #53: Does Rubberduck have a source control feature?

> An in-IDE integrated source control panel akin to Visual Studio's Team Explorer has been a wet dream since the project's beginning, and we were getting pretty close, however there were a lot of annoying issues and since Rubberduck is such a huge project and we are a relatively small team with limited time and resources, a decision was made to drop the feature, and announced shortly before the 2.2 release on

Mathieu Guindon

^ was in the middle of writing a reply :)

IvenBach

I figure since you are doing the big ducks work the least I do is pick up the smaller stuff.

Mathieu Guindon

meh. Max and Ben are the big ducks lately :)

Hosch250

16:46

And Vogel.

Mathieu Guindon

and Vogel

Hosch250

And of course Wayne.

Mathieu Guindon

yeah

thing is, every single contributor matters, whether a duckling or a quackhead

this

^

IvenBach

Hint: Anyone can contribute.

this

16:48

TBF, i'd rather have 10 duckling contributors over 2 quackheader contributors

Otherwise, the issues # is going to go up and up since there are many features to be implemented but someone has to put in time to build them.

I hope the writing of a new inspection itself isn't that hard.

Mathieu Guindon

it's not

Vogel612

what? I??

this

said the guy who is moving lot of stuff around....

Vogel612

dun do dis to me. I'm just dropping my half-finished work here...

Mathieu Guindon

@Vogel612 even your FTL issue-tagging is appreciated :)

Vogel612

16:50

@MathieuGuindon that's mostly thanks to Duga and me getting paid to maintain an OSS project where I regularly hand around on Gh

IvenBach

FTL?

Vogel612

Faster than Light

Mathieu Guindon

faster than github can handle anyway

Vogel612

pretty nice roguelike

Mathieu Guindon

besides, you contribute code too

Hosch250

16:51

More than me recently.

IvenBach

Has anyone dug around the XML data of a spreadsheet?

this

data?

I think you mean a continent

Mathieu Guindon

@IvenBach nope, I'm not suicidal

this

^

Hosch250

I think my legacy will be as doing a lot of the grunt work of 2.0, with Mat architecting it and Comintern handling the COM.

IvenBach

16:52

@this Content?

#Words

this

I speel very gooder, I'll have ya knew!

Mathieu Guindon

@Hosch250 and most refactorings too

IvenBach

@this Apparently my molting is affecting your #Wording.

Hosch250

@MathieuGuindon Most of those were 2.0.

this

so pre 2.0, it was one big project? :D

Mathieu Guindon

16:53

pre 2.0, RD was a wrecked mess

Hosch250

@this A couple.

I think it was SC, main, and VBEditor.

this

wow. and here we are looking at 16... more when Vogel finish his slicing'n'dicing.

Vogel612

@this FWIW that slicing and dicing is intentionally up-for-grabs

IvenBach

@this Is it worth a little bit of effort to understand some of the internals of the XML/Zip that spreadsheets are? I'm just trying to be aware of the abstraction they provide.

Vogel612

That issue was basically intended as an "epic"

this

16:56

I know. Both Mat's and my PR are basically part of that.

Mathieu Guindon

I'm hoping to finish mine tonight

this

@IvenBach IDK. I just hadn't a need for it in spite of all Excel automation I do.

Mathieu Guindon

@IvenBach heads up, your PR will be conflicted after that

this

I might need it if I had to do a headless automation but luckily that's not been a requirement (and likely won't)

Mathieu Guindon

maybe I should bring it in first

Hosch250

16:57

Now that I got the core features of checkers done, I should refactor my code, put it on CR, and do that UI.

this

even if I had to do a headless automation, you can assume I'll write a CSV exporter first.

Mathieu Guindon

@this SAVE AS

;-)

IvenBach

Mine's a tiny duckling-egg-sized PR. Nothing like Vogel's Ostrich-mondo-move-all-teh-things-around PR

this

oh c'mon, man. you know it's much fun writing it by hand....

(no, I won't literally do that. I'll just use some library something. you know I'm all about PFE here).

Vogel612

@IvenBach your point being? It's a great and useful PR

this

16:59

^

Mathieu Guindon

is it ready to go or still WIP?

« first day (1425 days earlier) ← previous day next day → last day (1755 days later) »

Transcript for

May '181

VBA Rubberducking

This chat has moved to Discord: discord.gg/MYX9RECenJ

antlr com-interop parsing rubberduck vb6 vba whiskey-tango-foxtrot

join this room
about this room

00:00

06:00

12:00

18:00

all times are UTC

site design / logo © 2025 Stack Exchange Inc; legal

mobile