31–40 of 40 posts
Earlier quoted context omitted.
Not open source, but VBScript used to be embeddable in VB6 apps, I think VB.NET might have had something too?
Yes, you can host .NET runtime into another application. https://learn.microsoft.com/en-us/dotnet/core/tutorials/netc...
Earlier quoted context omitted.
I don't think VB6 (or really any prior VB) had a real spec, the language was basically QBASIC stitched on a form editor for VB1 and extended over time to add more stuff and after some point could also be embedded in other programs (hence "Visual Basic for Applications"). AFAIK this spec isn't even for VB6, but for a "VB7" (i.e. VB6 with a bunch of changes) that never really got a standalone version and Microsoft made…
I don't think so, or at least by VB5/6 they had moved on a long way. For instance VB6 compiled to native code rather than running as an interpreter. It could even create COM objects if you felt brave enough.
Earlier quoted context omitted.
I don't think VB6 (or really any prior VB) had a real spec, the language was basically QBASIC stitched on a form editor for VB1 and extended over time to add more stuff and after some point could also be embedded in other programs (hence "Visual Basic for Applications"). AFAIK this spec isn't even for VB6, but for a "VB7" (i.e. VB6 with a bunch of changes) that never really got a standalone version and Microsoft made…
Everything has a spec. What do you mean? It might not have had a written / formal spec, but Microsoft VB6 compiler itself is the spec in that case. I would assume that by VB6, however, something had been written down internal to MS.
Is there any open source implementation of VBA one can add to some application with limited effort? I'm thinking about adding macro-like functionality to one of my business applications and VBA would be the best, considering my users and Excel users intersect pretty well.
Earlier quoted context omitted.
and IIRC, datatype conversion made through excel formatting options. change cell display to get decimal :) fun
I'm pretty sure that modifying a cell's number format never affects the underlying value.
Earlier quoted context omitted.
Yes, you can host .NET runtime into another application. https://learn.microsoft.com/en-us/dotnet/core/tutorials/netc...
Yeah but my confusion now comes from the fact that I don't think VB is even updated by MS anymore.
Much better position than VB 6.
Earlier quoted context omitted.
Yeah but my confusion now comes from the fact that I don't think VB is even updated by MS anymore.
Kind of, it is still updated to keep being used in .NET latest, and at very least consume newer APIs, and profit from runtime improvements. Much better position than VB 6.
I do hope one day Microsoft open sources VB6. I think it would be quite an interesting thing to see.
Earlier quoted context omitted.
I'm pretty sure that modifying a cell's number format never affects the underlying value.
maybe not the actual memory data, but AFAIK it does affect the behavior of other logical / arithmetic functions in strange ways
Earlier quoted context omitted.
maybe not the actual memory data, but AFAIK it does affect the behavior of other logical / arithmetic functions in strange ways
Okay, thanks. If this is correct... it's unsettling and not cool.
operations people basically have to do workarounds for this all the time.