|
Macros from 2003 to 2007
I am making the switch to version 2007 and have many macros in version 2003
that I would like to continue using. What are the differences between the
two versions in terms of VBA and should I expect my old macros to work in
2007? Thanks in advance,
Ricki
...
|
3 |
11/1/2008 10:08:05 PM |
|
|
2 spaces to 1 space macro, Word 2003
Hi All,
I am running Word 2003.
Right now, I have a macro that changes 2 spaces to 1 space in a
document, and I need to refine it a bit. I am posting this macro at the
end of this message.
The problems are two:
First, I need this macro to change spaces only in section 2 of a
3-section document, leaving things as they are in section 1 and section 3.
Second, I want this macro to...
|
4 |
10/30/2008 4:20:10 PM |
|
|
Spell check macro
Currently, when I am editing a report, I often find a word not
recognized by the spell checker, but it is not one I want to add to my
dictionary. Usually, it is a patient's name. I work in hospital records.
What I have been doing is right-clicking the red-underlined word and
selecting "Ignore all."
I would like to assign a macro to a keystroke to do this to the word the
cursor is re...
|
5 |
10/27/2008 1:48:06 AM |
|
|
Accessing Structured Document Tags (SDT)
Hello,
Is there a way to access the content (and properties) of structured
document tags in VBA?
TIA,
Yves...
|
6 |
10/24/2008 10:58:52 AM |
|
|
Duplicate Bookmarks
Hey all!
I've written a userform in Word to fill out certain parts of a document to
speed up a repetitive task. However, it doesn't seem possible to duplicate a
bookmark in the document (i.e. I need the same info in two separate places
in the doc). Is there a work around for this?
Thanks for your help!...
|
2 |
10/23/2008 6:14:26 PM |
|
|
How give a name to a document ?
Hi
I know how to "save as" a document, but how can I first give the currently
document a name so teh user can determine when to save and have that name
appear in the save as dialog ?
TIA !!
...
|
7 |
10/23/2008 5:02:05 PM |
|
|
Get default folder for saving docuemnts invba ?
Hi,
how can i retrieve the name of the default folder for saving the documents
in Word ( as defined in options->default folders)
TIA
...
|
3 |
10/22/2008 6:21:57 PM |
|
|
help with macro please
Hi all,
Any help would be appreciated
I am trying to get this macro to run to the end of the word document
then stop.
But it keeps on looping
Without the loop command it will only do what I want once
Do Until Selection.HomeKey
Selection.HomeKey Unit:=wdLine
Selection.Find.ClearFormatting
With Selection.Find
.Text = "FD"
.Replacement.Text = "...
|
2 |
10/19/2008 9:40:41 PM |
|
|
help with macro please
Hi all,
Any help would be appreciated
I am trying to get this macro to run to the end of the word document
then stop.
But it keeps on looping
Without the loop command it will only do what I want once
Do Until Selection.HomeKey
Selection.HomeKey Unit:=wdLine
Selection.Find.ClearFormatting
With Selection.Find
.Text = "FD"
.Replacement.Text = ""
...
|
1 |
10/19/2008 6:24:22 PM |
|
|
VBA Ending a Search
I need some vba scripting that would search for the filename field (in both
main document and headers and footers) and replace it with a filename field
(that includes no path) and automatically quit the macro after no more
occurrences of a filename field are found.
I can get it to work but can't get it to loop successfully and then quit
when it reaches the end of the document.
Any he...
|
2 |
10/17/2008 10:50:21 PM |
|
|
Find & replace with [! ]
Hi from Meudon (suburb of PARIS FRANCE EUROPE)
I want to find & replace using [!] but i can succeed why?
In a .doc i want to replace ",space" by ",^l^t"
and the "," (, alone) by ",^l
I use a joker (=wildcard) to tag the first case : #
so after the first pass i get #,#,
then i want to replace the solitar comma by a search on [!#],[!#] but
unsuccesfuly!
Why ?
Thanks for your hel...
|
3 |
10/16/2008 7:42:50 AM |
|
|
are rulers displayed ?
Hi from Meudon near by Paris (France/Europa)
How can i check if rulers are displayed or not ?
Thank by anticipation.
...
|
3 |
10/15/2008 6:51:28 AM |
|
|
Delete all wordart?
Hi
has anyone got some vba code to delete all wordart from a doc? I've
hunted down some that deletes all text boxes, buit can't find any that
does wordart
TIA
Steve...
|
6 |
10/13/2008 8:14:14 PM |
|
|
Can Word Print Out Other Applications?
I was wondering if I could use MS Word to print out other applications (i.e.
PDF, Excel, etc.) I need to create a macro which can print the contents of a
folder. I know there are applications out there than can do this, but I need
to perform some specific operations within word that would will be
incorporated into printing files in various folders, many of which are not
..doc files.
...
|
2 |
10/7/2008 2:19:46 AM |
|
|
unlock citation field in Word 2007
Hello,
I'm having a Word document containing several citation fields. I want
to remove all of those through VBA code:
Public Function DeleteCitations()
Dim fld As Field
For Each fld In Application.ActiveDocument.Fields
If fld.Type = wdFieldCitation Then
fld.Select
Selection.Delete
End If
Next
End Function
The Delete command is...
|
4 |
10/6/2008 8:44:36 AM |
|
|
Undo changes to graphics macro??
Background info: my office is changing to a preprinted letterhead. I want
to create a document template that shows the graphics on the template but
does not print them. This template will be used by everyone in the office.
I received some help earlier created a macro to accomplish the above task.
I created a macro that sets the letterhead logo brightness to max and
contrast to min w...
|
5 |
6/30/2007 12:49:49 AM |
|
|
Forms in word
Hi there
I have a document that I have set up as a form in Word. It has two textual
boxes at the beginning of the form for names of people. These peoples names
can appear throughout the document within textual boxes, and what I would
like is to populate the two boxes at the beginning of the form and then have
the other boxes populated automatically with the correct names..
I sadly do...
|
3 |
6/29/2007 3:36:04 PM |
|
|
Drop down menu for 100 items & Autocomplete
I am trying to design a protected MS Word 2003 template. Data from
this form will eventually be imported into Access. One of the fields
will be used to do a join on a look up table in Access so the
information inputted into the word document must be standardized.
I figure I will have to create a drop down list to accomplish this.
The problem is that the list has about 100 items. I would lik...
|
2 |
6/29/2007 8:35:02 AM |
|
|
Exclude hidden appendix from search range in vba
Hello,
In a word 2003 documend, is there a way to exclude from a search range
(vba) the hidden appendix used for the browser ? when I use the
search module from Doug & Helmut, I've got results inside this hidden
part but I need only to search in the "visible" part of the file..
Any way to do this ??
Many thanks in adabce
JL...
|
9 |
6/28/2007 5:00:33 AM |
|
|
File Open
I am using Word 2003 and would like to create a macro that goes to File,
Open and navigates to a certain folder. Once it gets to that folder, the
macro stops. I know I am missing the last line of code to accomplish this.
TIA,
Ricki
...
|
3 |
6/28/2007 12:36:31 AM |
|
|
How to count in VBA?
Hi -
I'm creating a userform with various textboxes, docvariables, and
listboxes. The problem I am now faced with is two fold:
Problem 1) I need a way to count count the data entered into the
textbox and the result of the count will perform a specific action.
For example: user enters 10 lines of text (each ended with a carriage
return) the resulted output would provide the word "apple"...
|
11 |
6/27/2007 1:32:54 PM |
|
|
unprotect then protect document...
Hi All,
I need help.
I have a template which is being auto populated with data from an
outlook form. Everything pretty much works like a charm; however,
since the template is protected I need to unprotect the document in
order to allow it to populate then protect it once again.
Can someone help me with the proper syntax or show me where I can find
the answers....I've researched this ...
|
6 |
6/26/2007 8:46:18 AM |
|
|
VBA
Hi everyone. how to get started with VBA?
many thanks.
...
|
2 |
6/25/2007 3:52:50 PM |
|
|
Search string and copy all text at the end of the section
Hi all,
I need to search for a string in a document , select all the content
after this string until the end of the section and copy this
selection in a new document.
As I'm new in vba word, I don't know the best way to do this, so any
help would be very kind.
Many thanks in advance.
Regards
...
|
5 |
6/24/2007 7:08:39 PM |
|
|
regex request
I need to come up with a regex routine that will extract some data
from a file, and I am admittedly lousy with regexes.
The file contents are as such. Either there will be a single entry
such as...
***********************************************
(header info)
1:
Some data (multiline)
-or-
(header info)
1:
Some data (multiline)
2:
More data
etc...
******************************...
|
10 |
6/23/2007 7:06:47 AM |