|
Typing text in a frame
Hi
I've got a macro with these lines on code in it.
Selection.GoTo What:=wdGoToBookmark, Name:="Department"
Selection.TypeText Text:=strDepartment
Selection.GoTo What:=wdGoToBookmark, Name:="Address"
Selection.TypeText Text:=strAddress
Lines 3 & 4 work fine. Lines 1 & 2 appear to work but the text doesn't
appear. The only difference is that the bookmark ...
|
5 |
8/30/2006 9:07:01 AM |
|
Word 2003 Shortuts
Hi all,
I defined several shortcuts to macroos. All shortcut keys are displayed
in the keyboard menu, so they all exists, But he problem some work and
some don't. I even wrote a macro with keybindings. That even didn't
help.
Anyone a solution?
...
|
5 |
8/23/2006 7:26:18 AM |
|
copy select rows
Hi
I would like to have a macro to find a particular style(A) and copy that
row. Once it finds all the "A" styles, it should copy all the rows to the
clipboard and open a new document and paste the clipboard contents. Here is
part of the pseudocode:
Jim
History
Fall
A
Great student
Alice
Art
Spring
B
Loves to learn...
|
2 |
8/20/2006 4:38:37 AM |
|
FAQ - Frequently Asked Questions - vba - please read before posting - unofficial August Posting
FAQ = Frequently Asked Questions - brief - vba - unofficial
This FAQ is posted every ten days or so.
Please save us all some time by reading it before posting to the
news group.
This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-...
|
1 |
8/7/2006 4:43:30 PM |
|
Capture insert new row in table event
Is it possbile to capture the insert new row (above or below) event?
When they add a new row I want to add bookmarks to the cells?
Any help/direction is much appreciated.
Thanks
-Sarju
...
|
3 |
8/4/2006 9:42:42 PM |
|
Nested Loop statements
Hello,
Im relativly new to VB and having some problems I hope someone can help me
with...
I have some master worksheets listed on a page called tree (they are in
coloumn H) which I wish to copy some of these have sub worksheets (also
listed on Tree) underneath in coloumn (i) which I would like to copy into the
same workbook. I have tried to do this below by using two loops but am not
su...
|
2 |
8/2/2006 1:45:09 PM |
|
Black Belt Problem: How to load 20x20 icons in Word (Office CommandBarButton)
** reward for solution! **
Can anybody tell me how to accurately load the contents of a 20x20 bitmap
(or even a 16x16 bitmap) into an Office CommandBarButton in Word? I've been
trying to get this to work, and tearing my hair out (so please accept my
apologies for posting to 3 groups.)
I have examined the Office CommandBars in Word 2003 in detail, using
magnifier. It is quite clear ...
|
6 |
8/1/2006 3:10:01 PM |
|
Set different keyboard shortcuts to different documents
i need to set unique keyboard shortcuts to different types of dicuments.
I tried to use template and to each template set the unique keyboard
shortcuts.
When I open couple of different word documents in the same time the last
opened document influance the previous opened documents.
It is happenning when openning documents in the same process.
I cant force the user to open a docuemnt i...
|
3 |
7/31/2006 1:59:39 PM |
|
Paragraps range Question.
Hi all,
I'm trying to collapse and expand a range of paragraphs in my word document
programmatically using c#. My purpose is the user can click a button then a
range of paragraphs collapse or expand as same as the function provides in
outline view.
can anyone give me some hint how to do it in c#.
Thanks Forum...
|
2 |
7/30/2006 9:40:24 PM |
|
cell name
I have an embedded excel sheet in my word doc.
I wonder if I can name a cell (my totaling cell) in the excel
worksheet so that I can use it to update a field instead of hardcoding
an r1c1 addr that will change under various conditions? I've looked in
Word's format/cells, but it doesn't show anything about naming excel
cells.
Thanks
Joanne...
|
3 |
7/27/2006 4:11:09 AM |
|
FAQ - Frequently Aske Questions - vba - please read before posting - unofficial July posting
FAQ = Frequently Asked Questions - brief - vba - unofficial
This FAQ is posted every ten days or so.
Please save us all some time by reading it before posting to the
news group.
This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-...
|
3 |
7/26/2006 3:17:37 PM |
|
HOWTO Add a button to Word's current toolbar.
HOWTO Add a button to Word's current toolbar.
Please help,
I'm using VC++ and I want to add a button to a Word toolbar. I want the
button to invoke a macro I make on the fly, but first I need to gett he
button there. The difficulties I see are as such:
1) Given the Application object, how do I find which tool bars (or command
bars) are currently up?
2) Are there "default" Word to...
|
3 |
7/24/2006 4:53:02 PM |
|
blank page
Hi,
I have a word doc two pages and header on each page. When the paragraph
reaches end of the first page, sometimes word unncessarily creates next page
which is a blank one. Ofcourse the header will come on that page also. So I
tried to delete the second page with backspace. But I was not able to delete
the second page. Any suggestions? ...
|
2 |
7/21/2006 6:17:59 PM |
|
Saving Document with given Filename Only
Hi...
Everybody
I am having a problem in saving document with sequentially document
numbering. I want to save document with name "a1.e" or "a2.e".. and
document cannot be save with other name. The name of the document
should start with "a" & end with "e". I also want to sequentially
number that document. I am using bookmark to save that document. When I
run & save this document it saves ...
|
2 |
7/18/2006 6:49:39 PM |
|
Office 2007
Does anyone knows how to add a TAB onto the RIBBON with Word2007?
...
|
2 |
7/10/2006 3:45:56 PM |
|
empty cell
Hi,
In my word doc I have a table. And I am checking whether first cell is
empty. Here is how I am doing. The cell is mix of text and numeric for
example '1 (2%)'. But it is not working. Any solution? And I am doing this
check on the cell content on each page of the table.
Set rngCell3 = rngPg2.Rows(1).Cells(2).Range
' rngPg2 refers to a page in a table.
rngCell3.Select
...
|
2 |
6/27/2006 6:20:26 PM |
|
Data Source Location Change
Hello...
I have a merge document (word 2002 sp3) which the data source is an
excel file. I run this merge with a macro. I need to change the
location of the source file. When I do this it appears to break, not
only the some of the formatting (which I was able to fix), but the word
merge doc cannot seem to connect to the data source automatically...It
prompts for the data source always, even ...
|
2 |
6/26/2006 6:44:01 PM |
|
Sub document w/ mail merge data
is it possible to have the master docuement mail merge data be different from
the sub document mail merge data?
I have letters that go to a person and it lists people and addresses who
referenced that person. So a letter to John Smith that lists 10 different
contacts (names & addresses). To conserve space i want the names and
addresses to lists in 2 columns.
If i use one data source i ...
|
4 |
6/24/2006 9:47:02 PM |
|
FAQ - Frequently Aske Questions - vba - please read before posting - unofficial June posting
FAQ = Frequently Asked Questions - brief - vba - unofficial
This FAQ is posted every ten days or so.
Please save us all some time by reading it before posting to the
news group.
This newsgroup is about VBA - Visual Basic for Applications -
which is the programming language for Word 97-2003 (macros).
There is a longer FAQ with more questions and links that is
regularly posted in the non-...
|
2 |
6/23/2006 6:35:05 PM |
|
"Send To > Mail Recipient as Attachment"
Hi,
I have been doing a lot programming with Word API recently. However, I
have never used much of "Send To > Mail Recipient as Attachment"
feature of MS Word. At my company, we need to programmatically pass a
Word document off to Oulook using the "Send To > Mail Recipient as
Attachment" feature of MS Word. To those who have experiences in
using this feature before, I have couple quest...
|
2 |
6/15/2006 3:41:50 AM |
|
Word to BBCode VB (Help with coding bugs)
Because I could not find one on the web, I pieced together a VB Macro
that can convert a word doc 2000+ into BBCode. I suck at VB, and this
is probably not the most efficient coding practice, but hey it works.
For the time being I am keeping within the original BBCode specs listed
http://www.phpbb.com/phpBB/faq.php?mode=bbcode
If anyone can help I would really appreciate it.
Right now, t...
|
3 |
6/9/2006 7:29:41 PM |
|
Mail Merge Event Won't Fire
I have a mail merge routine in an Access module (see below). It runs the mail
merge, but never fires the MailMergeAfterMerge Event in Word. I can
un-commnet the "wrdApp.Visible = True" statement and the merged document is
displayed, but the event never fires. I do have a "Dim WithEvents wrdApp As
Word.Application" in a form that calls MARSMailMerge, which has worked in a
simpler test cas...
|
2 |
6/8/2006 6:42:54 PM |
|
Updating a table in a word doc with data from SQL
I am trying to place data from SQL into tables in a word document. I
have successfully done this using form fields but I am struggling with
how to locate the correct table in the word document and how to copy
the information from the recordset to the table.
Any ideas are much appreciated.
...
|
2 |
6/3/2006 5:33:20 AM |
|
HorizontalLine
I have a table which occupies like 40-50 pages. I would like to add a
horizontal line
at the bottom of the table on each page of the doc, not bottom table border.
Is this possible using VBA....
|
3 |
6/2/2006 7:20:01 PM |
|
range
Hi,
I have a table. I want to set range for the first cells in the first row.
And test whether content in the two cells is empty or not. Here is the code
that I am using. But it is selecting only the first cell content.
cellNumber = rngPg1.Rows.Count
Set rngCell1 = rngPg1.Rows(1).Cells(1).Range
Selection.MoveEnd Unit:=wdCharacter, Count:=1
rngCell1.MoveEnd wdC...
|
3 |
6/2/2006 5:24:03 PM |