Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Please suggest Good web site for Word Macros and Word VBA 1
- Thread starter barnard90
- Start date
-
1
- #3
I agree with PH. Those are the top resources. Make sure you have access to VBA Help. Help is much improved. It is NOT part of the normal Office installation, so check that you do have it installed.
If you are using 2003, you can download a slightly more detailed compiled Help from Microsoft. I am not sure how much more help it will be though. The best thing is to to start doing it. Look at the many many examples in Help, try some. Post questions here - or at other useful sites.
The Word MVP site has some good stuff. But again, these are not really tutorials.
It is very useful to get a grasp of the Word Object Model. I know it looks scary - and from some perspectives it IS scary - but with some patience it can give some real understanding of the often interesting/bizarre aspects of Word.
There are some good technical articles here.
There are other decent forum sites, such as:
link ]VBAExpress[/url]
Woody's Lounge
Bottom line though....YOU gotta do it. As PH mentions, record some stuff, open the VBE and, well, start looking at what it there. F1 is IS your friend. F2 (the Object Browser) can be a bit daunting at first, and it is not complete...close but not fully. It can be handy though.
Do remember one important thing. The macro recorder does NOT do a lot of things, and a lot of things it DOES do are kind of messy. However, it is where most of us started, and pretty much all of us are self-taught...with a bit of help from the friendly folks here of course.
Oh....and take a look at the FAQ pages here. In fact...take a look at FAQ pages when ever you are offered them.
Lastly, as long as you do the normal safety things - uh, don't mess around with critical documents at first, ALWAYS do a save first, use copies of document not originals, backup, backup, backup - then really, you are not going to break anything.
Learn to use the debugging tools.
Try stepping through code rather than running it first. At the beginning it is not unusual to create endless loops and these are annoying because you have to crap out the application to stop them. Also stepping through code allows to to really watch what is happening.
Good luck! Remember - there ARE no dumb questions.
Gerry
My paintings and sculpture
If you are using 2003, you can download a slightly more detailed compiled Help from Microsoft. I am not sure how much more help it will be though. The best thing is to to start doing it. Look at the many many examples in Help, try some. Post questions here - or at other useful sites.
The Word MVP site has some good stuff. But again, these are not really tutorials.
It is very useful to get a grasp of the Word Object Model. I know it looks scary - and from some perspectives it IS scary - but with some patience it can give some real understanding of the often interesting/bizarre aspects of Word.
There are some good technical articles here.
There are other decent forum sites, such as:
link ]VBAExpress[/url]
Woody's Lounge
Bottom line though....YOU gotta do it. As PH mentions, record some stuff, open the VBE and, well, start looking at what it there. F1 is IS your friend. F2 (the Object Browser) can be a bit daunting at first, and it is not complete...close but not fully. It can be handy though.
Do remember one important thing. The macro recorder does NOT do a lot of things, and a lot of things it DOES do are kind of messy. However, it is where most of us started, and pretty much all of us are self-taught...with a bit of help from the friendly folks here of course.
Oh....and take a look at the FAQ pages here. In fact...take a look at FAQ pages when ever you are offered them.
Lastly, as long as you do the normal safety things - uh, don't mess around with critical documents at first, ALWAYS do a save first, use copies of document not originals, backup, backup, backup - then really, you are not going to break anything.
Learn to use the debugging tools.
Try stepping through code rather than running it first. At the beginning it is not unusual to create endless loops and these are annoying because you have to crap out the application to stop them. Also stepping through code allows to to really watch what is happening.
Good luck! Remember - there ARE no dumb questions.
Gerry
My paintings and sculpture
- Status
Similar threads
- Locked
- Solved
- Locked
- Helpful tip
