Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

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.
Site: Discussions in microsoft.public.word.vba.general - microsoft.public.word.vba.general
Discussions in microsoft.public.word.vba.general
(site profile, domain info microsoft.com)
Title: microsoft.public.word.vba.general
Url: http://www.microsoft.com/communities/newsgroups...
Users activity: 2 posts per thread
Forum activity: 35 active threads during last week
 

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:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Doug Robbins - Word MVP
13
user's latest post:
How to change .attachedtemplate...
Published (2009-11-30 11:09:00)
  Show us the code that you are/were using.
Greg Maxey
4
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? .  
Jay Freedman
3
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 .
spunkymuffmonkey
3
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...
Pesach Shelnitz
3
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...
Dave C
3
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  
nixonian
3
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...
Harry-Wishes
2
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...
turtlehand
2
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 >...
Phil Stokes
2
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::

Discussions in 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...
Thread:  Show this thread (7 posts)   Thread info: Searching for Frame in current header and delete it in microsoft.public.word.vba.general Size: 877 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Searching for Frame in current header and delete it in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
Discussions in microsoft.public.word.vba.general
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.
Thread:  Show this thread (7 posts)   Thread info: How to change .attachedtemplate from VBA in Word 2007 in microsoft.public.word.vba.general Size: 247 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to change .attachedtemplate from VBA in Word 2007 in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
Discussions in microsoft.public.word.vba.general
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
Thread:  Show this thread (2 posts)   Thread info: Replacing french quote in microsoft.public.word.vba.general Size: 595 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Replacing french quote in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
Discussions in microsoft.public.word.vba.general
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? ....
Thread:  Show this thread (4 posts)   Thread info: How to assign a hot key to an existing macro in word 2007? in microsoft.public.word.vba.general Size: 698 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to assign a hot key to an existing macro in word 2007? in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
Discussions in microsoft.public.word.vba.general
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 ...
Thread:  Show this thread (2 posts)   Thread info: How to move up &down insertpoint in a document in microsoft.public.word.vba.general Size: 1,580 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to move up &down insertpoint in a document in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
Discussions in microsoft.public.word.vba.general
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.
Thread:  Show this thread (4 posts)   Thread info: Drop downs in Word 2003 in microsoft.public.word.vba.general Size: 550 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Drop downs in Word 2003 in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
Discussions in microsoft.public.word.vba.general
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 ...
Thread:  Show this thread (2 posts)   Thread info: Help with variables!!! in microsoft.public.word.vba.general Size: 2,518 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Help with variables!!! in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
 

Hot threads for last week on microsoft.public.word.vba.general::

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...
Thread:  Show this thread (7 posts)   Thread info: Searching for Frame in current header and delete it in microsoft.public.word.vba.general Size: 877 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Searching for Frame in current header and delete it in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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.
Thread:  Show this thread (7 posts)   Thread info: How to change .attachedtemplate from VBA in Word 2007 in microsoft.public.word.vba.general Size: 247 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to change .attachedtemplate from VBA in Word 2007 in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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 ...
Thread:  Show this thread (4 posts)   Thread info: Opening a user for from a Custom Toolbar in microsoft.public.word.vba.general Size: 977 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Opening a user for from a Custom Toolbar in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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.
Thread:  Show this thread (4 posts)   Thread info: Images and word objects/methods in microsoft.public.word.vba.general Size: 512 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Images and word objects/methods in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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.
Thread:  Show this thread (4 posts)   Thread info: Drop downs in Word 2003 in microsoft.public.word.vba.general Size: 550 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Drop downs in Word 2003 in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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? ....
Thread:  Show this thread (4 posts)   Thread info: How to assign a hot key to an existing macro in word 2007? in microsoft.public.word.vba.general Size: 698 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: How to assign a hot key to an existing macro in word 2007? in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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...
Thread:  Show this thread (3 posts)   Thread info: Word header vba in microsoft.public.word.vba.general Size: 5,908 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Word header vba in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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:...
Thread:  Show this thread (3 posts)   Thread info: Calculation Form Field in microsoft.public.word.vba.general Size: 6,349 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Calculation Form Field in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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 ...
Thread:  Show this thread (3 posts)   Thread info: Copy from certain open excel file in microsoft.public.word.vba.general Size: 2,402 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Copy from certain open excel file in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"
microsoft.public.word.vba.general
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 ...
Thread:  Show this thread (2 posts)   Thread info: Word 2003 Macro Disappears in Word 2007 in microsoft.public.word.vba.general Size: 2,168 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Word 2003 Macro Disappears in Word 2007 in microsoft.public.word.vba.general :: microsoft.public.word.vba.general :: Discussions in microsoft.public.word.vba.general"