Counting number of words in a sentence and highlighting or commenting
I found some old code, from Helmut of Bavaria I believe, that is
supposed to find long sentences in a document:
Dim rDcm As Range ' the documents main story range
Dim oWrd As Object ' a word
Dim oSnt As Object ' a sentence
Dim oPrg As Paragraph ' a paragraph
Dim lWrd As Long ' a counter for words
Dim lSnt As Long ' a counter for sentences
Dim lPrg As Long ' a counter for paragraphs
Set rDcm = ActiveDocument.Range
For Each oPrg In rDcm.Paragraphs
lPrg = lPrg + 1
lSnt = 0
For Each oSnt I...Text to Number
Is there an automated way in which I can convert a text
data type to a number data type?
Check out the Val() function.
"Hafeez Esmail" <firstname.lastname@example.org> wrote in message
> Is there an automated way in which I can convert a text
> data type to a number data type?
> Please Help
> Hafeez Esmail
CInt(stringVar) [Convert to Integer function]
CLng(stringVar) [Convert to Long Integer function]
>-----Original Mes...Change a positive number to negative number
I have a column of positive numbers that I need to change to negativ
numbers. Is there an easy way to do this? Right now I manualy make th
change. Thank you, Pa
patowens's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2456
View this thread: http://www.excelforum.com/showthread.php?threadid=38155
patowens, put -1 in an empty cell, copy that cell, select the numbers you
want to change, right click and paste special, check multiply, OK.
Always backup your data before tr...Calendar control in Word 2003
I'm making a form which uses the calendar control 11.0 in Word 2003. I've managed to do so using:
This works fine on my form. However, the form is to be used at work, on a network (some staff use Citrix, some use PC's). I had to install the calendar control on my PC as described in the link. Only when I am logged on is the calendar useable- I'm assuming other users may have to have it installed, but the trouble is that we are a small department withing a large sector, so, is there any way around this as I doubt my chances at getting the c...Book/doc on converting XP program to work nicely on Vista?
Any good books or documentation, things I should know about what worked
fine on XP that won't work on Vista, what needs to be modified in the
program to get it to work nicely on Vista, umm, stuff like that?
What's a better way than Journal Hooks for a program to record it's own
keystrokes? Journal hooks was always problematic if other programs were
running that didn't process their messages correctly, and now on Vista I
hear journal hooks have been disabled.
try Microsoft Application Verifier.
"David Deley" <email@example.com> wrote in message
news:vTqVi.1...Message Preview doesn't work correctly for every email
We have deployed Outlook 2007 to all the computers here in our office and
all of us are experiencing the same problem with the message preview pane.
When you click on an email in the list, the preview pane usually updates and
shows the contents of the message. For some emails, however, only the
header details (From, Sent, To) update after the email is clicked. The
preview will show the last message that was previewed. Now comes the
strange part - If i double click the message to open it in its own window,
the message is displayed in the new window correctly and then the preview
pane...Colors matching on a page ....
Has anybody had any problems with creating a document in Publisher and using
more than one color on the page, but having more than one color appear when
I have checked the color of the font and they are all the same...but when I
print, one line may come out one color and the next one, another.
Close...but not the same. And I have checked to make sure they are the same
colors in every aspect. They are...until I print?????
Why is this happening and how can I fix it?
> Has anybody had any problems with creating a document in Publisher
> and using more than ...number of lines on a word document
Operating System: Mac OS X 10.5 (Leopard)
I want to produce a long, double-spaced document with the same number of lines on each page, not one that flips to a new page if the end paragraph is too large to fit. Can anyone help?
Maintaining a constant number of lines per page is dependent on at least 2
1- Using the same font & font size throughout, &
2- Turning off Widow/Orphan control in Format> Paragraph - Line & Page
Due to the proportional spacing considerations of modern word processing --
which is more closely akin to typesetting than typewr...Counting the number of times more than 1 variable occurs
I need to determine how many Separations were processed by a particular
A | B
1 MIKE | SEPARATION
2 MIKE | LEAVE
3 SARA | SEPARATION
4 JOE | SEPARATION
5 JAMIE | LEAVE
6 MIKE | LEAVE
7 JOE | LEAVE
8 SARA | SEPARATION
The only way I can think of is the COUNTIF Funtion
This does not work though. The results return 0 with no errors when
the answer should be 1.
does anyone else know of a wa...How do I work in excel and then save it as a doc or docx?
I need to be able to work in excell and then save it in doc or docx format.
If I cannot do this, can I make doc or docx so that I can use the automatic
In Word, you can use AutoSum of the Tables and Borders toolbar to sum the values in table. But when you change the values, you need to right-click the total value to refresh it. It can not update auto.
Lee Li Fong
http://smartusemicrosoftoffice.blogspot.com/ Hi Nadine,
You can open a Word document and Insert -> Object -> Microsoft Excel
...Saving as web page
When publishing spreadsheets as web pages I would like to
set the page to fit within a full screen view. I have
some that fit and some that don't and I've worked with the
formats in Excel to fit everything within the screen on
all of them, but that doesn't seem to help.
Can I set the format to do this?
Thank you in advance for your assistance.
...create a letter with the data fron work sheet
i have a data sheet for the order.like people order staff lik
tea,coffee...etc,i ve data including date,name,department,.....etc.
when i put the data i want a letter format which picks up the data fro
the sheet then i can send it to the person who made the order as
like it the letter starts dear "......"(it could pick the name fro
also how can i create this letter? does it have to be in excel ??
help pleaseeeeeeeeeeeeeeeeeeee!!!!!!!!!!:( :( :( :
Message posted from http://www.ExcelForum.com
As answered in microsoft.public.excel and microsoft.public....trouble with functions
I am fairly new to excel and I am trying to get to grip with the
workings of functions.
Is there a way to make a function execute everytime I input a value
into a box ?
For example I want to be able to subtract 50 from a value ( in B4)
everytime I enter a value ( in A4).
At the moment I can get the function to work once but not repeatedly.
I hope that makes sense
Thank you in advance
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
With a func...Page Break Preview editing
How do I get rid of the background picture that reads Page1 or Page2
etc... in page break preview? Even if I delete all the page breaks,
they still have the one picture that says Page1 in the background.
TGree's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14744
View this thread: http://www.excelforum.com/showthread.php?threadid=263634
in this view: not possible. You have to switch to the normal view
"TGree" <TGree.1d...Working offline with customize entities
I have created 2 custom entities in MS CRM. Now when I work offline in my
Outlook CRM for Laptop, the custom entities are not populated with records.
I checked my roles, it allows me to work offline. Does this mean that custom
entity records are not able to work in offline mode?
You will need to set up the sync of custom entity records in the Outlook
This can be done by specifying which entities are to be synched using Local
Data Groups in the Tools menu (i m not sure if its in the Tools/CRM menu. Pls
"Benjsoft" wr...Money 2006 Pocket PC does not work
I installed the downloaded money 2006 ppc to my new Dell Axim x51v that comes
with windows mobile 5.0 installed. The installation process seems ok,
however, when I tried to run it form Axim it poped up a message said some
components not found and I need reinstall the program. Anyone know the
Don't think mobile 5 is supported. See
Microsoft MVP - Money
For UK tips & fixes see
I do not respond to any emails that I have not specif...Automatic Numbering #4
Is there a way to automatic number a spreadsheet? For instances... if I were
to start on column A and row 2 with number 1, would this be possible to
continue numbering going down the spreadsheet? Please assist.
Javster. you could grab the fill handle, the little black square in the
bottom right hand, right click and drag down and fill series or put = A2 +1
in A3 and copy down
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"J...Word document attachment can not be read
We are using Office XP SP3 and Exchange 2000 with SP3.
Some of our users will send Word documents as attachments
in an email from Outlook that when you open the
attachment, word goes into file conversion because it
can't read the document. Typically, they send it again
and it opens fine. Sometimes it has taken two or three
tries. It is random and inconsistent. I have not been
able to duplicate it.
Has anyone else experienced this?
...Removal of 100's of spacing in numbers
I want to be able to use the replace command, but it won’t find the spaces
When I copy tables with numbers from various sources, I get spaces inside
and after the numbers. E.g. “1 234 “
I know the use of SUBSTITUTE and other functions, but it is not an effective
way of working when there are so many columns. I have tried to change the
cell format to text, but still no luck in finding the spaces with the replace
Might be some other character.
Place your cursor between 1 and 2 and copy
Select the columns with numbers
In the Find box press Ctrl+...After 12.2.4 update, cannot open some Word docs with Open passwords
Operating System: Mac OS X 10.5 (Leopard)
After installing the 12.2.4 Office update, I am unable to open some Word files that I had password-protected with an Open File password. How can I open? Thanks
Basically, "you can't".
Sorry, the other passwords are crackable, but "Password to Open" is
effectively the encryption key. The entire file is encrypted, and unless
you have the correct password, you can't get it open.
However, are you sure you are not attempting to open files that were
password-=protected on the PC? ...matching columns of numbers
In EXCEL 2000 for Windows, I have two columns of numbers. Column A has
500 numbers, Column B has 1000 numbers. I need to know which cells in
Column A have a match in Column B, and if so, what is the Cell (or row
number) in B that matches to that particular cell in A. How can I do
Thank you for your help.
** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***
try the following:
- insert a new column between A and B (so make B the new C column)
enter the following in B1
=IF(ISNA(MATCH...How do I print only odd pages in Publisher and then only even page
I am attempting duplex printing with a printer that is unable to do duplex
printing by printing odd pages first and then flipping the pages over and
printing only even pages.
No option is given that I can find in the print window.
Sarah Wright wrote:
> I am attempting duplex printing with a printer that is unable to do
> duplex printing by printing odd pages first and then flipping the
> pages over and printing only even pages.
> No option is given that I can find in the print window.
The duplex printing add-in can be found here
(http://publisherm...Page break preview & blue line
I using Excel 2003
In page break preview I have always do some thing wrong I'm just pull the
blue line by using mouse all page was destroyed
It there any tips to return the blue line to the Default pages size setting
As far as I know the 'default' print area is all the data, and once you have
changed the print area and saved the file you can not get it to go back to
the previous setting.
If you have problems with this or any other proceedure do try to remember to
save your file before you do the awkward bit and then you can go back to the
saved copy it it does not work.
...Function doesn't run
In my spreadsheet, I have the following function
=VLookup(K16, zips, 2)
However, instead of returning a result, the function remains in the
cell. How do I fix this problem?
Format the cell as General and re-enter the formula (F2, ENTER)
Microsoft MVP - Excel
"Justin" <firstname.lastname@example.org> wrote in message news:email@example.com...
| In my spreadsheet, I have the following function
| =VLookup(K16, zips, 2)
| However, instead of returning a result, the function remains in the
| cell. How do I fix th...Color not working
I am operating Windows 2000, using Office Pro 2003. I am
no longer able to format my cells with colors, either
shading or text coloring. I have run the repair feature,
but it didn't work. Bold, Underline, and similar
functions still work.
Have a look at this:
Changes to Fill Color and Fill Pattern Are Not Displayed
>I am operating Windows 2000, using Office Pro 2003. I am
>no longer able to format my cells with colors, either
>shading or text coloring....