This site uses cookies.
Some of these cookies are essential to the operation of the site,
while others help to improve your experience by providing insights into how the site is being used.
For more information, please see the ProZ.com privacy policy.
Jane Phillips France Local time: 16:36 Member (2013) French to English
Jan 26, 2016
This isn't about counting words in Excel cells, that I can do and there are already plenty of threads about it, this is about comments. I've just finished translating an Excel spreadsheet set up as a form to fill in and just before I finished I realised that the client had put comments for virtually every heading (to explain the terms used). I'd already quoted for the job based on the Trados wordcount, but Trados (Studio 2014) hadn't noticed the comments either ... See more
This isn't about counting words in Excel cells, that I can do and there are already plenty of threads about it, this is about comments. I've just finished translating an Excel spreadsheet set up as a form to fill in and just before I finished I realised that the client had put comments for virtually every heading (to explain the terms used). I'd already quoted for the job based on the Trados wordcount, but Trados (Studio 2014) hadn't noticed the comments either .
The translations were not complicated to do but obviously I hadn't included them in my word count so it was a bonus for the client and they were a pain to check through to make sure I'd done them all (on certain sheets the form was repeated up to 12 times to cover different types of information, so repetition of headings and comments as you scrolled down the page).
Spent half an hour with friend Google who didn't come up with a solution for counting words in comments.
Anyone else come across this and found the answer?
I have this horrible feeling it's really simple and I'm just not seeing it! ▲ Collapse
Subject:
Comment:
The contents of this post will automatically be included in the ticket generated. Please add any additional comments or explanation (optional)
Ben Senior Germany Local time: 16:36 German to English
Use a macro
Jan 26, 2016
Hi Jane,
You can either export all the words in the comments to Word or you can count them in directly in Excel. With the first method you can see what was in the comments and decide if that is what you want to count, sometimes the author's name is at the start of each comment and should not be counted. With the second method you just get a message box with the word count.
Here's the two macros that you need:
Sub CopyCommentsToWord() Dim xComment ... See more
Hi Jane,
You can either export all the words in the comments to Word or you can count them in directly in Excel. With the first method you can see what was in the comments and decide if that is what you want to count, sometimes the author's name is at the start of each comment and should not be counted. With the second method you just get a message box with the word count.
Here's the two macros that you need:
Sub CopyCommentsToWord() Dim xComment As Comment Dim wApp As Object On Error Resume Next Set wApp = GetObject(, "Word.Application") If Err.Number 0 Then Err.Clear Set wApp = CreateObject("Word.Application") End If wApp.Visible = True wApp.Documents.Add DocumentType:=0 For Each xComment In Application.ActiveSheet.Comments wApp.Selection.TypeText xComment.Parent.Address & vbTab & xComment.Text wApp.Selection.TypeParagraph Next Set wApp = Nothing End Sub
Sub CountCommentWords() ' Ben Senior 26 Jan 2o16
Dim iWordCount As Integer Dim iCommWords As Integer Dim sComment As Comment Dim xlBook As Workbook Dim xlSheet As Worksheet
iWordCount = 0 iCommWords = 0
For Each xlSheet In ActiveWorkbook.Sheets For Each sComment In xlSheet.Comments iCommWords = UBound(Split(sComment.Text, " "), 1) + 2 iWordCount = iWordCount + iCommWords Next sComment Next xlSheet
MsgBox "Total words in comments: " & CStr(iWordCount), , _ "Comment word count"
Manage your TMs and Terms ... and boost your translation business
Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.
The leading translation software used by over 270,000 translators.
Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop
and cloud solution, empowering you to work in the most efficient and cost-effective way.