VBA array sort function?

Take a look here:Edit: The referenced source (allexperts.com) has since closed, but here are the relevant author comments: There are many algorithms available on the web for sorting. The most versatile and usually the quickest is the Quicksort algorithm. Below is a function for it. Call it simply by passing an array of values (string … Read more

VB6 to VB.net conversion

There is one that comes with vb.net. When you open a .vbp vb6 project, it asks if you would like to automatically convert it to vb.net. It does a pretty good job, exclusive of third party add-ons.

Is there a Visual Basic 6 decompiler?

For the final, compiled code of your application, the short answer is “no”. Different tools are able to extract different information from the code (e.g. the forms setups) and there are P code decompilers (see Edgar’s excellent link for such tools). However, up to this day, there is no decompiler for native code. I’m not … Read more

Does VBA have Dictionary Structure?

Yes. Set a reference to MS Scripting runtime (‘Microsoft Scripting Runtime’). As per @regjo’s comment, go to Tools->References and tick the box for ‘Microsoft Scripting Runtime’. Create a dictionary instance using the code below: or Example of use: Don’t forget to set the dictionary to Nothing when you have finished using it.

MSCOMCTL.ocx missing Windows 10

The ocx control should be in your Syswow64 (if 64 bit pc) folder and not in the app folder, and it needs to be registered manually (common vb6 problem in Win7, 8 ,10). It seems you can see the file, but it might not be registered. Run cmd in administrator mode, type regsvr32 C:\Windows\SysWOW64\MSCOMCTL.OCX. This … Read more

tech