@Mat'sMug would be good if PR’s owner can add tags like “PR-merge-ready” so you have a list of which is ready to go on your end so we don’t worry about “almost” ready for merge. This way, your tag list is good for you.
woopsie - your. "Ask _your_ ducky!": bring up Rubberduck's Code Explorer and navigate & search module members, organize your VBA projects with '@ Folder("parent.child") comments / module-scope annotations.
https://wordpress.com/post/rubberduckvba.wordpress.com/4113
I just got my hands into the VBA reference we have a link to on the wiki, their BNF notation is quite weird. Note, what are the chances that our grammar needs corrections? Recently that my code is getting bigger, I've been experimenting more parse errors for code that was perfectly correct...
@NelsonVides Minimum Complete and Verifiable Examples.
Eg. If you have a project with 34 modules and 12000 lines of code, but the Parse Errors are caused by 1 or 2 statements, reduce the problem down to the actual lines, and post an issue. The Parse Errors window should give you a clue about the root cause, but it can sometimes get the module right, but the line number wrong (but reasonably close to the problem, where the problematic line is usually just above the reported line number)
The line should be correct now, unless the error only occurs in the attributes pass. The log on error level or more verbose should actually tell you where things went wrong.
Please note that the parse error dialog will not show anything in case the parse failed due to an exception.
Situation:
I am trying to download files, for the latest available month, from the webpage NHS Delayed Transfers of Care. I am unable to locate these files, within the HTML, with confidence that my current code will continue to work over time.
Question:
How do I isolate the latest month with ...
> Rewrite of ComWrapperEnumeration in order to offer control of the underlying IEnumVARIANT RCW, which is sometimes leaking past OnDisconnection due to being GC'd The CLR automagically handles COM enumeration by custom marshalling IEnumVARIANT to a managed class (see EnumeratorToEnumVariantMarshaler) but as we need explicit control over all COM objects in RD, this is unacceptable. We need to obtain the explicit IEnumVARIANT interface and ensure this RCW is destroyed in a timely fashion,...
using Marshal.ReleaseComObject. The automatic custom marshalling of the enumeration getter method (DISPID_ENUM) prohibits access to the underlying IEnumVARIANT interface, and I can't find a way of turning off the automtic custom marshalling here. To work around it, we must call the IDispatch:::Invoke method directly (instead of using CLRs normal late-bound method calling ability).
> Thanks @bclothier. Yes, I've avoided changing the disposal responsibility of the returned RCWs, as I can see cases where the returned objects are cached/stored elsewhere, so implicit disposal would fail.
> Thanks @bclothier. Yes, I've avoided changing the disposal responsibility of the returned wrappers, as I can see cases where the returned objects are cached/stored elsewhere, so implicit disposal would fail.
Hi guys :-) So, maybe some of you remembers, before Christmas I proposed I would start translating RD into my own language (Czech). So - quick question about that. Should I make the Pull requests if I have for example parts of the translation complete or after I've done everything? I would like to, if possible, start to test the translations inside RD because it's not always possible to know for sure if the Czech translation corresponds well with the English one inside the program.
Czech is not so easy, we've got 7 cases, past, future tenses and so one and for example...
"Start" could be translated as:
"Začni" or "Začít" or "Začátek" or "Počátek" or "Započít" and so on... :-)
@SonGokussj4 Once you get started, we can help you get it set up so Czech shows up in the settings. Then you'll be able to run RD in debug mode and see your work.
When I merge the latest with my local master, I end up with RubberduckUI.resx showing changes (which I did not make). I noticed on one of the merge messages included "deleted resx locally" (or something like that). Not quite sure how to resolve this without introducing the 'false' change. ??
if you have a conflict saying .resx was deleted locally, keep that local deletion. then I presume git gets confused and claims there was a change to the legit .resx file; undo that change, and commit the merge
i really hate those stupid automatic implicit references. They create more problems than they solve and almost every code sample use them with abandon.
@Mat'sMug Still a bit unsure on the resolution: the lines that git claims are deleted on my master are like: <data name="TodoMarkerBug" - and two other 'TodoMarkers'. Do those markers belong IN or OUT of the resx file? (I'm thinking IN, but hoping to confirm).
@Hosch250 & @Vogel612: thanks for the reply. Well, I've got something translated already so I'll push it onto my forked repo and will try to do the Push Request thingie :)
In general actions should be in present tense, I think. Consider your Word application -File -> Open and File -> Save... does Czech use present tense for those actions?
(actually any application will do provided it's localized)
We've got so much tenses and horrible things you wouldn't believe. And if we don't, we just bend the ending of the word to do what we want to experss and everyone else (czech) understands that :-D
@IvenBach haven't you noticed the crap-ton of exceptions EXCEL.EXE is throwing (monitoring the debug output in the attached process while debugging RD, before loading RD)? Excel crashes, it's a feature. Save often.
@IvenBach put the vbe side-by side with its host. go to the vbe, make changes, hit Ctrl+S - you'll see Excel's status bar flicker as it saves your file.
@IvenBach Ctrl+S in the VBE invokes the host app's "save" command....
@Mat'sMug FWIW, I am aware that in some cases, the save are not flushed immediately. They get cached then flushed eventually to optimize the application. That's true w/ registry edits. IDK if that's the case w/ Excel but it matches @IvenBach's symptoms, FWIW.
@this I don't know the specifics, but would like to. I just know that I've had and occasionally do have Ctrl+S save a file followed with a crash that looses work that was/should-have-been part of the save.
@Mat'sMug So, what to do next, except continuing with the translation and making incremental PRs after a decent number of lines were translated. @Hosch250 said that I could potentially try it with dev build (which I download often anyway). Will it take a few days?
starting a new language from scratch could take a good 3-6 hours I'd say, depending on how fast you can translate things and how badly Visual Studio runs on your machine :)
@Mat'sMug FYI, we did have an offer to redo the Japanese translation back when we were in the middle of 2.0. You never re-pinged the guy, though, like he asked.
@Mat'sMug Well, I really like your project. I may not be as fast as "hey, translate these 200 new lines" "ok, got it within a hour" but I would like to really maintain it for as long as I can. :)
Knowing they are implicit is letting me look at them with a critical eye and ask myself how they can be properly rewritten.
It's the result of #GottaStartSomewhere. I don't fault the originator of this file. He did the best he could with what he had and learned as best he could.
Preemptive data validation: handle textboxes' KeyDown event and cancel invalid input before it's even written in the control!
https://stackoverflow.com/a/48308597/1188513
> I have a project with ~90 modules I want to put under source control. After cloning the remote repository through command-line (got HTTP 401 from the "Clone Remote Repository" command), all the files show up as "untracked" and need to be added manually.
Of course I didn't. I went back to CLI and did `git add *.cls` and `git add *.bas` and `git add *.doccls` and `git add *.frm` and `git add *.frx`, then refreshed the SC panel and proceeded to commit.
Situation:
I am trying to download files, for the latest available month, from the webpage NHS Delayed Transfers of Care. I am unable to locate these files, within the HTML, with confidence that my current code will continue to work over time.
Question:
How do I isolate the latest month with ...
VBA Rubberducking
VBA Rubberducking