WORD how to vary a constant by program
Tue, 10 Jun 2008 00:54:56 -0700 (PDT)
Hi,
In a .doc i have à UserForm, with some TextBoxes and other controls
too.
I want to populate the TextBoxes with permanent text, so that why i
store this "permanent" text in a constant.
But from time to time it is necessary to vary the "permanent text".
How i can do this thing :
Store permanent text, ...
|
Deleting redundant lines
Thu, 5 Jun 2008 14:26:49 -0700 (PDT)
Hi,
Have the following kind of automated listings. Need to eliminate the
duplicate time entries. Can't figure out how to compare current time
to the previous time. See my preliminary macro at the end. There can
be weeks of this. The macro gets no errors. Please no laughing out
loud or snorting. However, snicker ...
|
Inserting footnote into automated word document from Access
Thu, 5 Jun 2008 11:25:01 -0700
Hello, I am fairly new to Access databases and programming with VBA. However,
my problem is this:
I have a database in which I write information to a word document table
using fields. The table size is variable so I have code which copies and
pastes the rows of the table and updates the fields as required. ...
|
Beginner question
Wed, 4 Jun 2008 14:54:15 -0600
I'm using Word 2003 on a Vista Business box. I've tried to duplicate a
macro shown in VBA for Dummies 4th Edition to remove highlighting of text.
I'm searching for yellow highlighting and want to simply remove it. Where
have I gone wrong - I keep getting a 91 error regarding the line "With
DoSearch" at top ...
|
Making an automatic subtotal at the bottom of each page
Wed, 4 Jun 2008 06:26:01 -0700
I was wondering is it possible to have word/excel make and automatic subtotal
at the bottom of each page, when all the data is being transferred from C5.
I have made a standard order page using the option to print to a word
document in c5. And when the order gets big enough it transfers to a second
page, is ...
|
How add new table using VBA
Tue, 3 Jun 2008 03:31:00 -0700
I have a problem with new table:
ActiveDocument.Tables.Add range:=mysec.range, NumRows:=2, NumColumns:=2
mysec.range.InsertBefore Chr(13) & Chr(10) & "text 1"
But the "text 1" is disappearing or is in a cell (1,1) of the table.
How can I add the text before the table??
Also Do You know how put the new line ...
|
Initialising comboboxes during form-load
Tue, 3 Jun 2008 03:29:01 -0700
I use the followin sub to initialise the rowsource of my comboboxes (from an
Access-table) during form-load.
Naamlijst is the name of the list I want to use for a specific combobox.
Veldnaam is the fieldname of the combobox I want to initialise.
FormNaam is the FormName on which the combobox is used.
The ...
|
|
|
Something keeps setting my macro security to high
Mon, 2 Jun 2008 17:08:42 +0200
Hello,
I have some macros in Word and Outlook. I have set my macro security
settings to low (I have firewall and LiveOneCare antivirus) so that I can
run the macros. But something keeps resetting the macro settings to high, so
that my macros do not run. Any suggestions for the culprit?
...
|
VBA Command to Refresh Excel Charts in Word 2007?
Sun, 01 Jun 2008 18:14:19 -0300
I've linked a couple of Excel charts to a Word document and would like
to have VBA refresh these charts on demand (the update method for this
particular Word document is set to manual).
Using the mouse, I can click on the Office Button - Prepare - Edit
Links to Files, highlight the source files to be updated a ...
|
Trying to Split Selection.Text
Sat, 31 May 2008 14:36:01 -0700 (PDT)
Hi,
I'm trying to swap two parts of a string separated by a tab. The text
lines also have a tab at the begining and look like this:
Text 1
Text 2
I need them to look this this:
1 Text
2 Text
I have tried different Dim statements as shown below and get the
following errors:
Error for Dim MyA ...
|
