Getting started with VBA

[Adam.Effinger]

Ok, so I have very little experience with this format/lanuage, but I
would like to learn and be able to do things pretty effeciently.
Here's what I want to do (and I know it's easy, just now how)
I want to from MS word open an excel application (compelted). With
that, I would like to search through the tables in word and paste some
of those into excel. Some of those cells are empty, so I would like to
check them to make sure that my code of copy-paste would be effective.
Any help would be great.

Thanks,
Adam

 

[Jean-Guy Marcil]

Adam.Effinger was telling us:
Adam.Effinger nous racontait que :

Ok, so I have very little experience with this format/lanuage, but I
would like to learn and be able to do things pretty effeciently.
Here's what I want to do (and I know it's easy, just now how)
I want to from MS word open an excel application (compelted). With
that, I would like to search through the tables in word and paste some
of those into excel. Some of those cells are empty, so I would like
to check them to make sure that my code of copy-paste would be
effective. Any help would be great.

Here is a little something to get you going:

http://word.mvps.org/FAQs/MacrosVBA.htm#BeginnersTips
and
http://word.mvps.org/faqs/interdev/controlxlfromword.htm

 

[Adam.Effinger]

Adam.Effinger was telling us:
Adam.Effinger nous racontait que :


Here is a little something to get you going:

'Macros/VBA' (http://word.mvps.org/FAQs/MacrosVBA.htm#BeginnersTips)
and
'Control Excel from Word
(http://word.mvps.org/faqs/interdev/controlxlfromword.htm)

Thanks for those articles. I am still trying fo figure out how to tel
if I'm at the end of a word document so I repeat the search from th
top... Any Hints

 

[Jean-Guy Marcil]

Adam.Effinger was telling us:
Adam.Effinger nous racontait que :

Thanks for those articles. I am still trying fo figure out how to
tell if I'm at the end of a word document so I repeat the search
from the top... Any Hints?

Compare the end of the range of the document you are working on with the
value of the end of the document according to
ActiveDocument.Range.End