if (classModule.DeclarationType.HasFlag(DeclarationType.Document) ||
classModule.DeclarationType.HasFlag(DeclarationType.UserForm))
{
AddUserTypeLibImplementedInterfaceNames(classModule);
}
so here we are
2019-06-11 23:27:12.6270;TRACE-2.4.1.42089;Rubberduck.Parsing.VBA.ReferenceManagement.CompilationPasses.TypeHierarchyPass;Module Sheet1 implements COM interface _Worksheet.;
2019-06-11 23:27:12.6591;TRACE-2.4.1.42089;Rubberduck.Parsing.VBA.ReferenceManagement.CompilationPasses.TypeHierarchyPass;Module ThisWorkbook implements COM interface _Workbook.;
2019-06-11 23:27:12.6591;TRACE-2.4.1.42089;Rubberduck.Parsing.VBA.ReferenceManagement.CompilationPasses.TypeHierarchyPass;Module Sheet1 implements COM interface _Worksheet.;
woo-hoo!
2019-06-11 23:27:07.2900;INFO-2.4.1.42089;Rubberduck.Parsing.Common.ParsingStageTimer;Loaded and unloaded referenced libraries in 48219ms.;
less cool
I'm missing something
2019-06-11 23:30:48.8470;INFO-2.4.1.42089;Rubberduck.Parsing.VBA.RubberduckParserState;RubberduckParserState (2) is invoking StateChanged (LoadingReference);
2019-06-11 23:30:49.5321;INFO-2.4.1.42089;Rubberduck.Parsing.Common.ParsingStageTimer;Loaded ComProjects for user projects in 228ms.;
2019-06-11 23:30:49.5401;INFO-2.4.1.42089;Rubberduck.Parsing.Common.ParsingStageTimer;SyncUserComProjects: no work to do.;
2019-06-11 23:30:49.7270;TRACE-2.4.1.42089;Rubberduck.Parsing.VBA.ComReferenceLoading.COMReferenceSynchronizerBase;Loading referenced type 'VBA'.;
> This PR will introduce modifications to the parser, using the data collected from the user project typelib to resolve the interfaces implemented by document modules.
The original intent was to address a handful of "easy" inspection issues (started with that anyway)... once completed, this PR will fix #4998 ...and potentially a bunch of other issues (needs verification).
I have a procedure for looping through all files in folders and subfolders starting at a folder which the user can select. The user can select both the source and target folder. I'm using Excel VBA for this. The worksheets contain all the files names or part of it, to search for.
It works like ...
> Just for completeness' sake: The inspection is not only ignoring `'@IgnoreModule` annotations but also when we explicitly set `'@Ignore UnderscoreInPublicClassModuleMember` for the respective procedure.
(And yes, I've also stumbled upon this due to vbWatchdog.) :)
I have an Execute SQL Task that was pulling several columns and mapping it to a Package-scoped User:: object variable, then passing control to a ForEach Loop.
Now I've expanded the SQL Query to pull one additional column from the table in the Exec SQL Task. I've updated the variable mapping on the ForEach, but it's throwing an error when I run:
> Error: 0xC001F009 at Package: The type of the value (DBNull) being assigned to variable "User::DataTypeFlag" differs from the current variable type (String). Variables may not change type during execution. Variable types are strict, except for variables of type Object.
Which is telling me that the newly added column mapping isn't working.
I've copy/pasta'd the SQL from the Exec SQL Task into SSMS and it runs correctly, pulling valid (non-Null) data from the table.
Is there something somewhere somehow that I need to refresh the ForEach to get it to realize that the record set it's being fed has changed?
Nope, I'm a nimnod.
I added the column to the query in the wrong place so my assignment to the User::DataTypeFlag, which I thought was column 3 was actually column 4.
I've cloned rubberduck. I've installed the c++ compilers. I've read the build wiki. I've created and built a VBA library in C#. However I'm clueless as to how to compile (just for the heck of it) rubberduck on my machine. Is there a handholding guide for VBA wanna be's who want to scare the pants of themselves by having a private fiddle with Rubberduck code.
@Freeman Yes C# is installed. F6 does nothing. Build solution just produces 18 warnings that packages have already been downloaded but otherwise does nothing else.
@Freeflow You'll have to wait for someone more knowledgeable than I to wake up and stumble into the room. They'll be here and definitely point you in the right direction, though.
I've cloned rubberduck. I've installed the c++ compilers. I've read the build wiki. I've created and built a VBA library in C#. However I'm clueless as to how to compile (just for the heck of it) rubberduck on my machine. Is there a handholding guide for VBA wanna be's who want to scare the pants of themselves by having a private fiddle with Rubberduck code.
@Freeflow assuming Rubberduck.Deployment is the solution's startup project, hitting Ctrl+Shift+B should build the solution, and F5 should build and launch the program you specified in the "debug" page of the deployment project properties (I put EXCEL.EXE there); the VS debugger will attach to the process when the VBE is loaded (Alt+F11).
Thank you all! I've managed to get my SSIS package created, tested, deployed and called from my VBA code. I've still got to do the looping in VBA to see when it's completed and send out some results, but overall I'm quite pleased with my accomplishment.
I've gotten something done, so that means it's the weekend now, right?
@SonGokussj4 localization is hard... I don't think there's an easy solution for this
does Czech plural scheme originate from finger-counting? if so, I find it rather awesome that it starts saying "ok, now that is plural" when the number needs 5+ fingers :)
@M.Doerner I'm afraid I'm using VS 2019. I removed Rubberduck for VS 2019, recloned, selected RubberDuck.Deployment as the startup project (not Rubberduck.Deployment.Build). Trying to get into the properties.application or properties.Build pages just gives an error trying to load the page. I guess I'll have to wait a while. No worries.
Yes, it is stored in the .suo file.
Here's a similar post explaining why.
lame, IMO
Frequently, you'll have a project which is very likely to be most people's desired startup project for debugging (eg. website), and you don't want a class library as a startup project. I don't see why MS couldn't provide a proper mechanism (not what seems like a hack, ie. putting the default one at the top in the .sln file) for setting a global default startup project, and then allowing an .suo to override it if desired. — JezFeb 24 '12 at 12:28
even though you may get up to 15 digits of precision, it doesn't mean it will stay that. rounding errors can easily compound well beyond the 15th digits
> ♫ Hello epsilon my new friend. My rounding probs be at an end ♫
@this With this you piqued my curiosity, again.
This occurs because of 0.1 unable to be perfectly represented in binary. The subsequent rounding errors accumulate in adding and evident when comparing to 0.3?
Why does 0.1+0.1+0.1+0.1+0.1=0.5 evaluate to true?
i've been double verifying using calculator but it's not good for documenting all the steps of calculations
it's embarrassing when you think about it --- using a calculator to validate Excel's half-assed calculations because you're wanting to validate SQL Server's calculations....
Finally :D After 2-3 years of working on this project of mine for one person, I remade like for the 5th time "loading controls in the form", now with informations totally within each of the Control class and... My god, it's like a magic :-D Even my superior complimented me today :-D Adrenalin in my veins...
Finally I think I'm doing something within this project "correctly" :-D
And it's thanks to you too. Mainly @MathieuGuindon. Because I wanted to create something like an interface but ended half the way. (Don't understand interfaces yet...)
For those that are interested, this is my "own" class for loading and manipulating TextBoxes within my form :-) I know there are MANY flaws (but I don't know where... :D and which...) but if you want to look :D
And when you modify a control (write/change text into textbox, select different ComboBox item), it will change it's background color and if you hit save, it will know where and what to save. If you hit reset, it will return to it's initial value.
+ there are ComboBoxes which you change and it will change another's ComboBox list of values.
Yeah ^_^ 2-3 years of my work from nothing and with like month of VBA experience.... :D I asked many and many questions here and folks here are the best... Even though they don't have much time they helped me much.
@MathieuGuindon I know. I want hide. But then I'm not sure if that wouldn't break things. For now :-) but I will keep that in mind. I read through your article like 5-times already.
if you've shown the default instance, it just silently re-initializes a new default instance right when you next reference it -- typically when you try to read state from controls
....which arguably doesn't matter much in this particular case
I see. I remember when I was more naive, I tried to implement self-destruction and found that the instance just didn't destruct. It just silently ignored the Set it = Nothing or whatever I was doing.
still, I find Unload Me fundamentally wrong... "unload this instance, but hey keep it around because I still have 20 lines of code to run in that method"
@MathieuGuindon I "partly" understand. I created this "new design" like 2 weeks ago and I didn't get to the part, where I "open new form that is data-related to the parent form" yet. That will be a challenge too. For example:
@this IIUC Set UserForm1 = Nothing would run the Terminate handler, and then doing Debug.Print UserForm1 Is Nothing would run the Initialize handler (re-create the default instance) just before the Is Nothing check, ...which would return False
When I get there, I will try my best to implement that hide. I didn't understand much the "programmatically closing" part. Yet :-) Will get there soon. Hope so. I will print screen these advices for the future reference.
@this: it would, with link to a tutorial for even beginners to understand with examples, what to do differently. :-)
Isn't there a VB setting that goes in a module that tells the VBE what to call said module when it's imported? And isn't there an RD annotation to set that?
well, slightly asymmetric pile of carp. I can't get my SourceImport routine to import into my .accdb. It had been working just fine a week or two ago...
I can dragon drop a .bas or .clsinto the default VBE Project Explorer but it will name it Module x (because I don't have Attribute VB_Name = "FooAllTheBars" in most of my modules), but then I have to go rename them all.
and Code Explorer doesn't seem to accept dragon droppings. (Or other asymmetric piles of poo emoji)
oh, even better. It works intermittently. :poo:
And... all the crashes whilst trying to import have broken several of my external table links. :(
you mean the one where you have to pick from one of their pre-assigned "shortcut" locations or wander through a list of "recent" locations instead of just popping the standard "save as" dialogue box that everyone has gotten used to since, oh... Win95 (that's 24 years of habits there, folks)? Yeah, "horrid" is very generous
> This should be pretty straightforward. We only need to check whether the inspection result is isngored for the module or member within the inspection.
Something like the following needs to be put into the inspection. https://github.com/rubberduck-vba/Rubberduck/blob/0db534ed9b63f4ff84b36baf3ae9ad89b1749486/Rubberduck.CodeAnalysis/Inspections/Concrete/AssignmentNotUsedInspection.cs#L73-L78
> I really think we should move these checks to the base class or let the results expose a property indicating whether they are ignored and filter on that in the inspection base class.
It is just too easy to forget to implement this filtering in every inspection.
I have a procedure for looping through all files in folders and subfolders starting at a folder which the user can select. The user can select both the source and target folder. I'm using Excel VBA for this. The worksheets contain all the files names or part of it, to search for.
It works like ...
Yes, it is stored in the .suo file.
Here's a similar post explaining why.
VBA Rubberducking
VBA Rubberducking