|
More site info...
microsoft.public.word.vba.general | Forum profile
|
|
Forum profile page for microsoft.public.word.vba.general on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.word.vba.general, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.word.vba.general" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.word.vba.general:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
35
|
148
|
642
|
|
Post:
|
77
|
274
|
1,291
|
|
|
microsoft.public.word.vba.general Posting activity graph:
|
Top authors during last week:
Doug Robbins - Word MVP
13
user's latest post:
How to assign a hot key to an...
Published (2009-11-30 18:42:00)
Word Menu (or Button)>Word Options>Customize>Keyboard shortcuts "Customize" and choose the "Macros" category nixonian wrote: > I saw how to attach a key to a macro when starting to record a new > macro. But how do I attach it after one is created and working? .
user's latest post:
In word 2007, how do I insert...
Published (2009-11-24 19:37:00)
On Tue, 24 Nov 2009 18:24:01 -0800, Diego Hector <Diego Hector@discussions.microsoft.com> wrote: >please someone help me: need to know how to insert in word 2007 from a camera >or scaner. I want to do it straight to word like in word 2003. See http://www.gmayor.com/scan_into_word_2007.htm .
user's latest post:
Opening a user for from a Custom...
Published (2009-11-25 07:09:00)
It's only easy when you know how!! "Dave C" wrote: > Thanks .... that was so simple it was untrue > > "spunkymuffmonkey" wrote: > > > Hi Dave, > > > > One way would be to created a sub within the document or a new module that > > simply loads the userform, e.g.: > > > > Public Sub...
user's latest post:
Copy from certain open excel...
Published (2009-11-27 05:20:00)
Hi, You can get around this problem by having the macro ask for the file name and also prevent opening more than one instance of Excel using code like the following. Const Error_FileNotFound = 1004 Const Error_NotRunning = 429 Const Error_NotInCollection = 9 Dim fileName As String Dim wkbName As String Dim xlApp As Object Dim wkBook As Object Dim newInstance As Boolean With Application.FileDialog(msoFileDialogFilePicker) If .Show...
user's latest post:
Exit Form in...
Published (2009-11-28 14:15:00)
Is there a way that I can turn off the 'X' exit at the top of a user form so I can control the way a form exits from a user button. I know that this is controlled in the form properties in Access but can't located a similar property in the Word form. Thanks .... David
user's latest post:
How to assign a hot key to an...
Published (2009-11-30 19:13:00)
Thanks very much. "Greg Maxey" wrote: > Word Menu (or Button)>Word Options>Customize>Keyboard shortcuts "Customize" > and choose the "Macros" category > > nixonian wrote: > > I saw how to attach a key to a macro when starting to record a new > > macro. But how do I attach it after one is created and...
user's latest post:
Debugging Problem In VBE in...
Published (2009-11-21 15:14:00)
Ah Ha! You just clued me in on something. Indeed there is code in the Word_HTML.dot. I commented out the code inside the template and lo and behold, that solved the issue. I'll can now test to see which subroutine is causing the self-execution. Thanks for you help. Harry-Wishes "Doug Robbins - Word MVP" wrote: > I am not saying that it will help sort out the problem, but if you showed > all of...
user's latest post:
Word 2003 Macro Disappears in...
Published (2009-11-23 08:47:00)
On Nov 23, 10:31?am, Lene Fredborg <l...@REMOVETHISthedoctools.com> wrote: > My guess is that the macro is stored in your Normal.dot (used by Word 2003) > and not in the document in question. Word 2007 has its own Normal.dotm > template and has no connection to Normal.dot. If that is the problem, you can > find and copy the macro in Normal.dot (2003) and insert it into Normal.dotm >...
user's latest post:
selecting text in a document in...
Published (2009-11-25 08:09:00)
Hi All, I have a macro that seeks out a particular string of text in a document and then moves down one line and selects the remaining text nin the document and writes it to a variable and then uses it subsequently in the message section of an email. Recently this method has been failing because the text is not being selected. I don't know if the PC was in EST mode a the time but I need the macro to work no matter what. The...
|
|
|
|
Latest active threads on microsoft.public.word.vba.general::
Started 1 day, 5 hours ago (2009-12-01 03:26:00)
by Pesach Shelnitz
Hi Andreas,
The following macro will remove all frames from the header for even pages in
the current section. (The current section is the section in which the cursor
is located).
Sub RemoveFrameFromCurrentEvenHeaderFooter()
Dim i As Long
Dim myRange As Range
Set myRange = Selection.Sections...
Started 1 day, 22 hours ago (2009-11-30 11:09:00)
by Doug Robbins - Word MVP
Show us the code that you are/were using.
Started 22 hours, 23 minutes ago (2009-12-01 11:02:00)
by Tony Jollans
Easiest way is to switch off the smart quotes option and restore it
afterwards ...
Dim optsave As Boolean
optsave = Options.AutoFormatAsYouTypeReplaceQuotes
Options.AutoFormatAsYouTypeReplaceQuotes = False
' Your replace code as was
Options.AutoFormatAsYouTypeReplaceQuotes = optsave
Started 1 day, 14 hours ago (2009-11-30 18:42:00)
by Greg Maxey
Word Menu (or Button)>Word Options>Customize>Keyboard shortcuts "Customize"
and choose the "Macros" category
nixonian wrote:
> I saw how to attach a key to a macro when starting to record a new
> macro. But how do I attach it after one is created and working?
....
Started 1 day, 18 hours ago (2009-11-30 15:08:00)
by Gordon Bentley-Mix
If the insertion point is always the same, it would probably be much easier
to place a bookmark or bookmarks at the target location(s) and insert the
text into the range(s) specified by the bookmark(s). Trying to determine the
insertion point relative to the top of the document/page is probably much
more work that it's worth, especially as the ...
Started 4 days, 7 hours ago (2009-11-28 01:52:00)
by Doug Robbins - Word MVP
It sounds like you might be using the Content Controls that were introduced
in Word 2007. If you want something that will be compatible with Word 2003,
you will need to either use the Legacy FormField type Dropdown, which
requires that the document be Protected for Filling in Forms, or make use of
a User Form.
Started 4 days, 17 hours ago (2009-11-27 16:05:00)
by Doug Robbins - Word MVP
You do not need to test for the existence of document variables to assign a
value to them.
Your code could be reduced to:
With ActiveDocument
.Variables("weeknum").value = InputBox("Enter the fiscal two-digit week
number", , , 400, 400)
.Variables("regname").value = InputBox("Enter the first three letters of
the region ...
|
|
Hot threads for last week on microsoft.public.word.vba.general::
Started 1 day, 5 hours ago (2009-12-01 03:26:00)
by Pesach Shelnitz
Hi Andreas,
The following macro will remove all frames from the header for even pages in
the current section. (The current section is the section in which the cursor
is located).
Sub RemoveFrameFromCurrentEvenHeaderFooter()
Dim i As Long
Dim myRange As Range
Set myRange = Selection.Sections...
Started 1 day, 22 hours ago (2009-11-30 11:09:00)
by Doug Robbins - Word MVP
Show us the code that you are/were using.
Started 1 week ago (2009-11-25 06:15:00)
by spunkymuffmonkey
Hi Dave,
One way would be to created a sub within the document or a new module that
simply loads the userform, e.g.:
Public Sub ShowUserForm1
Userform1.Show
End Sub
and then link the button to this sub, capice?
"Dave C" wrote:
> I have a couple of userforms that I want to open by ...
Started 6 days, 16 hours ago (2009-11-25 17:03:00)
by Doug Robbins - Word MVP
VBA is the language used for macros in Word
With ActiveDocument.Shapes(1)
.LockAnchor = True
.WrapFormat.Type = wdWrapBehind
End With
See the Help file in the Visual Basic Editor and from the View menu in the
Editor, select Object Browser.
Started 4 days, 7 hours ago (2009-11-28 01:52:00)
by Doug Robbins - Word MVP
It sounds like you might be using the Content Controls that were introduced
in Word 2007. If you want something that will be compatible with Word 2003,
you will need to either use the Legacy FormField type Dropdown, which
requires that the document be Protected for Filling in Forms, or make use of
a User Form.
Started 1 day, 14 hours ago (2009-11-30 18:42:00)
by Greg Maxey
Word Menu (or Button)>Word Options>Customize>Keyboard shortcuts "Customize"
and choose the "Macros" category
nixonian wrote:
> I saw how to attach a key to a macro when starting to record a new
> macro. But how do I attach it after one is created and working?
....
Started 6 days, 18 hours ago (2009-11-25 14:32:00)
by christy c
Hi
along these same lines - do you know if it is possible to use VBA to add to an exisiting header? I do have a template with the header defined but each time the template is used I want it to automatically addd the project name to the existing header.
I was just going to use a message box on open "what is the name of your project". Then I want the...
Started 6 days, 20 hours ago (2009-11-25 12:57:00)
by MS Public
Does the following make any difference?
With Selection.FormFields(1)
.TextInput.EditType Type:=wdCalculationText, Default:=sDefault,
Format:="", Enabled:=False
.CalculateOnExit = True
End With
Peter Jamieson
"spunkymuffmonkey" <spunkymuffmonkey@discussions.microsoft.com> wrote in
message news:...
Started 5 days, 4 hours ago (2009-11-27 05:20:00)
by Pesach Shelnitz
Hi,
You can get around this problem by having the macro ask for the file name
and also prevent opening more than one instance of Excel using code like the
following.
Const Error_FileNotFound = 1004
Const Error_NotRunning = 429
Const Error_NotInCollection = 9
Dim fileName As String
Dim ...
Started 1 week, 2 days ago (2009-11-23 08:47:00)
by turtlehand
On Nov 23, 10:31 am, Lene Fredborg <l...@REMOVETHISthedoctools.com>
wrote:
> My guess is that the macro is stored in your Normal.dot (used by Word 2003)
> and not in the document in question. Word 2007 has its own Normal.dotm
> template and has no connection to Normal.dot. If that is the problem, you can
> find and copy the macro in ...
|
|