VB 6.0 & VBA vs .net confused??

[rekidadra]

I want to create solid applications (generally about engineering) in excel with the help of some real computer language or VBA. At this point either I will start learning Vb 6.0 & VBA or start learning .net. I know that .net is not fully supported in office application yet. But most probably soon it will be. I already know object orienting concepts through JAVA.

So, I am quite confused about where to start.

[Hack]

Welcome to the forums.

Given your goal of developing Office Applications, I would stay with VBA, although learning what you can about .NET is probably a good idea as you would be ahead of the game when such time arrived that .NET was supported in Office Applications.

[RobDog888]

.NET PIAs only support Office 2002 & 2003. You can program in .NET for other version of Office but you loose deployability when you do so.
Office 12 wont be out until late next year at the earliest but if you have multiple versions of Excel to automate then VB6/VBA will be
a good starting place since that code can easily be converted to .NET with minor modifications.