> With PR 3975, we introduced an analyzer project to help us validate some of RD's specific needs and thus automate code quality review in this manner.
The main impetus behind this was to help manage COM interaction which is often a source of memory leak or access violation. Though we have a couple analyzers already, we are missing the most common source -- chained access across safe COM wrappers class -- those will leak and thus must be alerted as an error to require that RD contributors man
> hi, a bracket matcher/ finder and auto-completion would be great.
**bracket matcher**
- For example, within a Excel equation within a cell the Excel shows you different colours so you can see where the matching bracket in your equation or function is. This would be tremendously useful In RubberDuck IDE. - - For example in UltraEdit you can press Ctrl+B and it will find the matching bracket for you:  the `VBENativeServices.VbeEventCallback` method.
This has been on the roadmap since forever 😄
We need to think of a neat API that makes it easy to use the same "hook" to later implement similar/related features, i.e. "insert [this code] when [this token] is typed in the editor". I can see a matching closing brace auto
> WHen I have CodeExplorer running and refreshed, it does not open any object (Form, Module, Class). I am double clicking on the parent in the tree and also the daugthers, nothing ... :
> Definitely not what's supposed to happen. Does navigation work off the search results toolwindow (e.g. "find all references" results), and/or off the inspection results toolwindow?
> Do you have logging enabled? If not, enable it at TRACE level, it's possible a COM exception is being thrown/swallowed. Having a stack trace might help diagnose.
> The Pending parser state button should be saying Ready ...something isn't right, I'd definitely be curious to see the logs. Does it work if you click the refresh button that says Pending in the Rubberduck commandbar and then try double-clicking again?
> I forced a ‘refresh’ on the Code Explorer twice, now it works ….hmmm…
I have turned on the logging to TRACE and if happens again will let you know.
One request – I did have the project password locked but I turned it off and then closed MSAccess and restarted; did not help with the issue, but it would be good if RD could prompt for a password just like the MSFT Project does when you try to open an object
From: Mathieu Guindon <notifications@github.com> Sent: Thursday, 24 May 2018
> So, uh, I totally got nerd-sniped, and got something like a skeleton of an autocompletion feature. needs refactoring and polishing and then a settings UI to enable/disable them, but anyway at this point I have ( autocompleting to (), " autocompleting to "", then [ to ] and { to }, and If True Then\n autocompleting the End If on the next line (unindented), so... I need some sleep :octocat:
Bevare of a one thing though. If you're really new to RD. If you add/delete some lines, RD will remember the position of a last refresh. So if you want to Refactor or do RD things, refresh before tthat.
> 8> System.IO.FileNotFoundException: Nelze načíst soubor nebo sestavení olewoo_interop.dll nebo jeden z jejich závislých prvků. Uvedený modul nebyl nalezen.
> 8> System.IO.FileNotFoundException: Nelze načíst soubor nebo sestavení olewoo_interop.dll nebo jeden z jejich závislých prvků. Uvedený modul nebyl nalezen.
8> System.IO.FileNotFoundException: Can't load the file or assembly olewoo.interop.dll or one of it's dependencies. Mentioned module was not found.
olewoo_interop.dll is there.
Did I mentioned that when I downloaded clean rubberduck-vba/next into my harddisk, opened the project and tried build it failed? Yours didn't?
Went to rubberduck Cloned repo Opened the project Build failed, Olewoo.interop.dll again https://pastebin.com/yiHgG5td PS> executionpolicy >>> RemoteSigned Everything OK with build of my fork: https://github.com/SonGokussj4/Rubberduck
@this No I've got it locally on my work computer. Yes, it's in OneDrive but locally saved. And it makes almost the same build error as downloaded clean rubberduck-vba/next
we definitely have the file and it is located correctly. Normally vS would have a yellow icon warning that a reference was missing and it hsouldn't be because I made sure to use relative path
just as a test --- can you change from Any CPU to x86 and rebuild?
in my build, I get a warning about mismatch in processor architecture, which is expected and did not cause a problem for me since generally, VS is x86 and Rubberduck.Deployment only runs during the build-time; it's not a part of the install/run time anyway.
oh, i get it now - the entry would be the powrshell
which has to be same bitness as the VS since it's VS that invoking it
This is my first crack at calling a REST API from my VBA code.
The API documentation is located here (PDF download). I'm attempting to use the example on page 8 of the PDF just to ensure that everything is working fine with the exception of not providing a location parameter since I don't yet k...
not saying it's not possible but for a complicated API based on REST or even old-skool protocols like SOAP, it's 100x easier to just do it in C# and provide wrapping methods to the VBA for consumption
Well, @this, had I gotten myself in gear a year ago and started learning C# then, I might be able to pull that off now, however, I didn't... :(
Am I correct in my understanding that the "real" results will be in .ResponseStream and I need to figure out how to get that slurped into a file or other VBA consumable form?
What's weird is that everything I've read, including MSDN seems to indicate that the response should be in .ResponseText, .ResponseBody, and.ResponseStream. I'm getting info in .ResponseText, but it doesn't seem to match up with what they say I should get.
It looks like it's either something in the way I'm calling it, or their API isn't returning what's promised.
the operative keyword I used was.... duplicative. ;)
they have 3 or 4 libraries that does what essentially amount to the same thing but with some extra features
e.g. WinHttp has better event handling, MSXML comes with some XML handling, and I forgot was the other thing
don't expect there to be any improvement/difference in the XMLHttpRequest implementation among the libraries; focus on the features you actually need from the library.
and take a time to thank MSFT for providing us with multiple choice of confusing and frustrating APIs. ;)
it's not something you'd use in your applicatoin - it's something to help you verify that the raw content of the HTTP request is valid before you write code to build the request and interpret the response
They have an API test site, but it doesn't really tell me anything useful - I'm able to select the function I want from their combo boxen, set parameters and presto-blamo, I get data back...
there's a company that's selling a bunch of packages. They call the entry-level package "something Complete". Want more? pay more for extra. So was it "complete"?
And then today, my installation of RD 2.2.0 was supposed to be done
But I find out that it was actually 2.1.1 again because after I sent 2.2.0 to software approval, they didn't send it to packaging! And packaging refuses to name them with the full version number after I SPECIFICALLY EMAILED them about that for this very reason!
So now I have to FOLLOW UP WITH EVERYONE AGAIN and yell at cheerfully request that they deliver me my dang software.
Can everyone PLEASE just do their jobs!?
But yes @FreeMan happy to do your headbanging for you since I'm already at it xD
As usual, each of these incidents individually would be no big deal.
But these are the back-breaking straws after two weeks of this.
For example, earlier in the process when I was just mildly disappointed, no one could tell me who the database approval was actually with, the approver was ignoring the emails I sent to them through the system while they remained anonymous, and I had to go all Liam Neeson on their ass just to get my requests to the next approval.
Would it not be easier to select the desired cell then hit Ctrl-C (windows) to copy the contents to the clipboard? It seems a bit overkill to write code to duplicate a built in function. Later, when you need to paste the value into a destination somewhere (in Excel or any other Windows application), you simply hit Ctrl-V, and _magic_™ happens. — FreeMan1 min ago
I work for a very large hospital system, so I feel your pain. Fortunately, we're a very small business group, we have one "IT" guy who isn't actually part of the IT department (which has miseries of its own), and me. He's got enough admin rights to give me local admin rights on my machine so I don't have to bug him all the time...
I am okay with that sort of thing too. I'm glad you have that going :)
I also have that going to various degrees - I personally contact people up and down the chain all the time to get my stuff through and they put up with it because I'm competent
.ResponseText: <!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>404 Not Found</title>
</head><body>
<h1>Not Found</h1>
<p>The requested URL /Appointments was not found on this server.</p>
</body></html>
If only it would give me that much when I pass it a valid URL...
but, if I take one character off the end of the API key I get my standard:
<p>Welcome to the Appointment-Plus RESTful Web Service/API.</p><p><strong>ws.appointment-plus.com</strong></p>
So, I wonder if that means they sent me the wrong API key...
PS F:\cleme_000\Desktop\Programming\Rubberduck> git update
Warning! `git update` has been deprecated;
Please use `git update-git-for-windows instead.
Git for Windows 2.16.1.windows.4 (64bit)
Update 2.17.0.windows.1 is available
Download and install Git for Windows 2.17.0 [N/y]? y
########################################################################################################## 100,0%
PS F:\cleme_000\Desktop\Programming\Rubberduck> git update
Fetching blessed
remote: Counting objects: 1014, done.
This is my first crack at calling a REST API from my VBA code.
The API documentation is located here (PDF download). I'm attempting to use the example on page 8 of the PDF just to ensure that everything is working fine with the exception of not providing a location parameter since I don't yet k...
VBA Rubberducking
VBA Rubberducking