How to return a value from a text in the word using VBA?

  • Thread starter Thread starter TiagoNogueira
  • Start date Start date
T

TiagoNogueira

Hi folks.

Here's my question: i'd like to know either is possible to extract
value from a text in thw word by using VBA. let me try to be clear: Fo
example:
I got a table and the user will insert some information (in this case
numbers). And i need to retrive this information to make a msgbox tha
will show the total value. For this, I need to extract the values an
sum. Make the sum and the msgbox is not the problem. the problem is ho
to use this values.

Somebody?

[]'
 
Hi Tiago,

Do you want code to sum the values? If so, are the values in a column, or in a row? Are there any words or letters in the range you
want to sum?
 
Hi macropod..
No, that's nor the question.
I'm working with a multi-bookmarked document, and to name a bookmark
need to extract a number that is in a field in a table.

E.g: Tha value of the field is "2" so the bookmark name i'll be Bk2.
I know how to crete the bookmarks by vba, but i'm still looking how t
retrieve the number 2, that is in a field in the document.



'macropod[_2_ said:
;3094341']Hi Tiago,

Do you want code to sum the values? If so, are the values in a column
or in a row? Are there any words or letters in the range you
want to sum?

--
Cheers
macropod
[MVP - Microsoft Word]


"TiagoNogueira" (e-mail address removed) wrote i
message
Hi folks.

Here's my question: i'd like to know either is possible to extract a
value from a text in thw word by using VBA. let me try to be clear
For
example:
I got a table and the user will insert some information (in thi
case,
numbers). And i need to retrive this information to make a msgbo
that
will show the total value. For this, I need to extract the values and
sum. Make the sum and the msgbox is not the problem. the problem i
how
to use this values.

Somebody?

[]'s
 
Hi Tiago,

OK, so how do you know which cell in the table to extract the number from?

--
Cheers
macropod
[MVP - Microsoft Word]


TiagoNogueira said:
Hi macropod..
No, that's nor the question.
I'm working with a multi-bookmarked document, and to name a bookmark I
need to extract a number that is in a field in a table.

E.g: Tha value of the field is "2" so the bookmark name i'll be Bk2.
I know how to crete the bookmarks by vba, but i'm still looking how to
retrieve the number 2, that is in a field in the document.



'macropod[_2_ said:
;3094341']Hi Tiago,

Do you want code to sum the values? If so, are the values in a column,
or in a row? Are there any words or letters in the range you
want to sum?

--
Cheers
macropod
[MVP - Microsoft Word]


"TiagoNogueira" (e-mail address removed) wrote in
message
Hi folks.

Here's my question: i'd like to know either is possible to extract a
value from a text in thw word by using VBA. let me try to be clear:
For
example:
I got a table and the user will insert some information (in this
case,
numbers). And i need to retrive this information to make a msgbox
that
will show the total value. For this, I need to extract the values and
sum. Make the sum and the msgbox is not the problem. the problem is
how
to use this values.

Somebody?

[]'s
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top