ThunderFrame

Results 24 comments of ThunderFrame

I think the Global enumerable collections would be good candidates for Fakes. ```vb Set v = Fakes.Excel.Workbooks("Foo.xlsm") Set x = Fakes.Excel.Worksheets("Settings") Set y = Fakes.Excel.Sheets("Report") Set z = Fakes.Excel.Addins("Foo") ```

let's just tweak "replace all" and make it "replace all selected"

If I change QueryClose's CloseMode parameter type to vbQueryClose I get a Compile error: > Procedure declaration does not match description of event or procedure having the same name

I'm hoping I can lift the names from the list box, or with sendkeys. In addition to the 950+ commands, those would also be 950+ late-boynd members of WordBasic.

The functions that are allowed in an Enum expression (as per spec section 5.6.16.1), are the "intrinsic functions": `Int, Fix, Abs, Sgn, Len, LenB, CBool, CByte, CCur, CDate, CDbl, CInt,...

Posted an SO question: [How do I create a module defined function in a COM Type Library](https://stackoverflow.com/questions/44510639/how-do-i-create-a-module-defined-function-in-a-com-type-library)

@retailcoder Procedure not used applies to *any* usage, but for a class, you might want *every instance* to have an member invoked at least once. ```vb Sub test() Dim c...

We're going to need the DAO Interop anyway, but once we have that, the collation is available with `CurrentDB.CollatingOrder`

Would a helper function be, um, helpful? Ignoring Access, for now.... ```vb Function ModuleCompareType() As VbCompareMethod If StrComp("A", "a") = 0 Then ModuleCompareType = vbTextCompare Else ModuleCompareType = vbBinaryCompare End...

Once we have the ITypelib for each project, we should be able to have a fully populated Code Explorer without necessarily needing to reparse the source. I guess the ITypeLib...