VBA Rubberducking - 2018-12-13 (page 2 of 2)

« first day (1651 days earlier) ← previous day next day → last day (1529 days later) »

7:01 PM

What kind of ODBC driver doesn't let you alias NULL to a field name?

:fumes:

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4635: Unexpected Error

> The logs would confirm what specific "new version" you're using; you can find the logs under `%appdata%\rubberduck\logs`. They're disabled by default, but enabled on first startup specifically to log this kind of problem.

A parser error typically means your code doesn't compile. Does your VBA project compile? If you click the "parse error" button in the toolbar, a "parser errors" toolwindow should pop up with the actual parser error details - and these are in the logs too.

If your code *

Mathieu Guindon

@Duga gotta love "ur shitz dont work" issues with no repro steps or information whatsoever

IKR?

Mathieu Guindon

@FreeMan AFAIK 2.3.1 doesn't do that

It's a "flakey" issue.

Mathieu Guindon

7:03 PM

until proven otherwise, it's their code that's flakey

or, we have a grammar bug - which isn't impossible - but then at this point to crash the parser with legal code, you gotta be a very special snowflake

[rubberduck-vba/Rubberduck] retailcoder added label status-norepro to issue #4635: Unexpected Error

#SnowFlakey #ThunderFlake

[rubberduck-vba/Rubberduck] majkaz created comment on issue #4469: Request for timed project save

> I have a related question: I don't need autosave exactly, it is enough for me to export the code on each save / compile / close and I can use the VBA itself for this. The problem child for me is Outlook, where the code isn't exposed natively. The only way from there I have found is using olevba and parse the result, and this is the way I am using currently...

Is there a way to trigger the export function from inside of Outlook VBA?

@MathieuGuindon I've not had any issues. I've had random Excel crashes on exit over the last several weeks, but I don't know if any are RDs fault...

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4635: Unexpected Error

> Note that without further information about the version you're running and the parser error (i.e. the logs), there's nothing we can do other than shrug and say "it doesn't do that here".

7:07 PM

> Outlook, where the code isn't exposed natively.

?

Mathieu Guindon

don't look at me, I've no idea what that means

Glares @MathieuGuindon

@MathieuGuindon As annoying as it is, it's not the best PR if you brush them off. Keep in mind that because he couldn't get to the Settings dialog, he couldn't even get to the log or see what else he was doing wrong.

Mathieu Guindon

true, but he's not using the latest build

it also tells me that he couldn't discover the "show parser error" dialog, too

Mathieu Guindon

7:14 PM

yeah we should probably just pop the damn parser errors tw

My read was that he tried 2.0, backed off and now just tried the latest build ("new version")

or at least have the button show Click for details

[rubberduck-vba/Rubberduck] comintern created comment on issue #4469: Request for timed project save

> @majkaz I'm not sure that I understand what you mean by "the code isn't exposed natively". Do you mean that the VBProject isn't available via the Outlook object model, or something else? If that's the case you should be able to simply reference the VB extensibility objects and use those (if you're willing to deal with the security implications of doing that).

Mathieu Guindon

@this true. otoh our users are supposed to be programmers. what programmer likes users asking "it's not working, what can I do?"

eh, IDK, I got a short fuse today I guess

oh absolutely! but how many VBA users are just power users writing some little macros for their own uses as opposed to being a developer maintaining a LOB application?

supposed to be programmers. Remember that many of them are accountants using VBA because it's there and they've found some code to copy/pasta from the interwebz.

7:19 PM

^

^^

and that's one great thing about RD - it can be used as a teaching tool for those who are just fumbling around

(provided they can stop using that blasted macro recorder....)

Mathieu Guindon

yes. and when they get a user's bug report that says "doesn't work", what do they do? they get up, walk to that user's workstation, and ask to see the error happen.

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> RubberduckLog.txt

Mathieu Guindon

well, there you go

7:20 PM

Assuming they can write compilable code.

and when RD helps move them from copy/pastas to at least somewhat sorta moderately knowledgeable programmers, we've been a great success

huh. a OOM.

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

Mathieu Guindon

so, it is the latest version

> I disabled, /unloaded all my addins and com addins and the settings started to work
the log had been disabled, so I enabled it
my code compiles but I still get an error
see previous attachment

Mathieu Guindon

7:21 PM

32-bit Excel host

[rubberduck-vba/Rubberduck] retailcoder removed label status-norepro from issue #4635: Unexpected Error

System.OutOfMemoryException

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4635: Unexpected Error

> @CharlesRHall is QS_TAI_SuplrRptApp.ReportTblCls your own code or some external library code?

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> my own code

wondering if it's possible to send parser in a infinite recursion of doom?

That's the declaration resolver, not the parser.

7:25 PM

It shouldn't be.

I wonder if it's possible to send resolver in a infinite recursion of doom.

I'd think you'd run out of stack space long before that happened though.

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4635: Unexpected Error

> Ok, let's see if we can make a MCVE here. Can you create a new blank excel spreadsheet, and put only that procedure (and only what it actually needs -- mabye just the module?) and then try to parse that stripped down codebase?

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> does it parse all workbooks or just the active one - do I have to close the original before parsing?

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4635: Unexpected Error

> ATM, it will parse all unlocked VBA projects. To ensure no funny side effects, best to close all other workbooks and have only one workbook that contains the minimum code, ensure it is fully compiled then try to parse only that.

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4635: Unexpected Error

> Rubberduck parses all projects loaded in the VBE, so yeah you'd have to close the original. Since this is an "out of memory" exception I'd actually recommend closing the process and launching a fresh one.

I'm rather curious about what other add-ins you're running - more specifically which one is interfering with our settings dialog...

The good news is that it's not quite a parser error, rather an exception that was thrown while acquiring the declarations in a specific module (which means

[rubberduck-vba/Rubberduck] majkaz created comment on issue #4469: Request for timed project save

> Yes, VBProject isn't available via the Outlook object model. When I was searching for a solution, I have just found (maybe false) information that there is no possibility to export the code from Outlook. I have currently a working way to get this using olevba, I am just looking for a solution that doesn't need the extra tools (and Python).

[rubberduck-vba/Rubberduck] retailcoder edited comment on issue #4635: Unexpected Error

> Rubberduck parses all (unlocked) projects loaded in the VBE, so yeah you'd have to close the original. Since this is an "out of memory" exception I'd actually recommend closing the process and launching a fresh one.

I'm rather curious about what other add-ins you're running - more specifically which one is interfering with our settings dialog...

The good news is that it's not quite a parser error, rather an exception that was thrown while acquiring the declarations in a specific module (

Mathieu Guindon

@Duga wut, how are we parsing Outlook code at all then?

#JustWorks

OP apparently doesn't have extensibility referenced.

I'm pretty sure you can export code. Exporting is a VBA/E thing.

Outlook, however is weird about how it organizes the vba project. I think it uses only one for everything, since there's only one instance of Outlook.

Oh hell, it's locked down in OL.

7:34 PM

(been too long since I actually looked inside)

0

Q: VBA Extensibility in Outlook

I'd like to write a macro for Outlook 2007 that can add/remove modules in the VBA editor. The VBA Extensibility library looks perfect, but properties like Application.VBE seem to be inaccessible. In Excel, I would need to enable "Trust access to the VBA project object model". Unfortunately, th...

vba ms-office office-2007 outlook-vba

It wouldn't be horribly hard to expose that on the API though.

RD's API you mean?

hi, we've opened the security door for you here!

Yes.

It wouldn't be a security hole if we just expose something like Declaration.GetText() or something like that though.

hmm. So readonly access, basically?

Right. I wouldn't give access to the re-writers regardless of the host.

(except for personal use)

(in my own fork)

(for my own evil purposes)

7:39 PM

I suppose that's reasonable.

Consider, though that even read-only access can be said to be a security hole in the sense that it exposes the code

(but that's an academic discussion. If security really mattered, you shouldn't be writing it in VBA codebase, much less a desktop application code)

There is that. Although a third party add-on is a bit different from a built in API.

Any exploit would involve getting the VBE to run your code anyway, so if you're that far into the guts already, you already have access to the code.

Not much threat surface there.

remember the immediate window, though.

That window knows all, see all

and can be used to run even private methods

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> ok - progress

once I unloaded my vbe addins then the parsing error went away

I use MZ-Tools 8.0 - VBA and VBE Tools 2.0

So you're saying that once I crack that nut, I should sell it on the dark web?

even if it means using SendKeys to do the dirty work, that'd be sufficient to inject in your funny stuff in otherwise a benign codebase.

7:46 PM

@Duga Hey! I was just talking about shims this morning.

hmm but I use RD with MZ tools....

VBE Tools 2.0?

hmm never heard of VBE tools, though

MZ Tools is shimmed itself, but I'm betting VBE Tools isn't.

> Download v2.0 (15 October 2004, 214k, 53,220 downloads)

7:48 PM

Oh, wait. Is that the one with the cargo cult inspections?

eeeewwwww

blue background installer

ObjectNotSetToNothingInspection, NoErrorHandlerInspection, MissingHugarianNotationInspection, etc.

I have no idea.

NonBlueBackgroundInspection

let's see if I can get that repro'd

7:50 PM

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> loaded those addins again and it still parses - weird

yeah, same here. I don't think it's about add-ins.

but I'm definitely not going to keep vbe tools 2.0

But, but...

> The VBE Tools modifies the Tools > References dialog to show the location of the referenced file over two lines, allowing us to see the complete path.

...fancy!

Feh. I think there's a commie who is working on something better anyway.

I wonder if it's related to the control nudger thing.

it was flickering all the time

7:52 PM

If we both have hooks in the same UserForm...

hmm i do have a UF but it wasn't open in designer...

Does the VBE always put Attribute statements at the start of a line?

i never have seen it otherwise.

^

I will make that assumption for my AttributesUpdater.Remove method.

It only matters at the end of the file anyway.

7:55 PM

Speech-to-text is hilarious.

wrapper -> rapper.

stored proc -> stork rock

dev -> Deb.

app -> lamp

no reproduction.

I don't think VBE Tools 2.0 is the one to blame.

FWIW, I have more add-ins loaded and I still could parse...

Mathieu Guindon

32-bit host?

could be but woudln't it have to be darned large codebase?

This is the one I was thinking of earlier with the cargo exceptions.

Mathieu Guindon

Ugh

8:03 PM

@this It's possible that their subclass is misbehaving - not many devs in 2004 were using the "safe" methods.

Note that both of us also have subclass hooks in the designer window.

how do you know they do have subclass hooks?

The control nudger.

If they don't, I'd be even more worried.

i was asking mainly because I don't know if htere might be another way to get that without subclassing

You could lean hard on FindWindow.

would spy++ tell me?

8:09 PM

It would probably be hard to tell. The window message system isn't really designed in a way that makes it easy to tell who owns the winprocs in the chain.

I'm guessing you'd catch some messages that originate from them, but there wouldn't be an easy way to tell if they were in the chain or not.

It might be possible to slip a callback request of some kind in there, but that would probably rely on them implementing the pump properly.

Which if they did, would be... inconclusive.

No wonder my update method sis not work; I was passing in the old values as replacement.

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> I thought I had it narrowed down to one addin - PowerPivot Utilities - all other addins loaded everything parsed - added the PowerPivot Utilities and got the parsing error - removed the PowerPivot Addin, and everything parsed again.

However, then did not load my model, and just loaded the PowerPivot Addin - and it parsed fine - then loaded my model, and it still parsed fine

something weird is going on - any suggestions?

curiouser and curiouser

Mathieu Guindon

@Duga use a 64-bit host?

Should it really be just that, though?

I mean if it's powerpivot addin hogging the memory, it should have acted up in Excel, too?

Mathieu Guindon

8:22 PM

Hmm but I have x86 Excel 2010 + powerpivot add-in at work too...

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4635: Unexpected Error

> What is Excel's memory usage when it has the powerpivot addin loaded? Then when you parse with RD, how much memory is used?

just to keep it in perspective, though, there has been reports where 32-bit Access will run out of memory when you open one too many form or report but it is nowhere close to 2 GB of memory usage. Switch to 64-bit Access and the problem goes away.

almost as if it was using an internal heap or stack

[rubberduck-vba/Rubberduck] Vogel612 did something with some project card

8:37 PM

PowerPivot apparently sucks a lot of power, eh?

1.21 gigawatts to be exact.

Ah, that makes sense in that the other add-ins are partying like it's 1985. It must need a time machine to load them.

Oh cool, rewriting with InsertAfter can be done multiple times on the same index.

nice. what would happen exactly? X => XABC, or X=> XCBA?

[rubberduck-vba/Rubberduck] retailcoder added label memory-management to issue #4635: Unexpected Error

8:50 PM

XABC

That allows me to run the AddMissingAttributeQuickfix in procedure, module and project scope.

Mathieu Guindon

nice!

@M.Doerner wait you're addressing the "rewriter loses member attributes" issue?! :hurray:

That will come in a future PR.

The coordination for that is a bit more involved.

I start with the quickfix.

Next step will be an AttributeValueOutOfSyncInspection and an AdjustAttributeValueQuickfix.

After that, I will try to recover the member attributes automatically.

Btw, do we have a guid anywhere documenting which things have to be added when adding a new inspection or quickfix?

9:12 PM

[rubberduck-vba/Rubberduck] retailcoder created comment on issue #4635: Unexpected Error

> Thanks for taking the time to investigate this. PowerPivot is (can be) a rather memory-intensive add-in.. and so is Rubberduck. I have a very similar environment to yours here:

> Version 2.3.1.4318
OS: Microsoft Windows NT 6.1.7601 Service Pack 1, x64
Host Product: Microsoft Office 2010 x86
Host Version: 14.0.7212.5000
Host Executable: EXCEL.EXE

I have the PowerPivot add-in installed too, but I have to say I haven't been using it in macro-enabled Excel workbooks... must be why I'm no

Mathieu Guindon

@M.Doerner a guid? or a wiki page? I think that's yet to be written...

guide

Mathieu Guindon

ooh

so, wiki page

Mathieu Guindon

the only wiki page with a title that starts with "adding" is "adding a new host application"

9:19 PM

I probably need to add some resource somewhere.

Is there anything else?

Mathieu Guindon

the default severity level

that's so easy to forget..

i wonder if it's possible to add Rubberduck Inspection as a option to Add New Item menu in VS...

That's super easy IIR.

without having ot install a extension or whatever it is?

e.g. pull from git and bam! new item templates just for RD project!

"You kids and your fancy factory made inspections! In my day, all the inspections were carefully crafted by hand."

9:27 PM

:D

There's a reason why MySQL is a success....

Mathieu Guindon

@this PHP?

PCP?

AIUI, the two top factors was that it was 1) easy to install and 2) tolerable to stupidity

but I'm sure PCP was a contributing factor, too.

Oh, that is why I did not break any tests for MissingAttributeInspection; there are none.

Mathieu Guindon

TBH I thought that inspection had been pulled out a long time ago

9:54 PM

I rewrote it with a bug and wondered why nothing failed.

I guess you do not mind if I change a bit how attribute annotations work, right?

[rubberduck-vba/Rubberduck] CharlesRHall created comment on issue #4635: Unexpected Error

> thanks for the insight - but I need to clarify some things - I do use powerpivot but not routinely, so it was not loaded - I used powerquery a lot, and it too is memory intensive so I will be careful. The Addin that was causing the problems was one developed by someone else (not microsoft) and just adds some helpful tools - I don't use it, but I guess I did at one point, so it was still loading. I will disable it and see if the problems come back. I will keep experimenting with RD - it stil

10:14 PM

@Duga Huh? Why would his clients need to move to 64 bit if he's on 64 bit? And what are these mythical 32 bit libraries?

I know one major example would be MSCOMCTL

but I think that's no longer true anymore -- provided you're on a subscription model.

I'm more than 1/3 done with my F# book!

(Keeping track because Iven said it would be hard to read them :).)

@Hosch250 I guess I omitted for someone like me. We're apparently no opposite ends of the speed-at-which-one-groks-stuff spectrum.

FWIW, I already know F#.

This book is moving really fast, while the microservices book is moving slower.

> opposite ends of the spectrum

:p

10:27 PM

Because this book is mostly review.

I'm working on refactoring to use MVP and I'm stumped how to highlight labels for bad inputs.

Mathieu Guindon

lookup data validation

it's built into the UI framework

WinForms?

or WPF?

what's with the hats?

Mathieu Guindon

it's Winterbash!

googles Winterbash

Mathieu Guindon

10:31 PM

^^ link there

Winter Bash 2018

Juan M on December 12, 2018

The world is full of interesting yearly traditions. Take for example the tomato and orange throwing events, the buffet for monkeys, and the cheese rolling festivities. With such examples of human creativity, we at Stack Overflow could not pass on this opportunity. We have created and maintained our own yearly tradition – Winter Bash!

This year we are attempting to knit our users together in our love for hats for the 7th year in a row. And this year, we’ve even added a way for you to get creative without wasting any real yarn. Starting now (December 12, 2018) and going through …

@MathieuGuindon System.Windows.Forms.Form So I'm assuming yeah it's WinForm

Mathieu Guindon

^ and here

@IvenBach k. look into "winforms data validation" and "error providers"

heh, that's cool

Mathieu Guindon

end-of-December is a yearly dive in SE-wide activity, so they make WB to foster activity... keep an eye on meta.se for swag & contests, too

They already had two.

A knife one (how violent!) and a time one.

TTQW. TTYL.

10:51 PM

[rubberduck-vba/Rubberduck] CharlesRHall opened issue #4636: Code Inspect Activeproject only

> Was this ever implemented - it was discussed back in 2016 - it seems essential to my use - I hate wading through messages for a project I am not working on

Is there actually any use for the attributes on the attribute annotation types?

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4636: Code Inspect Activeproject only

> I'm going to close this as a duplicate of #3041 which incidentally also will be addressed in some form by upcoming PR #4535. This isn't the exact thing because the PR deals with treating the user libraries as "external" in the sense that we will only parse for the resolution of the references. We can't simply just skip a project since that would cause the analysis to come up with false positives about undeclared declarations among other things. However, it will skip those projects for inspecti

[rubberduck-vba/Rubberduck] bclothier closed issue #4636: Code Inspect Activeproject only

[rubberduck-vba/Rubberduck] bclothier added label enhancement to issue #4636: Code Inspect Activeproject only

[rubberduck-vba/Rubberduck] bclothier added label duplicate to issue #4636: Code Inspect Activeproject only

@Duga Hm, I will have to experiment a bit with how to actually load the VBA classes.

However, I will finish the attributes business first.

So, if anybody wants to take a stab at the vba class resolution, feel free.

I think we should push that in after the next release. I do not want to put a potentially large source of new bugs in along with the glorious references dialog.

11:19 PM

huh interesting. they added "pinned issues"

apparently for only 3, though

might be worth it for the showstopper issues, I guess.

What's in the asset cache files in the obj directories?

I'm getting a weird build issue where new icons aren't being added and just noticed that the clean doesn't remove them.

Hmm. I'm tempted to add a clean action just to flush out the obj folder.

which obj directories btw?

Rubberduck.Resources

Hmm... what ever the issue is, that wasn't it.

Oh, the issue is that I'm a freak'n idiot. Can't have a - in the file name.

11:42 PM

[rubberduck-vba/Rubberduck] CharlesRHall opened issue #4637: Code Inspection freezes when using the Delete this Inspection feature

> the ducks start spinning and it never returns - can close and reopne, but the ducks are still spinning - must close excel - arghhh

11:53 PM

@Duga Charles hails from the castle of arghhh, must be a cousin of Monty.

[rubberduck-vba/Rubberduck] comintern added label user-interface to issue #4637: Code Inspection freezes when using the Delete this Inspection feature

[rubberduck-vba/Rubberduck] comintern added label bug to issue #4637: Code Inspection freezes when using the Delete this Inspection feature

[rubberduck-vba/Rubberduck] comintern added label critical to issue #4637: Code Inspection freezes when using the Delete this Inspection feature

[rubberduck-vba/Rubberduck] comintern added label difficulty-02-ducky to issue #4637: Code Inspection freezes when using the Delete this Inspection feature

@IvenBach I should ask his favorite color.

[rubberduck-vba/Rubberduck] comintern milestoned issue #4637: Code Inspection freezes when using the Delete this Inspection feature

Nah, I'd go with 'Do really small rocks float?'.

« first day (1651 days earlier) ← previous day next day → last day (1529 days later) »

Transcript for

Dec '1813

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 © 2024 Stack Exchange Inc; legal

mobile