Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
Hello Group,
Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
The filed NUMCHARS provides as result the number of characters without spaces. Copy this to Excel, paste as link (as unformatted text to assume the formatting of the destination) and when the doc changes the updated field result is automatically refected in Excel. It's a number that you could use as input in cell formulas if that's what you need. 'Graham F[_2_ Wrote: ;2480567']Hello Group, Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham -- Henk57 |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
Hi Henk57 Thanks for your reply, unfortunately Word is a black hole to me. I have looked at the object model to find NUMCHARS as mentioned in your reply and found wdFieldNumChars, which If I translate this correctly is going to count characters in a word field. So I could assign a variable to it. How would I get this to be present (printed) in Word to enable me to paste it to Excel? I am sorry to bother you, but I am at the begining of my learning. Any help would be appreciated! Thanx Graham "Henk57" wrote: The filed NUMCHARS provides as result the number of characters without spaces. Copy this to Excel, paste as link (as unformatted text to assume the formatting of the destination) and when the doc changes the updated field result is automatically refected in Excel. It's a number that you could use as input in cell formulas if that's what you need. 'Graham F[_2_ Wrote: ;2480567']Hello Group, Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham -- Henk57 |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
You can insert the NUMCHARS field directly using Insert | Field | NumChars
or by pressing Ctlr+F9 and typing NUMCHARS between the braces. When you copy/paste the field result into Excel, it will be pasted as a value, not a field. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham F" wrote in message ... Hi Henk57 Thanks for your reply, unfortunately Word is a black hole to me. I have looked at the object model to find NUMCHARS as mentioned in your reply and found wdFieldNumChars, which If I translate this correctly is going to count characters in a word field. So I could assign a variable to it. How would I get this to be present (printed) in Word to enable me to paste it to Excel? I am sorry to bother you, but I am at the begining of my learning. Any help would be appreciated! Thanx Graham "Henk57" wrote: The filed NUMCHARS provides as result the number of characters without spaces. Copy this to Excel, paste as link (as unformatted text to assume the formatting of the destination) and when the doc changes the updated field result is automatically refected in Excel. It's a number that you could use as input in cell formulas if that's what you need. 'Graham F[_2_ Wrote: ;2480567']Hello Group, Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham -- Henk57 |
#5
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
Many thanks Suzanne, can this be made dynamic (within Word), is there a way
to update it without using the "Update field" option on the right click mouse menu? Thanx Graham "Suzanne S. Barnhill" wrote: You can insert the NUMCHARS field directly using Insert | Field | NumChars or by pressing Ctlr+F9 and typing NUMCHARS between the braces. When you copy/paste the field result into Excel, it will be pasted as a value, not a field. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham F" wrote in message ... Hi Henk57 Thanks for your reply, unfortunately Word is a black hole to me. I have looked at the object model to find NUMCHARS as mentioned in your reply and found wdFieldNumChars, which If I translate this correctly is going to count characters in a word field. So I could assign a variable to it. How would I get this to be present (printed) in Word to enable me to paste it to Excel? I am sorry to bother you, but I am at the begining of my learning. Any help would be appreciated! Thanx Graham "Henk57" wrote: The filed NUMCHARS provides as result the number of characters without spaces. Copy this to Excel, paste as link (as unformatted text to assume the formatting of the destination) and when the doc changes the updated field result is automatically refected in Excel. It's a number that you could use as input in cell formulas if that's what you need. 'Graham F[_2_ Wrote: ;2480567']Hello Group, Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham -- Henk57 |
#6
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
Pressing F9 should update it, and it will update at print time or when you
switch to Print Preview. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham F" wrote in message ... Many thanks Suzanne, can this be made dynamic (within Word), is there a way to update it without using the "Update field" option on the right click mouse menu? Thanx Graham "Suzanne S. Barnhill" wrote: You can insert the NUMCHARS field directly using Insert | Field | NumChars or by pressing Ctlr+F9 and typing NUMCHARS between the braces. When you copy/paste the field result into Excel, it will be pasted as a value, not a field. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham F" wrote in message ... Hi Henk57 Thanks for your reply, unfortunately Word is a black hole to me. I have looked at the object model to find NUMCHARS as mentioned in your reply and found wdFieldNumChars, which If I translate this correctly is going to count characters in a word field. So I could assign a variable to it. How would I get this to be present (printed) in Word to enable me to paste it to Excel? I am sorry to bother you, but I am at the begining of my learning. Any help would be appreciated! Thanx Graham "Henk57" wrote: The filed NUMCHARS provides as result the number of characters without spaces. Copy this to Excel, paste as link (as unformatted text to assume the formatting of the destination) and when the doc changes the updated field result is automatically refected in Excel. It's a number that you could use as input in cell formulas if that's what you need. 'Graham F[_2_ Wrote: ;2480567']Hello Group, Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham -- Henk57 |
#7
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Counting Characters
Many thanx Suzanne, Problem solved!!!! Best wishes Graham
"Suzanne S. Barnhill" wrote: Pressing F9 should update it, and it will update at print time or when you switch to Print Preview. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham F" wrote in message ... Many thanks Suzanne, can this be made dynamic (within Word), is there a way to update it without using the "Update field" option on the right click mouse menu? Thanx Graham "Suzanne S. Barnhill" wrote: You can insert the NUMCHARS field directly using Insert | Field | NumChars or by pressing Ctlr+F9 and typing NUMCHARS between the braces. When you copy/paste the field result into Excel, it will be pasted as a value, not a field. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Graham F" wrote in message ... Hi Henk57 Thanks for your reply, unfortunately Word is a black hole to me. I have looked at the object model to find NUMCHARS as mentioned in your reply and found wdFieldNumChars, which If I translate this correctly is going to count characters in a word field. So I could assign a variable to it. How would I get this to be present (printed) in Word to enable me to paste it to Excel? I am sorry to bother you, but I am at the begining of my learning. Any help would be appreciated! Thanx Graham "Henk57" wrote: The filed NUMCHARS provides as result the number of characters without spaces. Copy this to Excel, paste as link (as unformatted text to assume the formatting of the destination) and when the doc changes the updated field result is automatically refected in Excel. It's a number that you could use as input in cell formulas if that's what you need. 'Graham F[_2_ Wrote: ;2480567']Hello Group, Please could you help with this problem, I need to count characters without spaces and pass the result to Excel either via VBA or any way else that might be possible without having to manually type the number in Excel. Thanks for any help in advance! Best wishes Graham -- Henk57 |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting 1 page as 2 | Page Layout | |||
word counting | Microsoft Word Help | |||
Counting Rows | Tables | |||
Counting common words? | Microsoft Word Help | |||
word doc keeps counting up | Microsoft Word Help |