Questions tagged [com]
Component Object Model (COM) is a component technology from Microsoft, featuring remoting, language independence and interface-based programming.
37
questions
13
votes
1
answer
1k
views
Low Level VBA Hacking - making Private functions Public
NEW: Download demo files
Not sure what to title this - essentially, inspired by RubberDuck's unit test engine, I've created a way to call private methods of standard modules in VBA. It also lets you ...
6
votes
1
answer
301
views
Simple python COM server to expose scipy integration to VBA
I want to create a COM server to expose scipy to VBA code, as performing integration is kinda difficult and I don't know of any good VBA/COM libraries for this. My objectives are:
As portable as ...
2
votes
1
answer
680
views
Getting hard-drive serial number on Windows
The point is to get the serial number of one of the hard drives on Windows. My code is based on an example from MSDN. I tried to make it an exception-safe, self-contained function. It works, to the ...
2
votes
1
answer
592
views
Create Word Document in C++
I am new to COM programming in C++ and while this code works welcome suggestions to improve readability/reliability. This creates a blank word document and adds the text Hello, World.
...
4
votes
0
answers
336
views
C# Dictionary Wrapper for VBA
I am a technical reviewer/writer and I use VBA for Word a lot to manage issues in Word documents I receive. I have frequently come across niggles when using Collections, Scripting.Dictionaries or ...
12
votes
1
answer
222
views
Not so Excellent Knight's Tour
Note: This is part of a set of demo applications I'm writing for colleagues to show we're not limited to VBA when dealing with Excel. Considering our IT challenges (no admin on-site & no local-...
2
votes
0
answers
312
views
(COM Callable) Python class to decompile *.chm file with Microsoft HTML Help Executable
Windows only. So I am writing code to decompile a Windows compiled html help file (*.chm) and then tidy the files found within. Whilst, I have blogged some simple Python examples I now want to ...
2
votes
0
answers
69
views
Updating Excel sheet with information from a DataTable
Basically, I'm trying to update an excel sheet using a DataTable (The columns structure between the two are not the same) with respect to the following rules:
...
3
votes
1
answer
953
views
SAFEARRAY export from a C++ DLL to VBA
My code is not very elegant, but I'm a total newbie in c++ and I consider it already a major achievement that I managed to write something that actually works.
As background, I'm defining in VBA the ...
10
votes
1
answer
2k
views
Automating the download of a GitHub repo
This script is designed to locate and download the first repository in your sidebar on the GitHub repository page. It downloads the .zip file for that repo and saves it to the default location.
I ...
11
votes
1
answer
202
views
Properly destroying the VBE
The disposable wrappers worked exactly as intended... and that turned out being a huge mistake:
That's because the .net runtime creates a Runtime Callable Wrapper per-type, not per-instance*; it took ...
7
votes
2
answers
448
views
A generic IEnumerator to enumerate COM collections
As I wrapped the VBIDE API, I encountered a number of "collection types" (Windows, CodePanes, ...
9
votes
3
answers
2k
views
Wrapping COM objects with IDisposable
One of the things believed to contribute to destabilizing Rubberduck 2.x, is the fact that a lot of COM object references are stored in many places, and ...
4
votes
1
answer
309
views
IDTExtensibility2 implementation for Rubberduck's entry point
Here is the new & improved Rubberduck 2.x entry point class, based on MZ-Tools 8.0's Connect.VBA implementation of the ...
12
votes
1
answer
612
views
Shared VB6 *and* VBA extensibility add-in with OnConnect and OnDisconnect handling
Rubberduck works well enough when the VBE is of the VBA variety, but it currently only works when the Rubberduck is configured to load at VBA start-up, and it has a tendency to crash the host ...