|
Set formfield focus on Multipage
Is it possible to set the focus on a formfield when selecting a Multipage tab?
If so, how do I do that?
Thanks in advance.
Jacob....
|
4 |
10/28/2008 9:05:01 PM |
|
Change font color in Text boxes
You guys have really been a big help. This is my first time dealing with
VBA..and the teacher has loved it so far..
I have the following code to replace bold text with whit text, and vice
versa, essentially making the text disappear and re appear. How do I get
the macro to include text in text boxes? It seems to skip over these. Also,
I tried adding a table instead of a text box an...
|
4 |
10/28/2008 7:45:01 PM |
|
Macro to delete from AutoCorrect entry database
Hello, Is there an existing macro I can use to delete entries from
AutoCorrect listing from Word 2003 or Word 2007?
Thank you~~ ...
|
3 |
10/28/2008 12:02:01 AM |
|
ContentControls ID
We should be able to set the ContentControls ID so that it can be referenced
from code. i.e. ThisDocument.Range.ContentControls("MyCC")
Thanks for your consideration.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the ...
|
10 |
10/27/2008 10:15:42 AM |
|
Macro to toggle Colors??
I have another q for you guys..
IS it possible to toggle between colors in word? E.g. I have a paragraph
with Automatic color black, bolded words and want a macro to convert words or
characters that are bolded in black to the color white ..essentially to
make the text dissappear..
I'd also like to be able to turn this on and off so I can make the text go
back to Black and Bold.
...
|
7 |
10/27/2008 6:16:01 AM |
|
Evaluating Numbers in a Sequenced Step Count
I have an undetermined number that I need to sequence and do one thing if
the number is:
0, 4, 8, 12
Something else for:
1, 5, 9, 13
Something else for"
2, 6, 10, 14 ...
and finally something else for:
3, 7, 11, 15 ...
I can do that for a limited sized number using Select Case as shown below,
but I don't know how large "i" needs to be. How else could I evaluate i as
...
|
3 |
10/27/2008 3:35:42 AM |
|
Stop dates updating on open during automation
I need to make an archive pdf copy of a doc, so I want to open a word doc,
unlink all the fields and save it. I have managed to get file paths unlinked
as they only change during print/print preview, but any dates are being
automatically updated as soon as the document is opened so I can't just
unlink them.
I set Application.AutomationSecurity to msoAutomationSecurityForceDisable,
b...
|
10 |
10/26/2008 11:49:01 PM |
|
Mapping Content Controls to External XML
Posting here for lack of or not knowing a better place.
Last year I experimented with mapping content controls and had some success.
I learned that I could map contentcontrols to a customXMLPart and that that
part could be defined in an external source.
My experimenting XML file is pretty basic:
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<myinfo xmlns="http://gre...
|
5 |
10/27/2008 10:15:41 AM |
|
"MatchEntry" propery for list.
This is (accurate) description of the function of the MatchEntry property
for a ComboBox control.
"The control searches the column identified by TextColumn for an entry that
matches the user's typed entry. Upon finding a match, the row containing the
match is selected, the contents of the column are displayed, and the
contents of its BoundColumn property become the value of the control....
|
2 |
10/27/2008 10:15:41 AM |
|
Word 2007 Add-Ins: Editing toolbar icons in Word 2003 template
I am working on a project to convert 15 Word 2003 templates to Word 2007. I
know that the custom toolbar for each template is now accessible from the
Add-Ins tab. Editing the macros is working fine but how can I edit the icons
to add, delete, or modify the custom toolbar? Some items need to be removed
and client wants a new option/icon.
BTW, each template needs to stand alone because th...
|
3 |
10/27/2008 10:15:43 AM |
|
'Backspace-tast' fungerer ikke i word..
Kan ikke slette markerede tekst med 'backspace' i Word.. Hvad gør jeg?...
|
2 |
10/27/2008 10:48:24 AM |
|
populate data from excel into word
Hello,
I'am writing a lot of tenders for my job in word.
A lot of the text remaines the same. Specific data change all the
time. Example: client data..., specific data for the item I sell.
Before I can make the text. My colleagues have to fill in a data
sheet in excel, the result of calculations.
These results come back a few times into the text. I have to copy
them everytime by han...
|
4 |
10/27/2008 2:02:19 PM |
|
Macro for Word Form to Disable Fill-In
I'm looking for a macro to insert into a form I am designing in Word 2003. I
need a macro that will disable fill-in on specific fields only, by using the
last character of their bookmark names. Basically, I'm desiging a form that
one person fills in some of the fields, then another fills in the rest. I
don't want the 2nd person to be able to change what the 1st person filled in,
and I ...
|
3 |
10/27/2008 5:43:02 PM |
|
Command Button - No Print
I have a command button that runs a macro that basically replaces various
words throughout the document. I do not want the button to print out. I
have tried putting it in a text box as described here:
http://www.word.mvps.org/FAQs/TblsFldsFms/HidePrintButton.htm
but when I do that, the button no longer runs the macro.
Any suggestions? TIA...
|
10 |
10/27/2008 6:25:01 PM |
|
PasteSpecial
Hi!
I’m copy a graph from excel, and I want to paste it into a word document at
a named bookmark.
I use the code:
Wrd.ActiveDocument.bookmarks.Item("InsertPic").Range.Select
Wrd.Selection.Range.PasteSpecial Link:=False, DataType:=wdPasteBitmap, _
Placement:=wdInLine, DisplayAsIcon:=False
The bitmap are only partly visible (one line) at the bottom of the image. If ...
|
3 |
10/27/2008 8:36:24 PM |
|
If statement
Hello,
I'm using Word 2003. I have two macros, both copy the styles from one
template into the current document and then one of the macros makes the
styles fully justified. They are part of a form so they run conditionally
when the user clicks OK. Problem is, I can't get just the first macro to
run, it always runs the MakeFull part of it, so no matter what I get full
alignment. A...
|
6 |
10/28/2008 1:17:01 AM |
|
creat word field in Excel CommandButton1_Click Macro
ÏÈ¿´ÔÚwordÖеÄÒ»¸öºê£º
Sub Macro1()
'н¨Ò»¸ö¿Õ°×Îĵµ£¬ÀïÃæÄ¬ÈÏÓÐParagraphs(1)
ActiveDocument.Paragraphs(1).Range.Text = "Date:"
ActiveDocument.Paragraphs(1).Range.Select
Selection.MoveRight
Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldDate
End Sub
ÒÔÉÏ´úÂëÓÃÓò²åÈëÁËÈÕÆÚ£¬Ã»ÓÐÎÊÌâ
ÔÙ¿´ÔÚExcelÖеÄʵÏÖͬÑù¹¦Äܵĺ꣺
Private Sub CommandButton1_Click()
Dim oWord...
|
2 |
10/28/2008 11:49:25 AM |
|
Can't create word field by CommandButton_Click macro in Excel
As we all know, we can create a macro in word like this:
Sub Macro1()
'Using default paragraphs(1)
ActiveDocument.Paragraphs(1).Range.Text = "Date:"
ActiveDocument.Paragraphs(1).Range.Select
Selection.MoveRight
Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldDate
End Sub
These codes work fine
Now we check how this work in excel(version 2003)
Private Sub CommandBut...
|
4 |
10/28/2008 12:20:36 PM |
|
How to check for active sheet in Multipage on a Userform
Hi
I am creating a Userform in Word 2007 and have added a multipage with 3
sheets. I have created a Multipage_Change procedure that runs some code when
change between the sheets.
How can I see which of my 3 sheets thats the active one when running the
Multipage_Change?
/Lasse...
|
3 |
10/28/2008 12:25:02 PM |
|
Office 2007 Fluent Ribbon, RibbonToggleButton
I've been pulling my hair out trying to achieve the below. Any help would be
appreciated...
In an application level add-in (using C# and VSTO), I've noticed that a
RibbonToggleButton's state by default is shared amongst all open Word
instances (when ShowWindowsInTaskbar is TRUE).
I want to create an Application level add-in where the functionality
provided by the add-in is availab...
|
2 |
10/28/2008 3:14:39 PM |
|
Need Help With a Form Script or Macro
My employees have a 5 page form that they need to fill out in word and I'd
like to make it so that if they leave a field blank, it reminds them when
they save or go to close the document. We have forms like this in excel, but
I'm wondering if it's possible to do it in Word. Can someone explain how
this would be done?
Thanks!...
|
2 |
10/28/2008 3:18:29 PM |
|
For Loops with variables
Hello,
I would like to create a loop where the name of a bookmark changes with each
loop. All I can find about For Loops is about incrementing a number or a
collection. I just want the name of the bookmark to change with each loop
but the information being added is the same. Is there a way to do this?
Thank you....
|
5 |
10/28/2008 4:38:01 PM |
|
VBA in 2007 "times out" on 2003 docs
I am aware that the problem may be a code issue, but I am going to take the
step of assuming (hoping) its not the code, but a settings issue or something
in Word.
I am really looking for ANY ideas or direction.
I have created a template for Word 2007. This template runs fine on both
2007 and 2003 (compat mode) docs for me and for many other customers. This is
why I am guessing that ...
|
2 |
10/28/2008 8:26:48 PM |
|
Programmatically remove broken reference
How do I in Word remove a broken (ticked in Tools, References, but showing
as Missing) reference?
I tried code like this:
Sub RemoveBrokenReferences()
Dim VBProj As Object
Dim oRef As Object
On Error Resume Next
Set VBProj = ThisDocument.VBProject
For Each oRef In VBProj.References
If oRef.IsBroken Then
VBProj.References.REMOVE oRef
End If
Next oR...
|
3 |
10/26/2008 11:54:20 PM |
|
merge error 5535
Have the following code works great when print canceled. Now when you check 1
in print dialog screen. It merges all records. but before it does it displays
error 5535 could not finish mergeing or inserting database. debug came up on
..Execute Pause cannot remove or no merge.
Can anyone see what I can't Stumped at this point.
Thanks
With ActiveDocument.MailMerge
.Destination = wdS...
|
15 |
10/27/2008 3:42:01 PM |