|
temporary copy of current word document
hello everyone,
I'm trying to make a "backup" copy of the document before the code
(macro) makes changes in the current document. The macro I made
replaces many things and reformats the document. With this "backup"
copy I can revert back to the original if the user doesn't like the end
result of the macro. In other words an "undo" for all the changes the
macro made.
I thought of going w...
|
13 |
04.07.2006 02:45:16 |
|
|
Move cursor to the last position
Hi to everyone,
I need to move the cursor to the last position of a word document. By now, I
have found a way to do it and it seems to work
Dim r As Range
On Error Resume Next
Set r = ActiveDocument.Paragraphs(1).Range
r.Move wdParagraph, ActiveDocument.Range.Paragraphs.Count
r.Select
Set r = Nothing
On Error GoTo 0
but I am not sure that this is the corr...
|
4 |
03.07.2006 11:16:10 |
|
|
Table of Contents outline levels
I am using Word 2003, creating a macro that will generate a table of
contents for a particular style. I have three styles in the template that
have "level 1" paragraph outline level so that they will show in the
document map (ex. Style A, Style B, and Style C). I have tried recording a
macro that will only produce entries for Style A. While recording, I,
uncheck "use outline levels", I unc...
|
3 |
30.06.2006 13:47:01 |
|
|
I Can't figure out how to gain access to a word document's propert
I'm trying to write a sub that will automatically make a copy of the active
document and save it on a network drive in a folder with the author's name.
The folders already exist on the network. But I can't figure out how to
access the document's AUTHOR field.
For brevity's sake here is the crux of my problem.
DIM strNetFile
' Creates the drive/path/filename string for the saveas...
|
2 |
30.06.2006 00:59:49 |
|
|
InsertAfter problems
I am playing around with VBA in Word to become familiar with it before
beginning a project. So far it has been going well, but I am currently
stumped on this InsertAfter issue. Basically to my mind it should
insert text after the selection, but on the same line. What it is
doing is inserting the text on a new line, which Word then considers to
be a new paragraph. Here is my little practic...
|
4 |
30.06.2006 00:48:48 |
|
|
saving pages as separate files
I have a document of 150 statements (one for each page). Is there a macro
that will save each page as a separate file and name the file with text
found in the document at the same place on each page? Thanks in advance.
...
|
2 |
29.06.2006 19:31:35 |
|
|
wdDialogFileSaveAs won't accept filename variable
I've been able to narrow down the problem I was seeking help on in an
earlier thread. For some reason when using Word2000 the code I'm using to
insert a file name into the SaveAs dialog box causes problems. I apologize
for not narrowing the problem down before starting the other thread.
The following code works to open the SaveAs dialog box ready to save a
document in a specific folder:
...
|
2 |
29.06.2006 13:42:29 |
|
|
How do I transfering field data to populate existing Access table?
I've done several searchs in this and other newsgroups and can find
examples of populating Word fields from an Access database, but not the
opposite. I need to design a Word form with fields that feed into an
Access table. How is this done? If you have any suggestions or links to
other resources, that would be greatly appreciated. I'm using Word 97
but should upgrade to 2003 later this year.
...
|
2 |
28.06.2006 17:42:10 |
|
|
Macros and track changes
Hi, I have created some macros that do various "find/replace" actions. But I
notice that the macros do not work when "track changes" is turned on. Is
there a way to run these kinds of macros with track changes turned on?
Thanks
Amy...
|
5 |
28.06.2006 09:23:47 |
|
|
Finding text inside a document
Hi,
I am trying to process a set of documents and return the list of
documents with the text '_____' (five underscores).
Initially, I thought it was easy, but it is not the case. I tried using
I method:
Application.ActiveDocument.Select
With Selection.Find
.Forward = True
.ClearFormatting
.MatchWholeWord = True
.MatchCase = True
.Wrap = wdFindContinue
.Exe...
|
3 |
27.06.2006 10:28:52 |
|
|
Userform not getting events in batch job
Hi all.
I have some vba code in word 2000 that applies a macro to thousands of
word documents.
I'm trying to get some feedback on what's going on, so I created a
UserForm with some textbox where the macros can output information.
My problem is that the userform doesn't have the chance to get events,
and I can't do anything with it (move it, scroll the textbox) as long
as the bach job is r...
|
4 |
27.06.2006 08:51:59 |
|
|
Moving text
Hi, I would like to create a macro in Word where I can:
Select several paragraphs (doesn't matter how many).
Execute the macro.
The macro finds a piece of text (using wildcards) in the first paragraph of
the selection and moves it to the beginning of that paragraph.
Macro then moves on to next paragraph in the selection, finds the text, and
moves it to the beginning of that paragraph.
...
|
11 |
27.06.2006 00:06:02 |
|
|
Making it "Look Pretty."
Hi all,
I have no hardcore programming knowledge (HTML, CSS) but I've been
assigned to try to find this information. I'm an absolute newbie at
VBA, so the more basic the explanation, the better I will fare.
My father is working on a program in VBA that generates reports in
Word. He found a quick solution for that on the Web somewhere but
didn't have time to study it. It works, but now we...
|
5 |
25.06.2006 07:57:07 |
|
|
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 |
23.06.2006 18:35:05 |
|
|
Programmatically (macro), switch the default language of Word's Auto Text entries?
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C67F07.2ABCC230
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
XPP SP2 (Int'l English version)
Office 2003 SP2 (Int'l English version)
=20
=20
Is there a way, to programmatically (eg through a macro), to switch the =
default language of Word's Auto Text entrie...
|
2 |
21.06.2006 10:34:52 |
|
|
VBA printing pages with logo
I want a macro that print the first page on logo-paper, the second page on
blanco paper, the thirdth en fourth pages on logo-paper?
Who can help me?
Jan...
|
2 |
20.06.2006 10:14:45 |
|
|
wdDialogFileSaveAs works in Word 2003 but not Word 2000?
The following code was developed for use with Word 2003 and it works fine.
However, I've run into a situation where the code seems like it fails to
execute on a Word 2000 machine. Here's the code:
Dim FSO As FileSystemObject
Dim NewDir As String
Set FSO = CreateObject("Scripting.FileSystemObject")
NewDir = "\\Server\FullCase\CaseDocs\" & CaseNumber
If Not FSO.Fold...
|
6 |
15.06.2006 21:25:23 |
|
|
"Send To > Mail Recipient as Attachment" feature of MS Word.
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 |
15.06.2006 03:36:45 |
|
|
create a text box pop up?
I have used vba with other Office programs, but not with Word. I want
to create a glossary of words and phrases for study notes so I can have
a definition pop up when the cursor is over the word. I don't want to
have an individual document for each item, and the comment thing I
tried seems a little intrusive. I'd just like have a simple box with
the definition pop up. Should I be looking at v...
|
3 |
12.06.2006 20:01:16 |
|
|
Find the perfect work at home job for you using our FREE Work at home Job Finder!
Find the perfect work at home job for you using our FREE Work at home
Job Finder!
Get matched with a Home Based Job or Business Plan that suits your
needs and skills.
Simply visit our website and fill in the short form to receive your Job
Match Details for FREE Today!
http://www.typeinternational.com/idevaffiliate/idevaffiliate.php?id=4909_68_3_102
...
|
1 |
11.06.2006 08:09:46 |
|
|
Regular Expression Pattern
Hello,
with a VBA-macro I'd like to find and delete whitespace at the beginning
of each line. I was'nt successfull with the Find-Object and gave the
RegExp-Object a try. But still I didn't find out how to describe that
I'm only searching for whitespace at the beginning of the line.
The pattern I already tried was "^[\s]*".
Any suggests?
Ansgar...
|
9 |
10.06.2006 16:36:13 |
|
|
Select text but not tables
I have this Word document macro that, if there are comments in the text,
selects all the text and changes the font to 14 points:
With ActiveDocument.Range
If .Comments.Count > 0 Then
.Font.Name = "Times New Roman"
.Font.Size = 14
End If
However, if there are tables in the document with a smaller font, the font
change to 14 points
creates havoc with the table format.
Is th...
|
8 |
10.06.2006 14:06:00 |
|
|
Hope this isn't a dumb question, but................
I've noticed that the macros I've recorded show up in the "NewMacros"
under the "Normal" part of the Project Explorer in the VBA IDE. I
assume that means all the code is in the Normal.dot file in the Word
Startup folder.
[snare drum roll] So ... here's my dumb question:
What if I'd rather not add anything to to Normal.dot and would rather
create a file named "AllMyMacros.dot" that...
|
4 |
09.06.2006 22:54:10 |
|
|
closing Word from a macro
There's sure to be a better way, but is it possible to close Word from
a macro? (Not close the doc, but quit Word itself)
I need to run a (recorded+edited) macro to adjust a number of docs
which are generated by Robohelp. My naive plan is to run Word
repeatedly for each .doc from a .BAT script, thus:
DOMAC.BAT
<path>\Winword.exe /mdostuff mytext.doc
where the dostuff macro is...
|
6 |
09.06.2006 18:25:02 |
|
|
Word VB Tutorial?
Does anyone know of a good URL location I could visit that has a Word VB Tutorial? I would like to gain more ("much" more)
knowledge of Visual Basic and in it's MS Word etc applications. I am only a screaming newbie at this point with minimal experience
in programming.
All assistance is greatly appreciated
Cheers
Buck
...
|
2 |
09.06.2006 15:45:54 |