[EXCEL] Improve VBA IDE

Printable View

Jul 13th, 2009, 07:13 AM
agmorgan

[EXCEL] Improve VBA IDE
After using some IDEs in other languages for a few years, coming back to do a bit of VBA has left me feeling quite frustrated and unproductive!

A few things that immediately spring to mind are:
1. Delete a whole line (and a keyboard shortcut)
2. Duplicate a whole line to the line below (and a keyboard shortcut)
3. Refactoring
4. Highlight other instances of selected word
How would I go about implementing this myself?
Refactoring would be a lot harder so lets focus on the first 2 to start with.

I don't really know how the Add Ins work, can they be created in VB(A) or are they C++?
Jul 13th, 2009, 08:37 AM
Siddharth Rout

Re: [EXCEL] Improve VBA IDE

Quote:

Delete a whole line (and a keyboard shortcut)

Ctrl +Y
Jul 13th, 2009, 09:22 AM
si_the_geek

Re: [EXCEL] Improve VBA IDE

I don't think you can use VBA to create an addin, but you can use VB6.

It has been a while since I've done it, but I'm fairly sure that the way they interact with the code is as a group of arrays - one containing each line of code, and one containing the start position of each Sub/Function/etc, and a few others too.

While it doesn't have the features you asked about, MZTools (link in my signature) has a VBA edition, which I would recommend.
Jul 13th, 2009, 06:53 PM
agmorgan

Re: [EXCEL] Improve VBA IDE

This page (and others on msdn) says that you can create them from VBA
http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

However, I fail on step 3

Code:

From the File menu, select New Project, and then select Add-In Project.

I am using Office 2007 and this page is referring to Office XP.

Is it something that was taken out between versions or is it perhaps a feature that is not available in the license that I have?

Does anyone else have it?
Jul 14th, 2009, 03:53 AM
westconn1

Re: [EXCEL] Improve VBA IDE

well i do not see any such option in excel 2000
Jul 14th, 2009, 04:07 AM
si_the_geek

Re: [EXCEL] Improve VBA IDE

It isn't made very obvious, but it seems to me that article is for the Developer edition of Office - so editions like Standard/Pro/... probably won't have it.
Jul 15th, 2009, 06:33 AM
agmorgan

Re: [EXCEL] Improve VBA IDE

I can't seem to find the developer edition on the Microsoft site.
Is it called something else in 2007?
Jul 15th, 2009, 08:04 AM
si_the_geek

Re: [EXCEL] Improve VBA IDE

The 2007 editions do not seem to include anything like it.

I'm fairly sure it isn't available any more (and vaguely remember Robdog888 commenting on it), but couldn't find any useful info. A search on Amazon only found developer editions for Office XP or earlier.

I have a suspicion that VSTO (Visual Studio[.Net] Tools for Office) is capable of creating addins, but have no experience with it.