> **Justification** Parity with built-in functionality..
**Description** The Project Explorer's context menu for component nodes has 'Save' and 'Save As...' commands, Code Explorer should too. We can reuse the `ExportCommand`, the functionality is almost identical.
@Duga self-assigned, I already know how to do it, and the work for 5041 will get part way there. Just raising for correctness rather than tacking it onto my upcoming PR.
Hmm... COM shims... They're a way of loading different add-ins into separate AppDomains. But... Net Core doesn't have AppDomains, and AFAICS won't ever have them. IMO, getting to Net Core is much more important than implementing shims, so... we shouldn't do shims?
Does anyone know if it is possible with vba to intercept RefreshAll via UI button push of RefreshAll? I have an odbc connection which when refresh is chucking out a text column until you click on each cell and then those values are converted to the dates they actually are. I have a sub which does
Public Sub FormatMonthColumn()
With extractSheet.Columns(5)
.Value = .Value
End With
End Sub
That fixes the problem if code does ThisWorkbook.RefreshAll as I can call that helper sub after but I don't know how to cater for user pressing UI button.
You haven't actually connected the querytable to the class instance.
Revised qtclass
Option Explicit
Private WithEvents qt As Excel.QueryTable
Public Property Set HookedTable(q As Excel.QueryTable)
Set qt = q
End Property
Private Sub qt_AfterRefresh(ByVal Success As Boolean)
MsgBox "...
Though messes up query table - range extends for some reason.
> Note the following: - 'ExcludeFromProject' is implemented by RemoveCommand, which has been modified to suit. - I've changed the relationship between RemoveCommand and ExportCommand from inheritance to composition - it seems more appropriate. - Component removal now happens via a new method on the ProjectRepository, which ensures that a race condition on the 'ComponentRemoved' event cannot cause an access violation. This race did not manifest in VBA (due to timings and luck), but...
> **Rubberduck version information** Version 2.4.1.4796 OS: Microsoft Windows NT 10.0.17763.0, x64 Host Product: Microsoft Office x64 Host Version: 16.0.11727.20244 Host Executable: EXCEL.EXE
**Description** Running unit test when grouped "by outcome" is incredibly slow.
I have a fairly big project and if I run my unit test when grouped "by outcome" instead of e.g. "by location" or "by category" it takes a lot longer. For example for my project the times are:
> **Rubberduck version information** Version 2.4.1.4796 OS: Microsoft Windows NT 10.0.17763.0, x64 Host Product: Microsoft Office x64 Host Version: 16.0.11727.20244 Host Executable: EXCEL.EXE
**Description** If I run any test while Rubberduck is still parsing, e.g. during "Resolving references" etc then Excel freezes for 2-3 minutes, and finally displays a "Microsoft Excel is waiting for another application to complete an OLE action". When I click OK on the error message, everything pro
> **Rubberduck version information** Version 2.4.1.4796 OS: Microsoft Windows NT 10.0.17763.0, x64 Host Product: Microsoft Office x64 Host Version: 16.0.11727.20244 Host Executable: EXCEL.EXE
**Description** It seems to me that ModuleAttribute is deleted from the module by Excel on close. This might be an Excel issue that is either an issue on my end or just how Excel behaves in general. I only have one machine to test on, so I can't really check.
> Also, if I export the code after applying the fix before closing the document it does contain the ```vb Attribute VB_Ext_KEY = "Namespace" ,"Namespace Class Module" ``` line, so Rubberduck is clearly doing what I expect it to.
> Also, if I export the code after applying the fix before closing the document it does contain the ```vb Attribute VB_Ext_KEY = "Rubberduck" ,"Predeclared Class Module" ``` line, so Rubberduck is clearly doing what I expect it to.
> > *It will complain that I have a missing attribute.*
And if you export the module then, it's indeed missing? If so, I can try escalating this to the Excel product team, but I wouldn't think they'd consider it a high-priority bug... if RD is complaining about a missing attribute but the attribute is present, then the bug is on us.
> There is no bug with Rubberduck as far as I can see. It behaves as expected. The question is rather: "Given Excel's behaviour, what would be the most sensible Rubberduck behaviour".
Could anyone else try to reproduce this? It would be nice to know whether anyone else is seeing this behaviour.
It was super funny in my class on Exchange Server.
We had to figure out how many servers/disks it would take to run a system using an Excel-based calculator MS provided.
I didn't include my CPU specs, figuring I would just go with the default, and was getting a couple hundred servers and massive amounts of memory to support 100 users with 99.9999% uptime.
I asked her about it when working on my midterm, and she was all "I guess that's right...".
Working on my final, I found my mistake, and it ended up, IIRC, 2 servers and a few TB of data.
IIRC, I ended up configuring it with 1-2TB disks spinning at 7500 rpm and a standard Intel i7 CPU.
In another class (might've been the same prof, I forget), I went on a rant on how source control best practices work in my final.
assuming free shipping (bwahaha), sure - the garage wasn't able to find a used one; I'd have put it in the trunk and brought them the car and said "it's in the trunk, you put it in the right spot"
truth be told, a car with a dead transmission is dead to me
@MathieuGuindon honest question: how do the hybrid drive batteries do in the cold? I know that the standard lead-acid batteries can get a bit... finicky... in the cold, same issue or not for the LiOn(?) they use to power the electric motors?
@MathieuGuindon it's only 7 years old and needs a new tranny? That's not a good sign... How's the mileage (kilometerage...), is it still under warranty?
I think Hyundai has (had?) a 7-10 year warranty on certain portions.
7-10 years was pretty common in the 80-90s, especially from the American manufacturers as they tried to prove that their quality was as good as the imports.
The one thing I almost never see anymore are the 80/90s Camaros. It's like when GM stopped making them, they all evaporated off the roads. They're so rare 'round these parts, I'm shocked when I do see one.
@this sadly, with all the electronics, it's a major pain in the butt to replace - lots of electronics and you can't just do it in your garage in a couple of weekends...
@MathieuGuindon Oh! That explains a lot! A friend had a Saturn Vue with a CVT and it went kaput at around 35k miles. Cost more to replace than they paid used, so they junked it.
@this he bought an 03 about 3 years ago. it just had $5k of engine work done. Has had some issues with it, but loves it overall. and hard driving? Yeah, that's him.
@this eh?? it was a 2003 car purchased used in 2016. Has about... 180K(?) miles on it now. The previous owner had about $5k in refresh/upgrade/improvement work, then discovered that his 2 kids were about to become 4 kids and had to get something with more seating capacity.
@Hosch250 If you floor the throttle and the engine note doesn't change while the speedo slowly creeps upward, you have a CVT. If you feel it kick down to a lower gear, the engine speed climbs significantly and it actually accelerates, you have a "normal" auto.
The only problem is, (LOL), that if you are cruising just below the speed for it to shift, and abruptly floor the gas, sometimes it shifts the wrong way.
My brother who is into cars thinks it shifts that way because it thinks it needs more RPMs for some reason, or something like that.
So, if you are climbing a hill in my car, but it's not enough to make it shift, don't floor the gas--step on it just a bit to make it shift, then floor it.
@Hosch250 it should down-shift (lower numbered gear) to get the engine RPM up higher into the power/torque band to give you the grunt you need to accelerate as you've requested. You're saying you floor it and it up shifts so the RPM drops?
(Not that I'm a fan of flooring the gas--it's a lot harder on the car. My neighbor does that, and wrecks a new car just about once a year or two by trashing the engine.)
@FreeMan The RPM spikes, but the power to the wheels seems to drop.
Then, if you take your foot off the gas and re-apply it, it'll shift back by two.
And the RPM will crawl up and the car will accelerate too.
Not really "crawl" up, but bump up to the next notch, but not spike.
I've only had this happen about 5 times, so not really an issue worth risking them wrecking something else working on it, but I've been able to figure out how to reproduce it fairly reliably.
It almost seems like when riding a bike. You know, you could shift down and really rev up your legs, but go nowhere.
Or you could shift up and have the pedals a bit harder to turn, but give you more speed.
It feels like it shifts down, but then it really spins up the engine because the wheels are going faster than the engine can keep up at that gear.
I'd guess it's just a minor glitch in the automatic transmission software.
ugh. I hate it when an answer gets accepted and upvoted when it's not addressing crazy inefficiencies and pointing out blatant misuse of an API, while the correct answer just sits there ignored.
@Duga If we are not using a suspend action in the test runner already, it is super simple to segregate running tests and reparsing: just wrap the test runner invocation in a suspend action.
Why does the template contain an VB_EXT_KEY attribute? I am not sure whether all hosts support this attribute.
> I would honestly merge this PR as-is, I'm just concerned with the UX of having one out of (many) grids capable of persisting column positions. How do we feel about this @rubberduck-vba/dev?
Previously when activating between `LibrarySelect` and `ProjectSelect` the footer wouldn't update if a new selection wasn't chosen. Now the footer displays the correct information whenever focus changes.
> **Rubberduck version information** Version 2.4.1.4796 OS: Microsoft Windows NT 10.0.17763.0, x64 Host Product: Microsoft Office x64 Host Version: 16.0.11727.20244 Host Executable: EXCEL.EXE
**Description** Not entirely sure whether this is a feature request, change request, bug or what it is, but it generally concerns an issue I am having when writing tests that use loops to test systematics. First a bit of explanation of how I am used to `Assert` functioning.
You haven't actually connected the querytable to the class instance.
Revised qtclass
Option Explicit
Private WithEvents qt As Excel.QueryTable
Public Property Set HookedTable(q As Excel.QueryTable)
Set qt = q
End Property
Private Sub qt_AfterRefresh(ByVal Success As Boolean)
MsgBox "...
VBA Rubberducking
VBA Rubberducking