How to copy text and header and footer from one document to another
Wed, 21 Nov 2007 23:47:05 -0800 (PST)
Hello,
I have a macro that opens a document, selects the text and then copies
it at the top of the active document, which works well to copy the
body text, but I can't work out how to also copy the header and
footer. The header contains an image and the footer text.
Below is what I currently have:
Dim st ...
|
Problem with macro (cut out old table, replace with new table)
Wed, 21 Nov 2007 23:07:02 -0800
Hi
The following macro works ok if the user selects the table for cutting out
first, which he is supposed to, or, clicks either before or after the table
(because then there is a message box which asks the user to select the table
first).
However, if the user clicks inside the table to be cut, and then p ...
|
Printing in miniature
Sun, 18 Nov 2007 09:17:13 -0800 (PST)
I can't change a document in Excel that keeps printing at about 25%
scale. In print preview it appears to fill the page. I have changed
the size of the cells to make shure it will fit on one page. But when
I print it only prints a small graph in the bottom left corner. I have
tried changing scalings in page setu ...
|
find&replace text throughout a document
Sun, 18 Nov 2007 04:28:00 -0800
I am trying to programmatically replace text throughout a document using
string manipulation and complex logic, which may not easily be coded into the
single assignment statement: .Replacement.Text = "xxx"
which doesn't appear to allow multiple procedural string manipulations of
found text (unless I can hook ...
|
easy way to program
Sat, 17 Nov 2007 13:32:45 +0100
I'm looking for an easy way to program VBA in a graphical way. Advice on UML
alike way's to do VBA (and VBS) are appreciated. JohS
...
|
Macro doc + toolbar button via Email?
Fri, 16 Nov 2007 11:19:00 -0800
Hi
I'm wondering if it is possible to Email a document with a macro attached,
to arrive at receiver complete with macro button on tool bar to run it.
I need to send someone the document and they don't know anything about
attaching buttons to macros.
Thanks ...
|
sending email word macro
Fri, 16 Nov 2007 07:29:07 -0800
I have a macro that sends out emails automatically using Outlook 2002. Right
now I specify the following:
.To
.Cc
.Attachments
.Send
I want to view the email before it is sent out. Once I have viewed the
email I can click on Send Button. What command should I be using? Thanks in
advance. ...
|
|
|
selection of table
Thu, 15 Nov 2007 11:50:02 -0800
Hi
I want to be able to do a particular thing "if a table selection exists".
If it does not exist I want a little message box to appear saying "select
the table first".
What is the vba code for this?
Thanks ...
|
Counting Text Occurrence In A Multi-row Range
Thu, 15 Nov 2007 10:48:45 -0800 (PST)
I've been working to find a solution to counting the cells in a Word
table that are in a multirow range, and have an "X" as text. (Table is
13 rows X 32 columns) Using the code below, I get a count of all of
the "X"s in rows 2 and 3. What I want to do is count the "X"s in the
range (in this case, 2, 31 thru 3, ...
|
Counting Text Occurrence In A Multi-row Range
Thu, 15 Nov 2007 10:02:17 -0800 (PST)
I've been working to find a solution to counting the cells in a Word
table that are in a multirow range, and have an "X" as text. (Table is
13 rows X 32 columns) Using the code below, I get a count of all of
the "X"s in rows 2 and 3. What I want to do is count the "X"s in the
range (in this case, 2, 31 thru 3, ...
|
