Highlight text via macro
I am a novice writing a Word macro where I wish to highlight a selection of
words in a document. These pre-defined words are listed in a table in a
second Word document.
I have taken and attempted to modify my macro from an earlier posting on
It fails with the message “Named argument not found” on the statement
The code is:
Dim TableDoc As Document ' The document that contains the table
Dim RefDoc As Document ' The document that is being referenced (highlighted)
Dim cTable As Table
Dim oFind As...custom CStatic and text wrapping
I have almost finished to developp a nice CStatic derived control thanks to
all examples on codeproject and codeguru.
I took what was the most interesting (flicker_free, handling of
transparency, color, blink, pictures, email link, ...) from every control I
found but my last
problem is about text wrapping. I have tried to use DT_WORDBREAK with
DrawText but with no success.
Finally someone on code project proprosed a solution but it is not perfect.
If you are curious you can see the problem here : http://richom.v.free.fr/
Text wrapping is my last problem.
If someone could find a solution.
...Removing characters from cell
Hope someone can help me with this one....
I have text in column "A" a list of parts like the following.....
Is thier anyway of removing the dots in front the part number?
I dont want the points moving after the the main part of the number.
Do you part numbers all start with nhg?
If yes, you could select column A
And keep hitting the replace all button until all are fixed.
> Hope someone can help me with this one....
>...Importing into Excel from a Text file
We have a text database of about 7,000 rings. It is in a fixed format.
Unfortunately some where we have about 4 or five rings whose format is
screwed up. We figured by importing to Excel, we should be able to find
where the records are to fix them. But, we just can't get the following
format to import into excel. If anyone can help us, we sure would appreciate
Each record begins with Begin Product
Each record endswith EndProduct
a semicolin seperates each record
Also there are para symbols at the end of every line
Herer are a...FIND a character
I want to find a character in an entry in Excel and assign a value in
another entry depending on if the character is found or not. For example, I
am trying to use
to give me a value 0 if the logical test in the IF function is TRUE.
Otherwise, return the value in B3. The problem is if "m" is not found, FIND
returns the #VALUE! error value, and I have no idea on how to test for this
condition. Any ideas? Does anyone have another suggestion on how to
accomplish what I am trying to do? Thank you.
=IF(ISNUMBER(FIND("m&q...Rotating a text box
Does anyone know how to rotate a text box in Excel2002? I want my chart
annotations to align with the plotted data. I've tried everything I can
think of, but when formatting the text box, the rotate option on the
"size" tab is always greyed out. I would use WordArt instead, but
there's no plain text option with it, just silly looking decorative
text. Any ideas?
Jim Bready wrote:
> Does anyone know how to rotate a text box in Excel2002? I want my
> chart annotations to align with the plotted data. I've tried
> everything I can think...Curve the Text Box in a Newsletter?
Is there a way to curve the text box justification? There are severa
templates within Publisher that have curved color "blocks" that ru
along the left or right border of the newsletter. I am able t
insert a text box, but am unable to justify it along the curve of th
Any ideas would be greatly appreciated
This is a wrap issue, bring the "color blocks" to the front.
Mary Sauer MSFT MVP
"lewiedude" <firstname.lastname@example.org&g...Text from Dreamweaver not pasting correctly
Operating System: Mac OS X 10.6 (Snow Leopard)
I pasting text from Dreamweaver as their spell check does not work too well. but it's not landing in the page. what is this? thanks: <br><br><a href="http://tinypic.com/r/2vwwll4/6">http://tinypic.com/r/2vwwll4/6</a>
On 2010.01.21 4:17, in article 59bb1512.-1@webcrossing.JaKIaxP2ac0,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: 2004 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
> I pasting text...Count Nonblank Text Cells
Hello. I searched for a solution to this, but couldn't quite find what
I am importing data into five columns in Excel. Each of the cells is
formatted as text, but most of them are blank. I want a count of the
ones that are not blank.
I have five columns for problem codes, so each row will have between
zero and five problem codes. This is a little trickier than I thought
because the problem codes can be either numbers or letters or a
combination of both.
How do I write a formula that says, "Look in these five cells and tell
me how many of them have something meaningful...Conditionally Converting Text to Numbers in VBA
Our database program exports a column of data as text.
This column includes general text (e.g. Summer), numbers (2002), and
dates (AUG 03).
If I were using excel formulas, I'd simply do the following
and copy the formula down. Excel then happily converts dates and
numbers and I can use these thereafter.
How can I do the same in VBA, but referencing by cell rather than
range? (I'm looping down using a numeric row counter,
=cells(rowcounter, 2) )
Any help would be appreciated.
----------------------------------------------------------...text numbers as dates via OCR import
Here is a tough one... I have OCR scanned a printout from a database that
contains sales information. The key column of data is the Product number
which is in the format of nn-nn-nnnn. Of course upon import into Excel, it
treats some (but oddly enough not all) of these entries as dates in the
format mm/dd/yyyy. I had formated the sheet as Text prior to import. There
seems to be no way now to properly sort this data as I get the "mixed numbers
and text" box during a sort operation and of course it sorts in that order.
I have tried several formulas, macros and formatting st...Setting every text object in a detail line to bold.
I want to set all the text objects in the detail line to bold depending on a
condition of one of those objects. For example,
If txtExpired.Text <> "Current" Then
txtExpired.FontBold = 1 : txtName.FontBold = 1 'etc.
Else: txtExpired.FontBold = 0 : txtName.FontBold = 1 'etc.
My question: Is there a syntax, of the form "For all objects in detail" that
allows me to bold every text box in the detail line without setting each
FontBold to 1 individually?
If this is a Continuous form or datasheet, setting the properties like tha...Outlook 2002 XP: Borders & Shading Task Text
Does anyone know if there is a way natively (or third party utility) to
shade text with colors in Outlook Tasks items? I've been struggling for
months now to do this, searched the web, slipstick systems searches, etc -
Shade text where, exactly? In the Task List or in the Task item itself?
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please reply
only to the newsgroup to preserve the message thread. ***
> Does anyone know if there is a way natively (or third party utility) to
> shade...Outlook 2003 Messages and Calendar Appts Received as PLAIN TEXT
email@example.com <firstname.lastname@example.org> wrote:
> I just got a new laptop with Vista Home Basic on it and I copied my
> pst file...HOW DO i SET DEFAULT TEXT BOXES IN PUBLISHER
I have found MVP who created the toolbar for this, but the page will not
allow me to download the toolbar. Any suggestions??
What is the URL? I can't remember a toolbar.
When you are finished modifying the normal.pub and you save as:
C:\Documents and Settings\User Name\Application
in the save as dialogue, click tools on the right top, click add to "My Places."
It will quickly be available.
Mary Sauer MSFT MVP
http://officebeta.iponet.net/en-us/publisher/F...Text size on check boxes
Is there any way to increase the text size on check boxes? Thanks in
I forgot to mention, Increasing the font on group boxes will be nice
...formatting text as active hyperlinks
I have tried to format cells containing valid urls as hyperlinks. I can
copy the format from a valid and active hyperlink; but when I paste it
in the cell (I have tried pasting format), the contents look like a
hyperlink, but the mouse cursor does not change when I hover over it,
and I can't open the web site by clicking on it?
dpimental's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=14848
View this thread: http://www.excelforum.com/showthread.php?threadid=26...Remarks field character size
I have been looking at changing the caracter size of the Remarks field on the
PO. I have been getting some feed back that I shouldn't do that because its
going to make the database unstable.
The current size of the Remarks field is set to 30 characters and it just
don't cut it for the PO. If we have to add a special instruction we can't.
Does any one know anything about the stability issue or how to increase the
Don't they explain this stuff when you become a "Microsoft Partner"?
"Yaniv Zahavi" &l...Highlight specific text
How do I highlight specific text within a cell in Excel 2003 in all rows?
> How do I highlight specific text within a cell in Excel 2003 in all rows?
...Append Text to Cell Values Using Replace
I've tried to search all the posts to see if anyone has run across this
before but couldn't find one. So here goes my question :-)
I'd like to be able to append some additional string (let's say "Hello ") to
the contents of a range of cells, regardless of what they were. For EX, if a
cell was "Linda", now it is "Hello Linda" etc.
What I've done in the past is to put a formular in the next cell (let's say
B1) that says ="Hello " & A1. That works but it's becoming quite time
consuming after a while.
I'd like ...Error for Textbox text
I have developed a Report in Reporting Service.
I have text box taken on Report. In that text box's Expression section i have following hardcoded text like : = "NOTE: �Senior Officers� for the purpose"
While compiling this report it gives me error like
[rsCompilerErrorInExpression] The Value expression for the textbox �textbox1� contains an error: [BC30205] End of statement expected
Plz suggest the solution
Posted via DevelopmentNow.com Groups
http://www.developmentnow.com/g/...Format in an unbound Text Box
Hi all, I have a form that I have put an unbound text box in, which displays
the previous entries from my table. One of my fields is Current Time. Which
on my form I set to Short Date (military time).
How can I have my unbound text display Short time as well. here is my code
(control source of my unbound text box).
SELECT DISTINCTROW tblSITLog.[current time], tblSITLog.MONTH, tblSITLog.DAY,
tblSITLog.SIT, tblSITLog.[NATURE OF iNCIDENT], tblSITLog.[Case Description],
WHERE (((tblSITLog.[NATURE OF iNCIDENT])="CHRONO ENTRY"))
ORDER BY...Line spacing in text boxes for web pages
For some reason, the text formatting menu in the web page
project area doesn't have an option for changing the line
spacing from double-spaced. I want the text on my web
pages to be single spaced. In all the other projects, you
can use the text formatting menu to change the line
spacing but I don't see that anywhere on my web page
project. Surely, web pages don't *have* to be double-
They *don't* have to be anything.
Have you read the HELP file?
How *would* we know when *you* don't tell us what version of Publisher you
Pity you *don't* hav...Displaying text into Sql reports
I would like to know what I can use in sql server report 2008 to display
several sentences or paragraphs prior to where I have a table generated.
Each table in each report will display the data. To display the paragraph(s)
before the table containing data what toolbox item would I use? Should I use
a matrix, rectangle, textbox, and or another table?
Not sure if i completely understand your request: Are you simply wanting to
insert a paragraph before your data table or matrix?, then just use a
textbox, thereafter you can do your tables or matrix.
These text ...how to converts a number to text eg. "2" become "two" #2
many excel utilities from third parties have this built in
Morefunc for instance, see above link
Northwest Excel Solutions
"CQ" <CQ@discussions.microsoft.com> wrote in message