Using VB (VS 7.0) to dev Excel macros etc.
-
Hi Guys, Currently I use Office 2003 VBA to develop macros userforms etc for my Excel sheets. I was wondering if it is possible to use vb.net that comes with VS 7 to develop all of the above. The reason I am asking is that in VBA the controls etc are not as 'nice' as the ones in vb.net and there are more features and so on. Also I realy want to learn VB.net (as I am told the syntax is different and it is more powerful than VBA). Anyway if someone could give me some basic pointers on the whole issue that would be great.
-
Hi Guys, Currently I use Office 2003 VBA to develop macros userforms etc for my Excel sheets. I was wondering if it is possible to use vb.net that comes with VS 7 to develop all of the above. The reason I am asking is that in VBA the controls etc are not as 'nice' as the ones in vb.net and there are more features and so on. Also I realy want to learn VB.net (as I am told the syntax is different and it is more powerful than VBA). Anyway if someone could give me some basic pointers on the whole issue that would be great.
You need Visual Studio Tools for Office. http://msdn.microsoft.com/vstudio/office/officetools.aspx[^] Kevin