|
Finding Headings from text copied from web pages
When I regularly copy text from web pages into Word, I want to be able
to detect the headings and convert them to Title Case.
Most of the text I copy pastes in Word at 12pt fonts while the
headings paste at 24pt (but no Heading style).
Can anyone suggest how I might loop through the document to detect
these headings?
Thanks in advance
Paul Martin
Melbourne, Australia...
|
1 |
1/1/2009 6:34:17 AM |
|
|
Delete web scripts pasted from web pages
I regularly paste web pages into Word which I then format. With non-
printable characters displaying on the screen, any web scripts show up
at yellow boxes, and I'd like to delete these. The following code
causes a crash in Word (forced restart of Word) on the line "If Not
ishp.Script Is Nothing Then". Any suggestions appreciated.
Paul Martin
Melbourne, Australia
Dim ishp as In...
|
1 |
1/1/2009 5:33:51 AM |
|
|
wdSelectionNormal with more than one Style?
Hi,
I have the following Word 2003 code to check the current cursor insertion
point (or selection) for the style. If the style is "Bold Word" then do
something, otherwise, if it is any other style, do something else. This code
runs automatically in the background through an application event procedure
class module.
The problem is if multiple paragraphs (of two or more styles) are se...
|
2 |
12/31/2008 10:56:06 PM |
|
|
Application Event Procedure impacting "Normal" documents
Hello,
In my custom Word 2003 template, I have the following application event
procedure to check the style at the current insertion point (or selection):
Public WithEvents AppThatLooksInsideThisEventHandler As Word.Application
----------------------------------------------------------------------------------
Private Sub AppName_WindowSelectionChange(ByVal Sel As Selection)
If Selec...
|
2 |
12/31/2008 10:42:39 PM |
|
|
Ignoring a portion of table titles in TOC
Is there a way to replace a portion of table titles in the TOC (for example,
by adjusting the position counter at the point where the row of dots would
start (the dots that are generated to start at the end of the table title and
run to the start of the page number) so that the dots start earlier in the
line, thereby obliterating/replacing the last, say, 10 characters from the
table titl...
|
2 |
12/31/2008 10:33:34 PM |
|
|
Global Template Question
Windows XP, Word 2003 Network Environment
I've created a global template (add-in) to contain all user forms and macros.
The Workgroup Templates have been stripped of all code.
I created a master user form that calls up any one of 7 templates. The
templates are hidden, read only, but accessable to users. With respect to
the code/forms to "run" the templates, I deviated from adding a b...
|
9 |
12/31/2008 9:07:01 PM |
|
|
Macros and the normal.dot
I have my macros in a separate template (NOT the normal.dot)
but they keep hanging up outlook (which I know is running off the normal)
if you have any document open from this new template
as well as giving us the error "do you want to save over the Normal.dot"
Why am I still effecting the Normal if it's a different template?
...
|
1 |
12/31/2008 8:25:01 PM |
|
|
Programmatically setting the Save As filename in a Word doc via VB6
Hi All
First of all I know the SaveAs command would enable me to pre-set the
filename of a word doc, but unfortunately it will auto save it somewhere and
this won't do in my case.
A perfect solution for me is that the Word doc appears (from a word template
I have created so it's a fresh copy with a bit of dynamic data every time)
and when the user goes to File / Save or File / Save A...
|
1 |
12/31/2008 7:06:08 PM |
|
|
creating envelope macro
I have a protected template which is populated with information from our host
system: formfields Text1-Text4 have the name, DBA, address, CityStateZip.
I want to create a macro to which these 4 are selected to print an envelope.
I don't want the user to have to unprotect, highlight these, and then tools>
Envelopes and Labels >etc, etc.
Is there a way to programmically create a m...
|
21 |
12/31/2008 2:46:49 PM |
|
|
Macro for Finding Highlighted Text
Version of Word 2003: I would like to record a macro for my finding
highlighted text in my documents. However, when I record the macros using the
"record a New Macro" feature in Tools, the recording button goes blank
indicating that the macro is no longer recording. Is there a way to work
around this glitch? Also, what is the VBA code for calling up the find and
replace dialog box?
Th...
|
4 |
12/31/2008 2:33:37 PM |
|
|
Determine if Selection is Text (Application Event Procedure)
Hello,
I have a Word 2003 event handler that checks to see if the current
selection/cursor position is in text of the style "Bold Word." If so, the
event handler shows my "Bold Word" toolbar button as depressed. Note: The
"Bold Word" toolbar button runs a macro that toggles the bold style on & off.
' Class Module Private Sub below:
If Selection.Style = ActiveDocument.Styles("Bol...
|
3 |
12/31/2008 2:30:01 PM |
|
|
Type mismatch again
Hello,
I feel so frustrated with myself in not understanding values within cells
vs. the cells themselves. I am trying to total a column in a table in Word
2003. Some of the cells may be empty. The total will be put in cell E19 (at
least in this case). When some people tested the macro, we found that it is
not totaling the cells if the user placed a $ in front of the numeric value,
...
|
6 |
12/31/2008 2:22:12 PM |
|
|
Points returned by Information(wdHorizontalPosition...)
In a macro, the value returned by
"Selection.Information(wdHorizontalPosition..." and
"Selection.Information(wdVerticalPosition...)" is in points, even though the
help says the value is in twips. I assume that the function is accurate.
Should the returned value be rounded or truncated or used exactly as
returned? For example, if a paragraph is indented 0.5 inches, the returned
value i...
|
9 |
12/31/2008 11:39:03 AM |
|
|
Find and highlight some occurences in a doc
Hello,
I would like to look for a specific type of formatting , e.g. "my_style" +
underlined, in a word doc and would like to highlight it in light grey in
addition.
I tried the following but I am a bit stuck, so any help would be much
appreciated:
With rngTemp.Find
.Text = ""
.Forward = True
.Wrap = wdFindStop
...
|
7 |
12/31/2008 9:32:48 AM |
|
|
How to change field result font color using VBA?
What code do I need to change the field result's font color when I update the
fields?
I want to change all field results to red and don't what code to use to
find all fields & change their font color.
Thanks, ...
|
2 |
12/30/2008 11:00:15 PM |
|
|
Changing date formats in forms
I need to find a way to reformat a date value from a user formfield formatted
as m/d/yyyy to a bookmark which should have the date reformatted to mmmm d,
yyyy. Why would I want to do this, you may rightly ask. I have a userform
that I use to generate a hardcopy of information for a colleague who then has
to reenter all the data. To make it simpler for her (she would get lost in a
very...
|
3 |
12/30/2008 10:07:00 PM |
|
|
Help with hyperlink and macro
Yet another problem that I am calling upon the experts to assist me with. We
use codes and explanations associated with the codes and I have created a
word document and make a page with code numbers and attached hyperlinks to
them so when you click on them, you go directly to the comments to copy. My
question is if there is some type of macro or something that I could
incorporate into th...
|
5 |
12/30/2008 10:04:31 PM |
|
|
Copying A Doc's Properties/Profile
Any one out there know if there is a way of copying a document's profile or
properties that resides in a document management system like Imanage,
Worksite, etc. I'd like to be able to copy the following properties:
Document Name, Author, Client, Matter, Document Type, Subtype, etc. and apply
them to a document I'm currently saving rather than having to input that
information all over a...
|
5 |
12/30/2008 9:57:09 PM |
|
|
Unable to get complete word doc for second time using VBA from PPT
Firstly I apologise if this question / problem is in the incorrect forum.
I have been using PPT to produce several internal training modules over the
months each of which contains a quiz. Following an internal review the
modules are to be automated so that each individual’s quiz results are saved
in a word doc. Being a newbie to VB I have managed to get all the code
working to produ...
|
1 |
12/30/2008 5:37:01 PM |
|
|
Opening User Form with items selected in List Box
When I open a User Form with a listbox in fmMultiSelectMulti mode, I want to
be able to select several values based on the list index number
i.e I know i want the first, third and fifth values selected
Anyone know how I do this please?
I have tried frmReport.lstDirections(3).Selected = True
Thanks
Stephen...
|
2 |
12/30/2008 1:27:52 PM |
|
|
can I use VBA to change the format of audio recorded using
Briefly:
I can record audio in word but I would like to use VBA to compress this to a
more managable file size e.g. 10 secs in the default format is 1.8MB and in
the compressed format it is 30kB
How can I do this compression under vba control?
More info:
By default the audio is recorded as PCM 44kHz 16 bit stero WAV which huge 10
secs = 1.5 MB
I can use compress this in Word by righ...
|
5 |
12/30/2008 7:23:00 AM |
|
|
How do I install English-Chinese translator
How do I install English-Chinese translator to Microsoft Office?...
|
3 |
12/30/2008 7:21:00 AM |
|
|
Populate field based on multiple selection in multiple fields
I am fairly new to word as my previous company had a program to generate
letters and forms and my new company does not. I have a form that is used
when new business is generated. I need the commission to auto populate based
on the broker and product selected (both drop down lists). There are too
many combinations to use IF statements. Any assistance you can provide is
greatly apprec...
|
6 |
12/30/2008 7:11:00 AM |
|
|
System Problems with Microsoft Community Group
Just a heads-up - there seems to be something wrong with this website.
Yesterday (12/23/08) I posted a question regarding Copying Doc
Properties/Profiles three times because it seemed that previous attempts did
not get posted. Today I got an email alerting me that someone responded to
my post, however, when I go on to this site from the link in my email, I
cannot find my post with that...
|
3 |
12/30/2008 3:49:01 AM |
|
|
Restore the Normal.dot file
Version of Word 2003: I accidentally corrupted my normal.dot file which
contained numerous macros. Before messing up, I backed up that file
normal.dot file on an external drive. How do I restore that file so that word
recognizes it again?
Thanks in advance.
...
|
3 |
12/30/2008 2:43:01 AM |