STYLEREF in header
Tue, 19 Aug 2008 13:10:01 -0700
I am attempting to link my table of contents into my header. So far the TOC
appears to be working just fine using Header 1. However when I use the term
{ STYLEREF "Heading 1" } in my header I am not seeing the actual chapter name
as located in my TOC. In fact I am viewing a gray out term: { STYLEREF
"Head ...
|
Code to Display a button in a MsgBox?
Tue, 19 Aug 2008 12:28:13 -0700
I'm trying to create a MsgBox that will display general information text as
well as a button/icon/picture but can't figure out how to do it.
For example, the MsgBox could display:
"Items preceded by <icon> are internal."
I know I can store the text in a variable & can contantenate the variable
with th ...
|
How to grow font into range?
Tue, 19 Aug 2008 11:16:17 -0700 (PDT)
Hello.
There is some text which has font with different size (8, 14, 15 or
others). If I assign next macro (below) then it show error. If use
font identical size, then it's OK. How can I grow all text with
different font of size on 1 point?
Sub SizeFonts()
Dim rF As Range
Set rF = ActiveDocument.Range
rF.F ...
|
Exporting to Access Help
Tue, 19 Aug 2008 11:10:02 -0700
I have a template that has 100 form fields, Scary. I am using the code
below to export the data in the form fields to an Access Database (Flat
Table) I then run Union Queries to extract from the Flat table into
normalized tables. this has been working great. But now I am finding out
that when the record ...
|
Help with grouping shapes in 2007
Tue, 19 Aug 2008 09:57:01 -0700
Need help with vba code that worked in Word-2003 but fails in 2007.
We have reports that add annotated diagrams (using .wmf images and autoshape
marks placed according to data in the report)
To get this done (in 2003), my code opens a blank document, adds the diagram
and the shapes, then groups these and copie ...
|
Bookmarks - Requested member of collection does not exist
Tue, 19 Aug 2008 08:26:07 -0700
In a protected form, I created a macro in exiting a DD field so the content
of an enclosing bookmark somewhere else in the document disappears when the
user chooses "No".
If ActiveDocument.FormFields("bkxxxxx").Result = "No" Then
pToggleProtectDoc (ie to unprotect doc)
Acti ...
|
Evaluating the content of a variable
Tue, 19 Aug 2008 07:55:01 -0700
This may be a duplicate post, if so could you repeat any answers? Thanks!
I have a series of repeating FormFields representing questions which are
identical except for the FormField name (e.g. location1, location2). Rather
than capture the answers via a hardcoded routine, I want to loop through the
fields ...
|
|
|
Excel from Word: Starting XLStart files automatically
Tue, 19 Aug 2008 08:20:45 -0400
I want to call Excel from Word. I use the VBA code that is readily available
on (among other places) the Word MVP site. (essentially "Set oXL =
GetObject(, "Excel.Application")"), and Excel opens nicely.
However, I have a VBA project that I wrote for Excel, and that resides in
the XLStart folder, that I ne ...
|
How to add 2 tabulations after string?
Tue, 19 Aug 2008 04:47:59 -0700 (PDT)
Hello.
There is code (below). I need to add after string (.TypeText
Text:=aFont) one or two tabulations. How?
Sub Fonts()
Dim aFont
For Each aFont In FontNames
With Selection
.Font.Name = aFont
.TypeText Text:=aFont
.TypeText Text:="qwertyuiopasdf+ 1234567890="
.TypeParagraph
...
|
LinkFormat.AutoUpdate error
Tue, 19 Aug 2008 02:33:01 -0700
Hi all,
I'm trying to generate a script that
1) pastes a Excel selection as a linked Metafile Picture and
2) adjusts the properties of the pasted picture, amongst which the
AutoUpdate property (which needs to be set to False)
-------------------
Selection.Collapse Direction:=wdCollapseStart
Sel ...
|
