Trying to create a macro to change case on one style
Sun, 16 Mar 2008 15:11:44 -0700
I have Word 2000 and have limited experience in writing macros (though I
was a computer programmer many years ago, so understand logic).
I have a large document (300+ pages) with question/answer type things
all the way through the document. I have it now with 2 styles in my
document: DefaultText (for the q ...
|
Measuring the Width of Text with VBA?
Fri, 14 Mar 2008 13:31:36 -0700 (PDT)
Me again!
Is there any easy way to measure the width of, e.g., a Heading Two
using VBA. (As opposed to measuring the character count, which is
easy but unreliable).
Basically I want to know if any given heading occupies one, two, or
three lines of the page...
Cheers,
Matthew ...
|
Delete a table between two bookmarks
Fri, 14 Mar 2008 10:33:01 -0700
What I would like to do is delete a table between two bookmarks if row 2 cell
1 is blank. I've seen how to delete between two bookmarks:
Dim oRng As Range
With ActiveDocument
Set oRng=.Range(Start:=Bookmarks("BK1").Range.End,_
End:=BookMarks("BK2").Range.Start)
oRng.Delete
End With
But how would I ...
|
Why Doesn't This Loop-within-a-Loop Work?
Thu, 13 Mar 2008 16:09:32 -0700 (PDT)
So what I'm trying to do is loop through all the frames in my
document, and see if they're on the same page as text with the style
"Heading 2". Here's the code:
Dim SrcRg As Range
Dim frm As frame
Set SrcRg = ActiveDocument.Range
For Each frm In ActiveDocument.Frames
With SrcRg.Find
.ClearFormatting ...
|
Insert Text dependant on checkbox behavior`
Thu, 13 Mar 2008 09:35:01 -0700 (PDT)
Hi All.
I am very new to VBA (extremely) and would like to achive the
following:
Checkbox 1 - Remediated
Checkbox 2 - Accept
Checkbox 3 - Continue
If the user selects (ticks) checkbox 1: I need a certain paragraph
(paragraph1) to be added below the checkbox and remove the other
checkboxes.
The sam ...
|
How to reference an active cell
Tue, 11 Mar 2008 12:00:49 +0100
I've recorded a simple macro for Excel, where I work with a row. But I want
to work with a row the active cell is on, but Macro Recorder has writen me
an absolute referencing. Should anyone help me, how to rewrite the code?
Sub Za¹edìní_øádku()
Range("A12:W12").Select !!!
With Selection.Interior
...
|
Creating tables in loop
Mon, 10 Mar 2008 15:04:50 -0700 (PDT)
Hello,
I'm trying to loop through some information, creating some text and a
table at each pass. What I have now (see below) places each table into
the first cell of the preceding table. It probably is an error in my
range but I'm not sure what it should look like. I thought using
Collapse would position the ...
|
|
|
Need to insert "callout" box at current cursor position
Mon, 10 Mar 2008 03:40:03 -0700
I'm trying to create a pair of callouts to visually mark the beginning and
end of certain sections of text. I can use autotext to insert them (one says
"SR Start."; the other says "SR End"), but can't seem to control their
location. I'd like them to appear so the 'anchor' is right next to the
current cursor ...
|
google adsense websites for sale
Sun, 9 Mar 2008 10:51:17 +0530
Dear friends,
Earn from google adsense. A complete ready made google adsense website
package for sale @ Rs. 1000 only.
100 Content Rich Adsense
Web Sites containing more than 16000 web pages for Rs.
1000/only.
click here http://www.googlead.xtreemhost.com/ for sample website ...
|
Excel 2003 - Writing a Macro - How Do I...?
Fri, 7 Mar 2008 17:51:00 -0800
I'm trying to write a macro that will loop down a column and find identical
numbers, then check the values in the offset cells 3 columns away, decide
which value should be kept, and then delete the rows containing the unneeded
values. In other words, if I have 4 rows with the following number in column
C:
...
|
