Office XP VBA

[Allan]

I am just getting into office automation. I own Visual Basic 6 Pro and
Office 2000 developer edition. (but haven't taken them too far)

How close to Visual Basic 6 is VBA for Office XP and Office 2003?

(Do I need to get .NET?)


- Allan
Canada

 

[Charles Maxson]

Allan

If you are familar with VB 6, and have a solid understanding of Word objects
as a user (i.e. tables, field codes, bookmarks, etc), you are nearly an
'expert' already in Word development. The 'hill' you have to take is
learning the Word Obejct model, no small task BUT you won't need to master
it all; just the fundamentals (e.g. Document, Range ,Table, Bookmark
objects). Plus don't forget your best friend in Office development the macro
recorder... its always willing to bang out some code for ya (Tools | Macro |
Record New Macro...)

As far as .NET and Office... do you need it? No, is the short answer, VBA
and COM are still very powerful and perhaps a bit easier for the new Office
developer. Long term I would lead you the .NET way, but for now, {Alt} +
{F11} should get you going just fine...

 

[Word Heretic]

G'day Allan <[email protected]>,

use wot ya got. Lessons learned will repeate themselves in the
future.

I am just getting into office automation. I own Visual Basic 6 Pro and
Office 2000 developer edition. (but haven't taken them too far)

How close to Visual Basic 6 is VBA for Office XP and Office 2003?

(Do I need to get .NET?)


- Allan
Canada

Steve Hudson

Word Heretic, Sydney, Australia
Tricky stuff with Word or words for you.
wordheretic.com

If my answers r 2 terse, ask again or hassle an MVP,
at least they get recognition for it then.
Lengthy replies offlist require payment.