Is the language spec for Visual Basic 6 available anywhere?
Visual Basic for Applications Language Specification [pdf]
21–30 of 40 posts
Re: Visual Basic for Applications Language Specification [pdf]
#22Earlier quoted context omitted.
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.
> It could even create COM objects if you felt brave enough. Not just "brave enough" - but everyone, honestly. After VB4 and Windows 95, VB's raison d'etre was all about being a glue-language for anyone, regardless of ability level, to piece-together OLE/COM/ActiveX controls and components together onto a form/window surface and ship it the same day. ---- COM only requires bravery if you're lucky enough to be require…
Re: Visual Basic for Applications Language Specification [pdf]
#23Is 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.
Not open source, but VBScript used to be embeddable in VB6 apps, I think VB.NET might have had something too?
https://learn.microsoft.com/en-us/dotnet/core/tutorials/netc...
Re: Visual Basic for Applications Language Specification [pdf]
#24Earlier quoted context omitted.
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.
> It could even create COM objects if you felt brave enough. Not just "brave enough" - but everyone, honestly. After VB4 and Windows 95, VB's raison d'etre was all about being a glue-language for anyone, regardless of ability level, to piece-together OLE/COM/ActiveX controls and components together onto a form/window surface and ship it the same day. ---- COM only requires bravery if you're lucky enough to be require…
Yes, the tooling is still clunky, regardless it being the main way to expose Windows APIs nowadays.
Re: Visual Basic for Applications Language Specification [pdf]
#25Earlier quoted context omitted.
> It could even create COM objects if you felt brave enough. Not just "brave enough" - but everyone, honestly. After VB4 and Windows 95, VB's raison d'etre was all about being a glue-language for anyone, regardless of ability level, to piece-together OLE/COM/ActiveX controls and components together onto a form/window surface and ship it the same day. ---- COM only requires bravery if you're lucky enough to be require…
COM has become iunknown ;)
Re: Visual Basic for Applications Language Specification [pdf]
#26Is 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.
Not open source, but if you are ein Windows, youncnanuse the Windows Script Host via COM: https://learn.microsoft.com/en-us/previous-versions//a74hyyw...
Re: Visual Basic for Applications Language Specification [pdf]
#27Re: Visual Basic for Applications Language Specification [pdf]
#28Is 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.
IMHO the trick is that any moderately useful and modern VBA is likely to go way beyond the base specification. - UserForms GUI (which this does not touch on at all) - Microsoft libraries like mscorlib and Microsoft Scripting Runtime, to get stuff like ArrayList and FileSystemObject. - Excel VBA is kind of notorious for mixing Excel code with the VBA, using cells of the sheet as data storage, using formulas inside of…
Re: Visual Basic for Applications Language Specification [pdf]
#29Is 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.
IMHO the trick is that any moderately useful and modern VBA is likely to go way beyond the base specification. - UserForms GUI (which this does not touch on at all) - Microsoft libraries like mscorlib and Microsoft Scripting Runtime, to get stuff like ArrayList and FileSystemObject. - Excel VBA is kind of notorious for mixing Excel code with the VBA, using cells of the sheet as data storage, using formulas inside of…
Re: Visual Basic for Applications Language Specification [pdf]
#30Earlier quoted context omitted.
IMHO the trick is that any moderately useful and modern VBA is likely to go way beyond the base specification. - UserForms GUI (which this does not touch on at all) - Microsoft libraries like mscorlib and Microsoft Scripting Runtime, to get stuff like ArrayList and FileSystemObject. - Excel VBA is kind of notorious for mixing Excel code with the VBA, using cells of the sheet as data storage, using formulas inside of…
and IIRC, datatype conversion made through excel formatting options. change cell display to get decimal :) fun