Alternative IDE for VB6 and VBA
I've been spoiled by Visual Studio 2008 and Eclipse and have to do a little maintenance work on a Visual Basic 6.0 (VB6) application.
Is there an alternative/ updated IDE for Visual Basic 6.0?
A rewrite is not an option. I'm just fixing a couple of bugs and it's a big codebase.
I have never heard of an alternative IDE for Visual Basic 6.0 (VB6). However, these two (free) VB6 add-ins are indispensable and will make your life easier - especially if there is a lot of code. They are equally effective for VBA in Microsoft Office.
MZ-Tools: provides a superb collection of IDE tools - finding unused variables, unused methods, a great "search all", code snippets. Written by Carlos J. Quintero, to whom I now owe hours and hours of time.
And SmartIndenter, which takes care of all the auto-indenting. It does one thing and it does it well.
- Run-Time Error 91 (object variable or with block variable not set) on VBA Email code "mailItem.Display" after IF statements
- Deleting duplicate header rows
- Is there any difference between vbNullString and ""?
- Ascii Art using VBA
- How to obtain the full-path names of files read with WorkbookConnections
- How can export all part of columns to pdf file with VBA code?
- Difficult to run
- Allow User Input in Empty Cells, Prevent Editing or Deletion in Occupied Cells
- How can convert CJK's character in utf8 format with vba?
- How to prevent showing backing private fields of class properties in the Locals window?
- VBA Filter Column Store Unique Values of Another Column
- How do I use checkboxes in an IF-THEN statement in Excel VBA 2010?
- How do you extract email addresses from the 'To' field in outlook?
- Excel Find and replace using variables
- How to do a row-wise sum in an array formula in Excel?
- Putting Textboxes into array for formatting
- Code inserting and copying to the wrong worksheet
- Get values from available column in a row to the first column of the same row
- Excel VBA, Can't Find DLL Entry Point from a DLL file
- VBA - Worksheet.activate not working
- Access TextBox does not update during VBA loop, only after
- Check for consecutive characters in an excel cell
- Add text to first available cell in range with non-contiguous cells
- Data Entry Transfer to Multiples Tables to Specific Sheets
- How to access textBox placed on sheet in VBA module?
- Looking to create a copy of a document and copy data from Excel (words and tables) into it at bookmarks
- Only loop selected rows in Excel VBA
- Get MAPI Folder in Outlook from Folder Path
- AutoFilter returning to 1st Range when trying to apply filter to different Range
- Reorder sheet names in custom order