why do I feel like VBA is considered ‘old tech’ and ‘not worth anyone’s time’ yet still thriving since it gets the job done. I really enjoy NET when working with RD and learning it. But that’s a tremendous hurdle small companies can’t afford to leap over with a dedicated department.
The other key point is that you need nothing to get a VBA solution.
With a .NET solution, you now have to distribute a dedicated installer, ensure that everyone has the stuff they have to have, and most likely will need an admin privilege to install, etc. etc. etc.
That is (IMO) a big reason why VSTO failed
it simply did not lend itself to sharing very well and that's a big showstopper for the Morts who need to get their TPS report in by Friday 5 PM.
we'll have to see whether Office Script gets anywhere.
Starved for attention by IT groups, individuals turn to Excel to get their work done. Over time, they need more 'behavior' - "oh look, there's an IDE built into Excel!".
there's also another facet to this where people whose job isn't related to software development and they try to push development of gigantic VBA projects that are really difficult to maintain without stuff like RD.
im looking at you, system (in the HVAC sense) engineers who i work with, who refuse any and all suggestions from me to use stuff like RD to help them construct something in a sane manner
if you didn't grok MSI, then WiX would be frustrating because it's really a thin implementation atop the MSI layer
several of WiX XML actually map to some various MSI feature and WiX discourages scripting (for a good reason), so that it can be really flummoxing if you are excepting to just code your way to bang out an installer.
Maybe I got unlucky but back then (that was probably 7 years ago?) the documentation was not that great and I had to supplement my reading with MSI documentation
i wrote it like half a year ago and found the documentation to be helpful, so im guessing that the documentation has significantly improved since you last tried
@Cyril you're here. That already disqualify you as a Mort.
The archetypal Mort is filling up on his daily six-pack while watching reruns of Hee-Haws and Gilligan's Island so that he can forget the dreary duties he did today and will have to drag his sorry butt to work tomorrowin a haze.
sure, im just having trouble discovering why the test that @M.Doerner suggested returns an inspection result, while a similar test ProcedureNotUsed_Ignored_DoesNotReturnResult() does not return an inspection result
im in RubberduckTests.Inspections.ProcedureNotUsedInspectionTests.cs. The problem is that the test annotations, you can seem them in the test code in the issue, should not be returning an inspection result.
@this i mean, i try to learn abbout stuff, but catch myself doing either the safe thing i know to do, e.g., quick fix, or finding a more efficient, longevity driven approach which is usually more time than i have lol
@IvenBach always nice to have someone to struggle through it with lol
im not quite sure what an array is in VBA because i always think of arrays as they are in c/c++.
i would say that a collection in VBA is basically an easier-to-use array.
as for a List<T>, it's similar to a collection in VBA. i can definitely say that each entry must be of the same type T. im not sure if that's the case for collections, though, but it's definitely the case for List<T>
i work with dozens of people who only use VBA, so i constantly refer them to this project because i know they have tons modules and classes they could be testing better lol
when i did implement that annotation filtering based on a marker interface ITestAnnotation and it was filtering out those annotations, the inspection results still appeared
let me check
so the 1st test case is "@TestMethod(\"TestCategory\")", and i see the TestMethod annotation in that collection in ModuleParseResultsconstructor
that's without filtering the annotations
and then with the filtering, ModuleParseResults.Annotations is null, which is expected
@theVBE-it'srightforme it definitely is lol although im beginning to write more in c/c++/matlab than i am in c# nowadays
@this when you asked me if the dictionary i was using was Scripting.Dictionary or custom implementation, why was that? is the Scripting.Dictionary not particularly good?
They might have same data structure but the differences can be due to what they provide in their interface. For example, ArrayList is not generic, so you can stuff anything into it but Collection is usually generic, so it can only have a particular type. So ArrayList.
@theVBE-it'srightforme That is why "rubberducking" is a thing. :)
List<Foo> probably is just a List under the hood, but you have compiler enforcing that only a Foo can be added to a List<Foo> whereas List can contain Foo, Bar, Baz.
Thus, data structure could be same but functionalities aren't.
#Const LateBind = 0
#If LateBind Then
Public Function GetMyThings() As Object
#Else
Public Function GetMyThings() As Scripting.Dictionary
#End If
Set GetMyThings = CreateObject("Scripting.Dictionary")
End Function
I asked primarily because some choose to rewrite the implement so that the VBA can run on both Windows and Mac since Scripting library doesn't exist on Mac OS X.
@this back to what you were saying, is there any advantage in VBA to being able to use the generic versions over the non-generics like they tell you in C#?
so if i had a nice error message that popped up if someone did that so they didnt have to figure out what was causing the run time error that would at least solve the problem a bit
one time we inherited a legacy project that would not even compile - they had errors come out of woodwork and they claim that the application "works"....
@theVBE-it'srightforme well, there is some - you do get the semantics and you can ensure that the Add is strongly-typed
@jcrizk Why do you filter the annotations? What you should filter are the declarations for which a result is generated based on whether they have a test annotation.
@MathieuGuindon Hi Matt, I've tried the ListArray on my Notebook and I've Encountered error Run-time error '-2146232576 (80131700)' Automation error. From what I've googled, it's because i was missing .NET 3.5. So after install, everything works. Is this often missing from people's PC? I don't want to create addin that's dependable on installing something for non-admins.
It 'can' be possible I broke something. My question is primary - if there is a new installation of Windows with Office, is it possible that the functionality of ListArrays will not be enabled for them?
well, this is fun. AutoComplete sometimes triggers sometimes not...
> 2020-01-28 06:59:45.5546;DEBUG-2.5.0.5313;Rubberduck.AutoComplete.AutoCompleteService;Keypress was handled by SmartConcatenationHandler.;
The log shows that when it does, it shows nothing when I try and it doesn't. I see nothing in the log in the hot-key handlers about getting any sort of hooking set up, so I guess it doesn't involve that.
Plus, I'm still having issues with my ODBC connection to our Azure data base. :(
By 'declaration', do you mean filtering the inspection results? If so, I think that's what I stumbled upon being what I should try last night, but I couldn't figure out how to implement it.
I initially tried to filter the annotations because I think you had previously suggested it, but i found that it wasn't doing what I expected it to do; so, I ended up just walking through the debugger looking for something that might give me a clue.
@M.Doerner I got it from the Rubberduck.Parsing.VBA.Parsing.ModuleParseResults constructor. The change I made did actually filter the annotations, but an inspection result still appeared; so i figured i shouldn't be looking at the annotations and began looking elsewhere.
@Cyril I've been using Brave since you suggested it. One big drawback I've noticed - it doesn't remember a download location per URL like Firefox does. I've got to DL a lot of files, and FF does a great job of remembering "oh, you're at foo.com, so you want this to go to \\server\foo\downloaded" and "hrm, this looks like baz.net, so you want this file to go to c:\downloads\baz stuff crazy", etc.
@SonGokussj4 then you need a custom collection class, or non-mutating arrays. remember the only reason you're looking at this is because you're mutating an array.
I don't know what's up with Outlook of late, but it seems that it's just randomly crashing about once a week, taking the email I've been working on with it while not having saved a draft. :/
4 W2s, 2 1099s, and 3 proofs of health insurance (2 haven't come yet, but I only need them if I'm audited; I don't need to send copies of them in).
1 W2 from each employer and a 4th because of my IRA rollover.
A 1099 from my main savings account and another one from my CD.
@IvenBach Pretty much, yeah. Basically, I'm saying don't wrap a dependency inside some code and inject the wrapping code--inject the dependency directly, or make an explicit wrapper over it that can be injected and doesn't do anything except wrap it.
@FreeMan having just learned about the ctrl+# to quick swap tabs has been wonderful for me
i don't tend to have more than 7 at a time (i work from a SharePoint most of the time, so open up Opportunity location, get the archive folder, the executd folder, and the main documents plus reference links) so i use my tabs 3, 4, 6, & 7 most of the time.
@Hosch250 that sounds like being a constultant... always kind of hated that aspect of it
but, use intuit/turbotax to get all of the paperwork ready, but DO NOT file it... log onto the gov site and fill out exactly as in the PDF/reviewer and you just filed for free
The 4th W2 is because the company that bought my company out was shutting down the old retirement plan so I had to pull my money out and move it to another plan.
consulted for company A, their preferred vendor designation was removed so my sponsor worked to get another company to pick me up, B, so had each of those W2s, on top of two retainer-W2s and two other 02M gigs at the end of the year
Hey folks, new to Rubberduck, been doing VBA for ~5 months for automation purposes in MS Word, think I'm pretty good at it. Branched out to Excel and then XML/DOM/HTML manipulation about 3 months ago. Happy to be here.
For my company, bonuses are classified as extra income and taxed heftily. Pretty unfun to watch your sweet sweet dollhairs disappear at a rate of like 40%
VBA Rubberducking
VBA Rubberducking