|
More site info...
Discussions in microsoft.public.word.vba.general - www.microsoft.com/communities/newsgroups... | Site profile
|
|
Site profile page for http://www.microsoft.com/communities/newsgroups....
This report page has aggregated and summarized the online discussions from the Message Board located at http://www.microsoft.com/communities/newsgroups....
This site profile page outlines general site statistics such as: Users Activity, Site Activity, Site Rank, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional site profile information for http://www.microsoft.com/communities/newsgroups... is also shown in the following divisions:
1) Top 10 Active Forums during Last Week
2) Top 10 Site Forums
3) Latest Active Threads
4) 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 site's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity table on Discussions in microsoft.public.word.vba.general:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
30
|
127
|
636
|
|
Post:
|
60
|
226
|
1,266
|
|
|
Authority Badge:
|
|
|
BoardReader Authority Badge code for Discussions in microsoft.public.word.vba.general (http://www.microsoft.com/communities/newsgroups...)
|
|
Put this code anywhere on your forum page:
|
|
|
|
|
|
|
|
Rating - The position measured by activity among all forum sites tracked by BoardReader.
If rating is 10 there are 9 forum sites which have higher activity.
Posts - Number of posts on forum site during last 7 days.
Threads - Number of threads on forum site active during last 7 days.
Authors - Number of authors which contributed to the site within last 7 days.
|
|
|
|
|
Discussions in microsoft.public.word.vba.general posting activity graph:
|
|
http://www.microsoft.com/communities/newsgroups/list/en-us/default.aspx?dg=microsoft.public.word.vba.general Alexa graph:
|
Top authors on Discussions in microsoft.public.word.vba.general during last week:
Doug Robbins - Word MVP
13
user's latest post:
Drop downs in Word 2003 in...
Published (2009-11-28 01:52:00)
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.
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:
Insert a blank paragraph and...
Published (2009-11-20 14:09:00)
Disregard this question, I found my answer, thanks "Angie M." wrote: > Sorry forgot to add that I do have the page numbering piece which is: > > Selection.Sections(1).Footers(1).PageNumbers.Add PageNumberAlignment:= _ > wdAlignPageNumberCenter, firstPage:=False >
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:
Changing more than one part of...
Published (2009-11-25 05:12:00)
Now that you are using Word2007 the option I recommend is to use mapped Content Controls. See: http://gregmaxey.mvps.org/Repeating_Data.htm (section 7) and http://gregmaxey.mvps.org/Mapped_Content_Control.htm h0pal0ng wrote: > Hi, everyone. Got a question I'm hoping someone can help with. > > I have been given a form which is a Word Template and asked to add in > functionality that would take the...
user's latest post:
Help with variables!!! in...
Published (2009-11-27 14:24:00)
I need to take variables entered in an input box and use them in other procedures within the project. After many failed attempts, I have this, but it doesn't reset the variables with each instance. Any ideas? I tried Public variables but it said I couldn't use them with a Sub or Function. Public Sub filenames() Dim WeekNumber, RegionName, Month, WeekNumberBox, RegionNameBox, MonthBox WeekNumberBox = "Enter the...
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:
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 >...
|
|
|
Top 10 active forums on Discussions in microsoft.public.word.vba.general during last week:
|
|
Top 10 forums on Discussions in microsoft.public.word.vba.general:
|
|
|
|
Latest active threads on Discussions in microsoft.public.word.vba.general:
Started 1 day 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, 3 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 1 day, 7 hours ago (2009-11-30 11:09:00)
by Doug Robbins - Word MVP
Show us the code that you are/were using.
Started 3 days, 17 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, 2 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 ...
Started 4 days, 4 hours ago (2009-11-27 14:18:00)
by Doug Robbins - Word MVP
Maybe you need the big stick approach. However, if your application is
logically designed, users should have little reason to tinker with it. In
almost all cases, it is poorly designed applications that do not do properly
what the user want that invite tinkering.
Started 4 days, 4 hours ago (2009-11-27 14:15:00)
by Doug Robbins - Word MVP
Firstly. there is almost certainly on need to moving the selection to
various parts of the document.
Probably a better way to display the selected dates in the document would be
to use Docvariable fields.
Or, perhaps use Datepicker content controls directly in the template itselt.
Without knowing more about your form, it is ...
Started 4 days, 13 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 ...
|
|
Hot threads for last week on Discussions in microsoft.public.word.vba.general:
Started 6 days, 12 hours 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, 2 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 3 days, 17 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 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, 4 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, 6 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 4 days, 13 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 day, 7 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, 1 day 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 ...
Started 1 week, 1 day ago (2009-11-23 11:38:00)
by Doug Robbins - Word MVP
|
|
Size: 698 bytes
