Quote:
Originally Posted by logank013
Just out of curiousity, how different is the language from VB to VBA
|
Differences from VB.NET to VB6 (which is basically VBA)
A more thorough comparion
Here's a reprint from the VisualBASIC Programmers Journal June 2001 discussing upgrading code with the wizard from VB6 to VB.NET
This is how you use Visual Studio 2005 instead of VBA in case you want the many features Visual Studio adds
Pay careful attention to the notes about
:
"A common problem when migrating VBA code to Visual Basic is ambiguous references. If the Visual Basic compiler cannot figure out where to find the value for a variable, you need to help the compiler resolve (or disambiguate) the reference. This is discussed in the example in this tip."
This can cause some fun and interesting problems when ignored.
Ask WikiPedia
Please note that some of the newer features of VB.NET could have been added to VB6.
For example with different syntax some features make an appearance in VBA7 which started with Office 2010 64bit:
https://msdn.microsoft.com/en-us/lib...ngVBA7CodeBase
There's a good way to check if you have 64bit VBA7 on this page
I know that when the 64bit version of Microsoft Office first shipped some operations took much longer to complete.
I had a massive spreadsheet used for QA at a semiconductor company.
It grew so large it needed the 64bit version and the calculation payload went from 17 minutes to 2 hours for the same code.