strange happenings with document protection code
Tue, 23 Sep 2008 13:03:02 -0700
So I have a Word document with Form Field protection. It has code for both
Document_Close and Document_Open.
Both use this to turn off and turn back on the protection:
If ActiveDocument.ProtectionType <> wdNoProtection Then
ActiveDocument.Unprotect Password:="<password>"
End If
...and then...
Ac ...
|
ContentControl
Tue, 23 Sep 2008 20:54:44 +0200
Hi,
I have several ContentControls with the same tag "MyTag".
How do I change the font.size for all tagged "MyTag" contentcontrols that
are located outside page 1?
Dim oCoc As ContentControl
For Each oCoc In ActiveDocument.ContentControls
If oCoc.Tag = "MyTag" Then
'some thing to ensure tha ...
|
Update text in document range without affecting fields
Tue, 23 Sep 2008 11:42:12 -0700
I'm working with Footers, searching for one string value to replace it with
another. If the footer has fields in it and I assign ...Footers(#).Range =
Replace(stuff, ...Footers(#).Range), the fields are converted to static text.
How can I keep the actual value of the Range intact to write it to another
Ran ...
|
Macro for drop down lists
Tue, 23 Sep 2008 11:06:01 -0700
Hi, this may be an elementary question, but I don't have much experience
creating macos.
I have created a form with a combination of text fields, check boxes and
drop downs. To make it easier for the user, I want to create a macro so that
if they choose a location name, it automatically fills in the locati ...
|
Remove everything from formatting toolbar, other than Style dropdo
Tue, 23 Sep 2008 09:44:02 -0700
Hello,
I'm trying to create a template, so that when it is opened, the only option
to appear in the formatting toolbar is the Style dropdown (all of the other
options are hidden in the formatting toolbar). I've been trying with the
following lines for each function in the formatting toolbar and they don't ...
|
VB code to require entry of date in specific format
Tue, 23 Sep 2008 08:40:20 -0700
Is there a way to force a user to enter a date in a specific format, i.e.
MM/dd/yyyy in a protected cell in a table on a form? I have formatted the
form field the way I would like it to appear, but it does not force the user
to put it in that form. In other words, it still allows them to put the date
in what ...
|
How to close Word document in Open event?
Tue, 23 Sep 2008 08:10:01 -0700
Hi all,
I am using Word object model. I am trying to close the document in
Document_Open event of Word applicationObject. Due to this, Word is crashing.
Is there a way by which, we can verify the document opened
by user and close it there (based on some condition)...?
A ...
|
|
|
positioning to dropdown
Tue, 23 Sep 2008 06:54:15 -0700
I have the following code to position to a certain field on a form:
ActiveDocument.Bookmarks("Text6").Range.Fields(1).Result.Select
What is the syntax to position to dropdown1?
Thanks,
Bryan
...
|
Insert a picture into PowerPoint from Access using automation
Tue, 23 Sep 2008 05:30:02 -0700
I am creating a PowerPoint presentation from Access 2007.
The problem I have is that when I insert a picture into a picture place
holder in a PowerPoint template, the pictures aspect ratio is not retained or
the picture is not sized to fit in the shape.
The code I use to do this is:
.Shapes.AddPicture(str ...
|
my document is in unicode and cannot get it back into english, hel
Tue, 23 Sep 2008 05:24:01 -0700
My mum had started writing a book on her laptop using works. i made sure i
made a copy of this on a usb pendrive when her laptop went in to be fixed.
now when i open the documents in either works or word 2007 it comes up
looking like this:
Ë? ÂË? ÂË? ÂË? ÿÿÿÿÿø ÿð ÿà ...
|