VBA Rubberducking

8:08 PM

@M.Doerner Caught up to what you said nearly 2 hours before. Working on this.

I'm just a bit slow on the uptake.

So, it seems that setting the error to display Build Only rather than the default Build + Intellisense helps with avoiding showing you bogus errors like missing metadata files

However, 2018 still doesn't update its error list. :(

KySoto

Another RD parse error

similar deal to last time

cept it was (i think) a different path

it was trying to work in a folder that didnt exist

this

add to the bug report you opened?

KySoto

so i manualy created hte folder, and it parsed

Duga

[rubberduck-vba/Rubberduck] KySoto created comment on issue #4454: Getting a parse error with no result in search results window

> I opened the attached log and checked the path it was complaining about, tried to navigate to it, and the folder Rubberduck folder in the temp folder didnt exist. I manually created the folder, and it parsed. RubberduckLog.txt

[rubberduck-vba/Rubberduck] KySoto edited comment on issue #4454: Getting a parse error with no result in search results window

> Version 2.2.6672.28001
OS: Microsoft Windows NT 10.0.16299.0, x64
Host Product: Microsoft Office 2016 x86
Host Version: 16.0.4711.1000
Host Executable: MSACCESS.EXE

I opened the attached log and checked the path it was complaining about, tried to navigate to it, and the folder Rubberduck folder in the temp folder didnt exist. I manually created the folder, and it parsed. [RubberduckLog.txt](https://github.com/rubberduck-vba/Rubberduck/files/2536247/RubberduckLog.txt)

KySoto

8:22 PM

@this Ok added.

this

:+1:

one more thought, @KySoto -- did you parse while forms were open in form view, rather than design (ditto for reports)?

KySoto

yes. a form was open in form view

but it worked after i created the folder

Hosch250

TIRL: you can have a static constructor.

docs.microsoft.com/en-us/dotnet/csharp/programming-guide/…

Duga

8:43 PM

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4454: Getting a parse error with no result in search results window

> FWIW - I think there's some mangling with the HRESULT.

Given this VBA code:
```
application.VBE.ActiveVBProject.VBComponents(1).Export "C:\foo\goo\bar\nothere.txt"
```

We get an error:
```
---------------------------
Microsoft Visual Basic for Applications
---------------------------
Run-time error '50035':

Application-defined or object-defined error
---------------------------
OK Help
---------------------------
```

50035 = 0x0000C373
`vbObjectError` = 0x800400

Duga

8:53 PM

[rubberduck-vba/Rubberduck] bclothier edited comment on issue #4454: Getting a parse error with no result in search results window

> FWIW - I think there's some mangling with the HRESULT.

Given this VBA code:
```
application.VBE.ActiveVBProject.VBComponents(1).Export "C:\foo\goo\bar\nothere.txt"
```

We get an error:
```
---------------------------
Microsoft Visual Basic for Applications
---------------------------
Run-time error '50035':

Application-defined or object-defined error
---------------------------
OK Help
---------------------------
```

50035 = 0x0000C373
`vbObjectError` = 0x800400

this

RE: renaming VBE to Vbe, I'm having a bad feeling --- how do we ensure this doesn't result in phantom files once distributed via git? Keep in mind I'm renaming both files and types.

Comintern

It should just "work".

git comes from *nix land, so it sees them as completely different files.

this

for some values of "work". You weren't around when we were chasing away the RetailCoder.VBE that wouldn't die

(in contrast to Retailcoder.VBE)

M.Doerner

@this In my case, I get the errors because quite a few quickfixes now require less arguments in the ctor and because the Fix method has one additional parameter, the one the entire refactoring is about.

Comintern

@this Only problems that I've ever run into have been switching branches with the Team Explorer instead of from the command line.

this

9:04 PM

@Comintern is there a easy way of getting the raw HRESULTs inside VBA?

Comintern

You mean for the mdi children?

this

no for VBA runtime errors

see above

Comintern

Ahhh... generally you just need to tack 0x8000 on the front and call it hex.

this

yeah normally.

Comintern

For that one, I'd take a look at this: vbaexpress.com/forum/…

this

9:06 PM

(0x800A, no?)

Comintern

Permissions issue?

this

he did create the folder manually

so don't think it's just a permission issue

Comintern

Oh, yeah, I forgot we smoked that in chat.

@this If that's a conforming HRESULT, 50035 = 0x0000C373 makes sense. The high word is not "technically" part of the error code.

HRESULT

In the field of computer programming, the HRESULT is a data type used in Windows operating systems, and the earlier IBM/Microsoft OS/2 operating system, to represent error conditions, and warning conditions. The original purpose of HRESULTs was to formally lay out ranges of error codes for both public and Microsoft internal use in order to prevent collisions between error codes in different subsystems of the OS/2 operating system. HRESULTs are numerical error codes. Various bits within an HRESULT encode information about the nature of the error code, and where it came from. HRESULT error codes...

Something is yanking the lword off before it's displayed.

this

Hmm. but not just the word

it's off by one, too

Comintern

0x800A would be a non-success value (bit 31 is set), and the A should be the "facility code".

KySoto

9:14 PM

so yeah, i manually created the folder because last time

you asked me if i could navigate to the folder that it was having issues at

if i can create the folder, i assume im good

this

No, i mean that the lword of HRESULT returned was 0xC372 --- whereas the VBIDE error equates to 0xC373

KySoto

well that and it worked after i did

thats fun.

-_- not.

this

Yeah, something's failing when creating the folder.

and not detecting that.

Comintern

@this Ahhh, gotcha. That's odd. Facility 10 is "Control", whatever that means.

this

that's why I thought maybe it was something stupid like overflow then appending to some prefix

I remember some years ago I encountered a bizarre HRESULT, which actually turned out to be a benign Access OM error that was esaily handled

they did not jive at all

Comintern

9:18 PM

That would be a pretty severe overflow - that's like an order of magnitude.

this

so I've been suspicious about HRESULT vs. what we normally get via OM.

Comintern

Not suspicious of Access?

They usually make sense coming from Excel.

this

?1004 makes sense?

;-)

Comintern

0x3EC => it's short for Eeeeek!

this

#TIL

Comintern

9:21 PM

#TIMU

Today I Made Up.

this

#TIFFI

KySoto

#TIMMEH

Duga

9:46 PM

[rubberduck-vba/Rubberduck] bclothier created comment on issue #4476: Some fakes do not play well together

> Addendum:

This is fine:
```
Fakes.Now.PassThrough = False
Fakes.Date.PassThrough = False
```

So is this:
```
Fakes.Now.PassThrough = True
Fakes.Date.PassThrough = False
```

But NOT this:
```
Fakes.Now.PassThrough = False
Fakes.Date.PassThrough = True
```

So though `PassThrough` plays a role, it is only an issue with the fake where the function will end up implicitly calling some other function that's also hooked.

Transcript for