Hello Ayush You have started a good topic,I think in this topic we can share our some tips and tricks.I am starting a topic ....... '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Diffrence between VBA & .NET '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' The short answer is that it would be very difficult to do VBA programming currently within Visual Studio.Net. Each MS Office product, however, supplies its own VBA development and debugging facility (though typically the VBA help file is not installed under the default options).
Up to now VBA (Visual Basic for Applications) has been an "interpreted" version of Visual Basic used in Microsoft's Office suite products, closely related to the Visual Basic "script" that is used in ASP and Windows Scripting Host. As such VBA is highly dependent on the Variant datatype (all variables are variants) and on COM. VB.Net eliminates the Variant datatype and moves the Visual Basic "theater" away from COM (however without burning bridges "behind" at this point). Microsoft has slated new tools for Excel and Word automation based on the .Net infrastructure to roll out with Office 2003 in "late summer". See here for the product announcement: [Visual Studio .NET and Office Development] http://msdn.microsoft.com/vstudio/office/ [Visual Studio Tools for Office] http://msdn.microsoft.com/library/en-us/odc_vsto2003_ta/html/VSTOIntro.asp One thing that VS.Net could be used for, related to VBA development, is the creation of OLE automation/ActiveX components using native C++. Provided that you build the automation interfaces (which is made fairly painless by the C++ wizards), these components can then be called in VBA once the appropriate references are added to the VBA "project". Admittedly that would not leverage either the simplicity of the VB syntax nor the extensive .Net runtime library, so it's a rather silly suggestion. It is also possible (but nontrivial) to call .Net libraries from within compiled VB6 code, but this is even further afield from what you want to do. Please post a request for clarification if one is needed. ''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' On Thu, Mar 18, 2010 at 9:56 AM, Ayush <jainayus...@gmail.com> wrote: > Hello Everyone, > > I request you all to share any tips or tricks that you have about MS > Excel in the group. It really helps. > > The tip can be anything like formula, most used calculation, excel > trick, hidden truth or could be anything which you think can be done > in an easier way. > > It can be any bug of excel also. Anything about excel that you > know....anything > > Sharing just increases the knowledge. > > Keep Posting... > > > Best regards, > Ayush Jain > Group Owner > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our Facebook Group @ > http://www.facebook.com/group.php?gid=287779555678 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,800 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe -- Thanks Regards Shyam Software Engineer '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' When one door of happiness closes, another opens; but often we look so long at the closed door that we do not see the one which has been opened for us. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' Wenn eine Tür des Glücks schließt, öffnet sich ein weiteres, aber oft schauen wir so lange auf die geschlossene Tür, dass wir nicht sehen ein, die für uns geöffnet wurde. - Helen Keller '''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''''' -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
