|
MailMerge to Document Dialog Box
I have a number of documents (Word 2003) created using MailMerge (Excel as
data source). I've now been asked to automate a task that requires me to use
VBA with some event trapping and command reprogramming. Basically, I'm
trying to read something from a table within the document and put that value
into the header. I'm using VBA and a doc variable because the location of
the data with...
|
4 |
11/26/2008 1:45:00 PM |
|
|
how can i print on envalopes in printer
how do I get an envalop on screen to print on it...
|
2 |
11/26/2008 12:13:19 PM |
|
|
Form Field Properties + Add Row to Protected Table.
Firstly, thank you for reading this post and looking at my problem.
I am currently developing a protected form for users to complete that
contains several separated tables within it.
One of the tables is used to record all children in the household, as most
households do not have more than 4 children I have preset the table to
contain 5 rows (one row is the header), but there is the po...
|
3 |
11/26/2008 10:34:06 AM |
|
|
Word Patches Disabled Spreadsheet obj
Can anyone tell me which (last couple of months?) Word (or Vista) patch(es)
have stopped my Office Web Components spreadsheet from *existing* (it's just
not there anymore - no, not corrupted, deleted, etc.)
Office XP running on Vista HP SP1
TIA
--
Julian I-Do-Stuff
Some Vista stuff, but mostly just Stuff at http://berossus,blogspot.com
...
|
1 |
11/26/2008 8:57:23 AM |
|
|
Compound variable ??
I have a DB with elements like C1AM, C2AM..C10AM, all integers. In other
languages I can concatenate a counter to step through the data items i.e.
C || counter || AM to cycle through the variables. Is there a way in VB6 to
do something similar? I was not looking at an array but if I have to go
there then so be it.
do I = 1 to 10
a = a + C || I || AM
end...
|
15 |
11/26/2008 4:34:12 AM |
|
|
Word 2007 Fields
Where can i get some help on word 2007 fields, namely a database of existing
and what they do and some information about how to work with them?
Tank You....
|
5 |
11/25/2008 10:47:01 PM |
|
|
Returning Protection Type from wdDialogToolsProtectDocument dialog
Hello,
I am trying to write a program that creates a bunch of password protected
documents. To do so, I am running the following code:
With Dialogs(wdDialogToolsProtectDocument)
PasswordResponse = .Display
ProtectionType = .Type
Password = .DocumentPassword
End With
The VBA help titled "Built-in Dialog Box Argument Lists" includes the
argument Type...
|
4 |
11/25/2008 10:32:14 PM |
|
|
Summing cells in a column
Hello,
I'm trying to use a formula to sum the cells in a column in a table. The
problem is that sometimes one or two of the cells will be empty and the SUM
function doesn't work then. Is there a switch or something similar that I
could add to the function that tells it to just skip a cell if it has no
value in it?
Thanks very much for any help....
|
3 |
11/25/2008 8:40:21 PM |
|
|
Macro won't work, please help!
I have CheckBox "Check1" and a FormField "Duration". My macro is supposr to
put "48.6" in the FormField "Duration" when the checkbox has a check, and
when the checkbox is empty "Duration" will also be empty.
Windows XP, Word 2007
Can someone help me with this macro. The error message says "Block if
without end If"
My 'Check1" checkbox is suppose to run the macros on enter.
Here is my...
|
10 |
11/25/2008 7:27:29 PM |
|
|
Table Column Width
I have a table in Word 2007 in which I want the first column to be 1 inch and
the second column to be 5.5 inches. I tried recording the keystrokes, but I
get this error: Run-time error 5992: Cannot access individual columns in
this collection because the table has mixed cell widths. I can't get the
columns to be two separate widths. Can you help?...
|
3 |
11/25/2008 7:12:01 PM |
|
|
Get page number of OLE Object
Hello. I use the following code to generate a text file that lists all
embedded OLE objects in a doc. How do I find the page number where each OLE
object is embedded? Thanks.
********
Sub ListFiles()
Dim shape As InlineShape
Dim sFile As String
Dim nFileNum As Long
Dim sWarning As String
sWarning = "Note: If you are using Word 97 of 2000, " & _
"this macro will not work on f...
|
3 |
11/25/2008 6:02:06 PM |
|
|
How to copy header/footer from DocA to DocB
I am copying multiple documents into a "master" document. I need the headers
and footers copied too, but have not been able to figure out how. Any
suggestions?
Thanks!
--
Vic
www.vicrauch.com...
|
5 |
11/25/2008 2:45:02 PM |
|
|
Checking whether the current header is blank.
Dear Experts:
I would like to check whether the current header is blank (selection
object) The result should is to be displayed in a msgbox (Header is
blank or is not blank). Blank means that there are no characters or
fields in the header. Blank Spaces count as blank and not as
characters.
Thank you very much in advance. Regards, Andreas...
|
4 |
11/25/2008 1:29:04 PM |
|
|
My tool is not working for words
My tool bar in words is not working please HELP!...
|
2 |
11/25/2008 6:55:05 AM |
|
|
Run time error 91
Hello,
I get a Run-time error "91" - Object variable or with block varialbe not set
message on this macro:
Sub tryit()
ActiveWindow.ActivePane.View.SeekView = wdSeekMainDocument
Selection.EndKey Unit:=wdStory
Selection.InsertBreak Type:=wdPageBreak
ActiveWindow.ActivePane.View.SeekView = wdSeekPrimaryHeader
ActiveWindow.ActivePane.View.SeekView = wdSeekCurrentPageHeader
Selec...
|
4 |
11/25/2008 5:53:02 AM |
|
|
Losing macros in template
I am working on a book with several authors and we pass chapters by internet.
I have a template, Book.dot that includes a number of macros. The template is
attached to each chapter. Most of the time the template macros are available
to me. However, I sometimes lose the template macros on saving a chapter doc.
How can I avoid losing the macros? I have yet to share the template with
coau...
|
4 |
11/25/2008 5:35:48 AM |
|
|
Move to end of tab
Hello,
I am new to using VBA in Word. I have a document with multiple lines of data
formatted something like the following: (4 sections and each are at a tab
position)
000018 123 Spring Road Kokomo, IN 46901 LANDLORD
I want to be able to move to the 1st section, copy it, and then paste it
into Excel, but I am not sure how you would navigate through the data i...
|
2 |
11/25/2008 3:28:11 AM |
|
|
Moving tables around in doc
Hi -
I have a document template that has many unique tables. Is there a way that
a macro can be used to move a selected table before the previous table or
after the subsequent table? I would like the user to ultimately control the
order of their tabular info.
Regards,
Pia...
|
3 |
11/25/2008 2:39:00 AM |
|
|
Adding a "prefix" to every line in a list.
I need to add "front:" and "back" anlternatively to every line in a long list.
I don't think search-ad-replace will do.
A macro of sort?
Thanks for helping....
|
4 |
11/24/2008 9:23:11 PM |
|
|
inserting section break - changing to landscape and then back
I have inserted documents into templates with macros and have come across a
new one.
The doc I want to insert is in landscape.
How can I change the orientation and then change back after inserting the
file.
Here is my macro:
Sub HOCheck3()
If ActiveDocument.FormFields("HOC3").CheckBox.Value = True Then
If ILchk = 0 Then
Dim myDoc As Document
Dim docrange As Range
Set myDoc = ...
|
5 |
11/24/2008 9:18:14 PM |
|
|
Auto Formating in Form box
Is there a way to make information that is copied from lets say a pdf into a
form box automatically convert to that documents font and dont size?
In addition to that can I give someone the ability to make this info bold if
they wish to?
I guess when you lock the document down it locks the user out of the font
type and size.
Thanks for the help!!!!...
|
4 |
11/24/2008 7:53:15 PM |
|
|
SendMail in Word 2007 with form protection not working
Word 2007
I have a button control. The code behind the button is
"activedocument.sendmail".
When I have this button in conjunction with a form, and I have protected the
document for "filling in forms", the email button quits working and I can't
do anything else in the document.
This all worked ok in Word 2003.
It may work once or twice when first creating the document, but after ...
|
2 |
11/24/2008 5:11:03 PM |
|
|
Loop through find/replace results
I have a document with the following text "Verse 1", "Verse 2", "Verse 3",
etc in which I want find every occurence of Verse #(whatever the number is)
and add a paragraph mark after the verse number. I can't figure out how to
get the value (the text string found) of the find command. For example when I
find the first occurence (e.g. verse 1) how to I get this value? If I can get
the valu...
|
6 |
11/24/2008 3:21:56 PM |
|
|
Attaching NormalTemplate fails
I’m having an issue with attachment of Normal.dotm in our environment.
Here is the code, which is part of a document creating event procedure in a
template named TheTemplate.dotm:
Private Sub Document_New()
With Application.ActiveDocument
.UpdateStylesOnOpen = False
.AttachedTemplate = Application.NormalTemplate
End With
End Sub
It works if Normal.dotm is locate...
|
1 |
11/24/2008 1:36:02 PM |
|
|
{CheckBoxForm} is showing instead of box
When I use check box form field in word 2007 it displays {CheckBoxForm}. In
other Computers it works fine the box is showing. What might be the problem?...
|
2 |
11/24/2008 9:13:10 AM |