Find first empty row of a table?
Thu, 18 Mar 2010 14:19:59 -0700
One of our Word 2007 document templates contains a table of
data (which is 15 rows by 5 columns in dimension). Using
VBA, how can I determine (starting from the top) which row
is the first empty row?? For example, if the first 4 rows of the
table contain data, that means that row 5 is the "first empty row".
...
|
VBA mailmerge event
Tue, 16 Mar 2010 07:12:26 -0700 (PDT)
Hi
I am writing vba code to modify a mailmerge (Word 2003) document prior
to merging, based on a value in the datasource. The merge itself is
handled by the property management system "Nicor", and each merge uses
a temp datasource file created by Nicor. I am trying to use the
MailMergeDataSourceLoad event to ...
|
Message box
Sun, 14 Mar 2010 16:53:57 -0000
I am using Word 2007 which I cannot put up menus to run macros as you could
in the 2003 version. As I am no programmer !! I cannot get my head around
the ribbon, I downloaded one which you could put macros on and I cannot
manage it. In the old version I used the code below for a yes no box.
Would it be po ...
|
creating a combo box in word
Wed, 10 Mar 2010 11:51:10 -0800
Hello,
I've created a combo box in word, but now everytime I open it, I have to run the VBA code. How can I avoid this action?
Here is the code:
Private Sub ComboBox1_Change()
Me.ComboBox1.List = Split(" Option1 Option2 Option3")
End Sub
ashley.odonnel wrote:
Re: How do I populate a combo box in ...
|
Cant load Word object library into Excel....
Tue, 2 Mar 2010 19:10:44 -0700
I am able to load the "Word 12.0 Object Library"
into Excel 2007 on my home PC. However, when I went
to work and tried to do the same thing I got the following
error message:
"Name conflicts with existing module, project or object
library"
Does anyone know why this is happening?
thanks
...
|
Assign text and variables into an array
Tue, 2 Mar 2010 15:29:01 -0800
I'd like to assign a combination of string variables and text to an array,
but I'm doing something wrong and get a type mismatch error.
Here is part of the code:
Dim strMonth as String
Dim SearchArray As Variant
strMonth = "Februrary"
SearchArray(0) = "day, " + strMonth + " ^#^#"
What ...
|
Find & Replace
Tue, 2 Mar 2010 04:00:49 -0800 (PST)
Hi,
I want to write a vba that allows me to perform a find & replace
limited in a specific part of the text: every time I meet a keyword
"Start", I want to begin to replace all the "A" with "B", until I meet
the other keyword "Stop".
Can you help me?
Thanks,
ML ...
|
|
|
Menus in Word 2007
Wed, 24 Feb 2010 08:21:52 -0800
I often create a toolbar with the list of macros and buttons on it in Word 2003. Opening and using this in Word 2007 lists the macros in the add-in menu. Most macros run without issue in this way. You can write the macros in 2007, but without the toolbar, the macros can only be assigned to the quick menu, which isn' ...
|
Copying
Sun, 21 Feb 2010 22:16:01 -0800
I use Word 2007
I am trying to modify a Word created form so that when somebody enters the
project number under one of the questions, this project number will
automatically appear in the header on all pages of the form. ...
|
Using VBA ti insert one document into another
Sun, 21 Feb 2010 15:04:01 -0800
I have a routien which gathers information for a contract from the user by
way of a form. One check box gives the option to include an addendum from the
users own files. My routine opens the common file open dialog keeps the name
of the selected file as a string and later at print time opens that document,
c ...
|
