Field Result
Mon, 29 Sep 2008 07:46:01 -0700
I have a table with numeric fields in. I want to run a macro which deletes
rows of the table if the result of a field is 0. I cannot seem to get the
result into VBA. I have called the field POAC and bookmarked it ANSPC but
when I put in if POAC = 0 then application.run macroname:="tidyup" it runs
the macro e ...
|
Outline List Template numbering changes with another computer
Mon, 29 Sep 2008 05:59:58 -0700 (PDT)
I followed the Shauna Kelly rules for setting up numbering for my
template. (I picked one Outline List Template and set all subsequent
headings from there and linked them to the appropriate heading
styles.
And I named my list template.)
The template has user forms for soliciting info from the User,
including ...
|
How to assign ToolTip for button on tool bar?
Mon, 29 Sep 2008 02:56:37 -0700 (PDT)
Hello.
I placed button of my macro on the tool bar. When I bring mouse cursor
to this button I get ToolTip with the name of my macro. But I can't
assign own ToolTip and own icon for this button. Is it possible and
how?
Thank you very much. ...
|
Suspend Undo Function
Mon, 29 Sep 2008 01:45:01 -0700
Hello
OS: Windows XP SP2
App: Office 2003 SP3
I would like to suspend the Undo function in Word. Is it possible using VBA?
Regards
Mike ...
|
Encoding in Documents.Open
Sun, 28 Sep 2008 16:27:01 -0700
I have a substantial number of text documents that I open in Word (2003) and
do some processing on. To get started, I recorded a macro that opened a
file, did a couple of things to it, and closed it. I have made several
additions to the macro and tested it over the last couple of weeks.
A couple of days a ...
|
customise list number
Sun, 28 Sep 2008 15:52:01 -0700
Hi,
Just wondering if in word VBA, there is any way of knowing when users
finishes with the list bullet points.
I know that usually by pressing "enter" key twice, the word ends the list
and move the insertion cursor back to the very left alignment as follows
some texts
1. cats
2. dogs
| < ...
|
Docproperty Docvariable or Mail Merge
Sun, 28 Sep 2008 14:56:29 -0700
If I wish to automate a word document (2003) and take data from an access
database via vba, When is the correct time to use a docproperty or a
docvariable or a mergefield switch in the word doc?
Which one is best for what purpose?
The doc will be used for autoquotes with fileds filled in via a database an
be ...
|
|
|
Text of first paragraph that has been formatted with a user defined
heading style to be displayed in a msgBox
Sun, 28 Sep 2008 13:42:39 -0700 (PDT)
Dear Experts:
Below macro checks whether a user-defined heading style (Heading_IV)
has been applied. If so, it shows the section number of the first
occurence of the custom-defined heading style (Heading_IV) as well as
the corresponding page number of the first occurrence.
It is working fine.
BUT I al ...
|
How to move to last line of current page?
Sat, 27 Sep 2008 23:03:18 -0700 (PDT)
Hello.
There is one document with many pages. The insert point is on one (on
any) page. I need to move to last line (in start this line) on this
page. How can I do it?
Thank you. ...
|
Building Block Loop - won't insert Building Block
Sun, 28 Sep 2008 12:46:31 +1000
Hi need help with trying to loop a building block - it won't insert.
Building block is saved in Building Blocks.dotx for the moment as:
Custom Autotext
Category Receipts
Title Receipt
Error Highlighted:
Set objBB = objTemplate.BuildingBlockTypes(wdTypeCustomAutoText) _ *** Error R ...
|
