MSGROUPS.NET | Post Question | Search | About | Groups | Contact | Register | Login



microsoft public excel misc (5725)

microsoft public outlook general (4851)

microsoft public excel programming (4223)

microsoft public word docmanagement (3537)

microsoft public excel worksheet functions (3208)

microsoft public access (3168)

microsoft public windowsxp general (2045)

microsoft public windows vista mail (1629)

microsoft public office misc (1576)

microsoft public windows vista general (1511)

microsoft public windows live mail desktop (1366)

microsoft public access queries (1331)

microsoft public powerpoint (1277)

microsoft public access formscoding (1213)

microsoft public mac office entourage (1204)

microsoft public dotnet languages csharp (1183)

microsoft public access forms (1167)

microsoft public internetexplorer general (1133)

microsoft public access modulesdaovba (1076)

microsoft public windows server sbs (1064)

microsoft public greatplains (1055)

microsoft public mac office word (1026)

microsoft public outlook calendaring (965)

microsoft public excel (936)

microsoft public sqlserver programming (906)

microsoft public project server (884)

microsoft public windowsupdate (825)

microsoft public windowsxp help and support (801)

microsoft public windowsmedia player (785)

microsoft public project (782)

microsoft public access reports (766)

microsoft public mac office excel (765)

microsoft public exchange admin (754)

microsoft public dotnet framework aspnet (743)

microsoft public sqlserver server (703)

microsoft public outlook (701)

microsoft public outlook contacts (681)

microsoft public dataprotectionmanager (665)

microsoft public word vba general (641)

microsoft public windows server general (632)

microsoft public windows server active directory (587)

microsoft public outlook installation (585)

microsoft public word newusers (563)

microsoft public publisher (518)

microsoft public excel newusers (509)

microsoft public excel charting (503)

microsoft public word pagelayout (498)

microsoft public dotnet languages vb (469)

microsoft public vb general discussion (460)

microsoft public development device drivers (446)

microsoft public word application errors (435)

microsoft public office setup (430)

microsoft public sharepoint general (427)

microsoft public access gettingstarted (411)

microsoft public windowsce platbuilder (410)

microsoft public windows powershell (407)

microsoft public onenote (396)

microsoft public frontpage client (393)

microsoft public sqlserver reportingsvcs (388)

microsoft public outlookexpress general (369)

microsoft public access tablesdbdesign (353)

microsoft public pos (353)

microsoft public vc mfc (347)

microsoft public outlook program vba (341)

microsoft public windows live messenger (325)

microsoft public money (310)

microsoft public windowsxp hardware (300)

microsoft public windows 64bit general (296)

microsoft public scripting vbscript (290)

microsoft public windowsxp basics (240)

microsoft public windows mediacenter (230)

microsoft public dotnet general (226)

microsoft public mac office (198)

microsoft public nntp test (195)

microsoft public windows inetexplorer ie6 outlookexpress (192)

microsoft public windows vista music pictures video (154)

microsoft public win98 gen discussion (154)

microsoft public sharepoint setup and administration (142)

microsoft public windows vista hardware devices (130)

microsoft public dotnet framework (105)

microsoft public windows vista performance maintenance (97)

microsoft public visio (89)

microsoft public access 3rdpartyusrgrp (73)

microsoft public dotnet xml (59)

microsoft public access conversion (56)

microsoft public pt windowsxp (36)

microsoft public windows live photogallery (32)

microsoft public access developers toolkitode (32)

microsoft public dotnet faqs (15)

microsoft public dotnet framework aspnet datagridcontrol (10)


microsoft.public.word.vba.general Post New
Items(640) /7 Next >> Last >|
Subject Posted Replies From
How to incorporate page counts in TOC

I need to find out how to incorporate each document’s total page count into the Table of Contents instead of the current page number. In my case, we have 20-60 separate document files that need a single TOC that states the total number of pages for each file. Example: Section No. of Pages 100 3 200 2 300 10

3/11/2010 11:20:01 PM 1 =?Utf-8?B?S3J5c3RhbA==?= <Krys...@discussions.microsoft.com>



Creating a custom table...

A couple of issues regarding table creation. I want to insert a set of tables in a document header, but so they appear in the middle (vertically) of the page concerned. I want them in the header so the user cannot inadvertantly modify the table contents directly without actively entering into the header: 1. I have a dialog where a user can specify the number of rows that must be in a table. For example if they enter 4 then the table must be created and inserted with 4 rows and 2 columns. There are always 2 columns - how do I achieve the table creation and insertion at a specific

3/11/2010 8:01:01 PM 1 =?Utf-8?B?Um9iaW4=?= <Ro...@discussions.microsoft.com>
How to batch create cross references (for glossary, bibliography)

Hi Word Gurus, I am in the process of writing a (long) thesis. It contains about 250 literature citations. These are inserted using Endnote X3. That software is OK, but what it can not do, is automatically link the literature citations to the bibliography section. However, I'd like to do that. In the text, there are different citations that look like (Lindenmayer, 2007) or (Cook et al., 1986) I would like to link every occurrence of these to the bibliography, so that either 1. a cross reference directly to the related entry in the bibliography is created or 2. at leas

3/11/2010 7:08:01 PM 0 =?Utf-8?B?TW9qbzE5ODA=?= <Mojo1...@discussions.microsoft.com>
Which field did I exit...

I am building a very complex form and need some assistance... In this form, I use sections to hide/show mulitple repeated sections within the form. Users click +/- buttons to add (unhide) or delete (clear all fields and hide) these sections. No problem. Works great. Within each section, use a scheme to differentiate my fields. Each section has ~40 fields. One of these is a drop-down field (not activeX) used to make a choice. Based on the choice, I want several fields to change. It's a form with rates, so I need different information if Fixed or Variable are chosen in the drop

3/11/2010 6:43:02 PM 1 =?Utf-8?B?amtpdHp5?= <jki...@discussions.microsoft.com>
Read excel file and read in a cell into a var in VBA

Using the VBA from excel, I want to write a code to open another excel file and access an individual cell in that excel file, then assign it to a variable declared in VBA. Is this do-able?

3/11/2010 5:11:01 PM 2 =?Utf-8?B?SmFtZXMgUw==?= <James ...@discussions.microsoft.com>
Check For Valid Object Reference

How do you check if a reference is still valid? For example, if at the time you need to use a another document reference, how can you check that it’s still valid? Dim sourceDocument as document Set sourceDocument = documents.add … If not sourceDocument is nothing then … Here, the sourceDocument may have been closed before the last call, but in checking the the reference, sourceDocument isn’t nothing (it’s still looks valid), isn’t null (not really used much in VBA anyhow), or empty (it’s been allocated at some point). Currently, I am forcing an error: On Error Resume Next

3/11/2010 3:28:01 PM 0 =?Utf-8?B?R2VvcmdlIExlZQ==?= <George...@discussions.microsoft.com>
Using Building Blocks, Content Controls and XMLMappings to generate multi-page template-generated sections in a Word Document

Dear Readers, I would like some of your insight and feedback regarding a document I am creating. Here is the scenario. The document is a package that describes a toy collection. There is supposed to be a section in the document which consists of a sequence of pages that repeat an identical one-page template for each item in the collection. I have an XML document (Excel Table mapped export) which describes each item in the collection, and I would like to programmatically generate these pages of the document from the content in the XML file and the presentation in the template. S

3/11/2010 1:16:49 AM 0 Dmitry <dminkov...@gmail.com>
Remapping Keys in Word 2007

I want to reassign the ">" key to "." and the "<" key to "," in Word 2007. I know how to assign keys to macros, but how do I reassign the key to its lower case equivalent (or another letter)?

3/11/2010 12:01:23 AM 1 "LA Lawyer" <hk...@kapplaw.com>
Map Title, continued

When building a book, I have the following hierachies: -Chapter Title -Map Title -Block Tile I have built the different styles for Map Title (e.g. Map Title for a title used on the same page of each chapter and Map Title New for a subsequent title within the chapter starting on a new page). For each Map Title lasts more than one page, I created a Map Title Continued style, so it won't call in the TOC. However, I have to manually select the Map Title Continued and Type the Map Title text (or Map Title New text). Is it possible to have that Map Title Continued to carry t

3/10/2010 10:31:02 PM 3 =?Utf-8?B?RHIuIExpIExp?= <DrL...@discussions.microsoft.com>
Insert Title Field

How to insert Title Field on a cover page? If I would like to have the Document Title automatically updated in each chapter of the document, do I need to insert the title field in each chapter? Thanks.

3/10/2010 10:19:13 PM 0 =?Utf-8?B?RHIuIExpIExp?= <DrL...@discussions.microsoft.com>
New ribbon appears twice

I have created a custom ribbon for our template in Word 2007. Everything on the ribbon works fine, so now I've started using it. Now I have encountered a very strange problem. I can open a new document based on the template and save it. Everything works fine in the document and the ribbon bar while I've got it open. But after I close it, then reopen it, suddenly that new ribbon appears twice and I can't use any of the buttons on the document, and eventually it just locks up. A co-worker here thought it was the Adobe COM add-in, so we eradicated that and restarted, but still

3/10/2010 7:58:01 PM 3 =?Utf-8?B?QXByaWw=?= <Ap...@discussions.microsoft.com>
CustomUI

Hello All, Is it possible to manipulate the pressed state of a toggle button on a CustomUI ribbon tab using Word Visual Basic in a document template? Many Thanks.

3/10/2010 5:46:02 PM 1 =?Utf-8?B?QXNobGV5ICdFbnRhbmlvJyBSdXNzZWxs?= <Ashley 'Entanio' Russ...@discussions.microsoft.com>
Word macro to select segment smaller than a whole sentence

Control+clicking on any part of a sentence selects the whole sentence, using a full mark as a delimiter. Is it possible to create a macro that would use a semicolon as segment delimiter? Thanks for any ideas Wtbx

3/10/2010 3:14:09 PM 9 wtbx <weet...@hotmail.com>
Unable to add table

Hello all, I am trying to add a table to a new word 2007 document i created through an excel macro. I wanted to add the data from the excel sheet to this table. After creating the document, i added some text through selction.TypeText("text") and added some paragraph marks through selection.TypeParagraph methods. I tried to add the table through the following code:- word.selection.EndKey mode:=wdStory, Extend:=wdMove Dim tble as Word.Table set tble = Word.Selection.Tables.add(word.range,2,8) On execution of the last line, all previously entered text is deleted from th

3/10/2010 1:45:01 PM 3 =?Utf-8?B?U2FueWEgSWJyYWhpbQ==?= <SanyaIbra...@discussions.microsoft.com>
sending emails from a word userform

Hi everybody, I have created a word userform (in word 2007) and I need to send the data from the userform to a list of employees using the outlook namelist (contact list). there are 2 possibilities to consider: 1. opening the contact list in a stand alone computer 2. opening the contact list with activex control (for a big organization). can someone tell me how to do that please?

3/10/2010 8:40:01 AM 1 =?Utf-8?B?aXJpcw==?= <i...@discussions.microsoft.com>
Add-InTemplates

Can you make Add-In Templates editable? I experience problems with my computer at work quite often and every time an IT person tries to solve the problem they invariably blame all the macros I have in my Normal.dot. So in order to appease them (although I don't think the macros I use have anything to do with the weird problems I have) I removed them and put them in their own .dot template. Even with doing this, I am still experiencing odd things like Closing and choosing Save and the document saves but doesn't close and the problem of not being able to generate a TOC w/o getti

3/10/2010 3:39:01 AM 3 =?Utf-8?B?amVyZW0=?= <je...@discussions.microsoft.com>
How to figure out if a key is pressed in a cell of a table or a cell of a table lost the focus

I've a table in Microsoft Word (Office 2003) with several rows and columns. Like in Excel I'd like to color the cells according to their values (called conditional formating in Microsoft Excel). If the value is less than zero the cell gets colored red, is it zero the cell gets colored yellow and is it greater than zero the cell gets colored green. My problem with VBA is how to figure out if a cell got edited. In Visual Basic I have events like LostFocus or KeyDown. But I'm missing this events in VBA. Any help is very appreciated. Regards Stefan

3/10/2010 12:30:54 AM 4 Stefan Mueller <seekw...@yahoo.com>
How to hide or disable toolbars and ribbon in word with vba or vb6

I am trying to hide or disable the ribbon and toolbars in Word 2007, within a VB6 program, but have been unable to get it to work. I am using early binding so that I can see the Word objects and methods, but have been unable to find a combination that will work on my files. Have tried Dim wrd As Word.Application Dim obar As Office.CommandBar For Each obar In wrd.CommandBars obar.Enabled = False obar.visible = False Next I assume there is something I am missing here. What would be the best way to do this? Thanks, Norm

3/9/2010 11:55:28 PM 0 "Norm" <Nor...@spoof.com>
Form Field Calculations not calculating the first time through

I am working on an employee appraisal form that has for different sections for evaluating and recording scores. Each section averages these scores and records the average at the bottom of the section and also on a summary page. On the summary page I have another field that calcuates a "Grand Average" for a total appraisal score. I have saved this document as a template. When I open the document and populate it with scores the Grand Average total is not correct; however, when I simply tab through the entire document - without making ANY changes - by the time I get to the summar

3/9/2010 9:46:01 PM 6 =?Utf-8?B?VGhlUm91bmRQZW4=?= <TheRound...@discussions.microsoft.com>
Preventing users from entering the header

I have the following code from the wonderful Bill Coan over at the MVPs site. It's supposed to prevent users from editing the headers in the document. I've got this code in the template. Problem is, it's set up for Word 97 but I'm using 2007. It keeps crashing no the wdSeekMainDocument line toward the end. I saw a post that said I should change the ThisDocument to ActiveDocument, and I tried that, but that just made the code disappear altogether when I created a document from the template this is in. Any ideas? Option Explicit ''reserve memory for an application variable P

3/9/2010 7:10:01 PM 2 =?Utf-8?B?QXByaWw=?= <Ap...@discussions.microsoft.com>
macro to run automatically when a field is updated

I have two form fields on an employee appraisal form. One calculates a grand average score from four different scoring areas on the form. The second field evaluates this score (using a macro) to determine the increase percentage based on the grand score. This macro is assigned to the field to run on entry. My problem is that if an evaluator goes back through the form and changes a score, they must click in this percentage field to get it to update to the correct value. My question is: how could I make this field update automatically anytime a change is made anywhere on t

3/9/2010 6:58:03 PM 1 =?Utf-8?B?VGhlUm91bmRQZW4=?= <TheRound...@discussions.microsoft.com>
Option Button Question

I have a fax cover sheet which says the original will/will not follow after the fax. I have set up option buttons for the Will and for the Will Not, as well as bookmarks to insert an X depending on the option the user selects. How do I code the buttons to insert an X into the bookmark from the option button they select? And thanks very much for your help, as always.

3/9/2010 4:40:02 PM 4 =?Utf-8?B?SmVhbm5lSm8=?= <Jeann...@discussions.microsoft.com>
Retrieving table style information

Dear Experts: I got a document with a lot of tables where I applied user-defined table styles (name convention: all beginning with "tbl_style_ ") to about 50% of the tables: Is it possible thru a macro to retrieve the table style for each table: Example: Table 3: tbl_style_blue Table 4: tbl_style_blue Table 5: tbl_style_red Table 7: tbl_style_grey Table 1, 2, 6: no user-defined table style applied Help is much appreciated. Thank you very much in advance. Regards, Andreas

3/9/2010 3:47:22 PM 4 andreas <andreas.her...@gmx.de>
Random AutoText entries

I'm creating a Word 2007 template for our procedures group. One of the fields is an AutoText field. I've entered the three options I want and those work great. But there are three other options already in the list that I can't seem to get rid of. The three options are the user initials, user ID, and company ID. The organizer tells me they're from the Normal template. Also, I just discovered if I have a non-template Word document open, the entire Quick Parts list shows up, and I definitely don't want my users accidentally clicking on any of those. Is there some way I can get t

3/9/2010 3:33:01 PM 0 =?Utf-8?B?QXByaWw=?= <Ap...@discussions.microsoft.com>
calculate fraction to decimal in macro

I need to change seconds into a fraction of a minute while running a macro for a report. For example, 3 minutes and 17 seconds should end up as 3.3 minutes (rounded off to the nearest 1/10 of a second. I want to be able to type in the minutes and seconds and change to the above format. Thanks for any help on this.

3/9/2010 6:13:02 AM 10 =?Utf-8?B?TWFyaw==?= <M...@discussions.microsoft.com>
Calculate form fields...

I have a form with several tables and fields within the tables. I've added buttons to expand/contract the table, enabling users to only see those rows they'll use. This keeps clutter off the page and makes the form more dynamic. I have no issues with this function; it's great! Let's call them Rows 2 through 14 My problem arises when the user clicks the minus button. To prevent data from being stored when it shouldn't, the fields in the deleted row are first cleared, then hidden, then disabled. This prevents tabbers from tabbing through hidden fields. So far so good. The p

3/9/2010 12:19:02 AM 2 =?Utf-8?B?amtpdHp5?= <jki...@discussions.microsoft.com>
Update all docvariables in all active documents

Hi, Can anyone tell me how to use VBA to update all docvariable fields in all active documents? I know how to update a single document, but I'm having trouble cycling through all active documents. Thank you, Rob

3/8/2010 10:15:44 PM 3 Rob M <rjm...@gmail.com>
Replace text in field code

I have some REF fields that point to bookmarks for document ranges that are deleted in my VBA code. I want the REF field to point to a new bookmark. I want to use something like the following myRange.fields("REF OQTempRHMappingSection \r \h").code = replace(myRange.fields("REF OQTempRHMappingSection \r \h").code, "TempRH", "TempOnly") Of course, this does not work or I wouldn't be writing this question. Is there a way to accomplish what I'm trying to do? If I reveal codes in the document, I can perform the edit manually. I think I should therefore be able to do it in VBA as

3/8/2010 9:02:02 PM 2 =?Utf-8?B?UGV0ZXI=?= <Pe...@discussions.microsoft.com>
normal.dot file and macros

I have used Microsoft WORD 2000 for many years and had no problem with Macros. Now I installed WORD 2003 on a different computer and cannot find the normal.dot file even with changing folder's settings to view hidden files. There is nothing visible in templates under Microsoft unless I create one, and normal.dot does not come up with an file explorer search. I can create macros in normal.dot in the WORD process I normally used in Word 2000, and they apply to all open files. However, when I closed word and re-open, I have no working Macros. Therefore, I need help on view

3/8/2010 7:16:01 PM 2 =?Utf-8?B?U2Vsd3lu?= <Sel...@discussions.microsoft.com>
place cursor in a specified text box in a Word form

Hello, I have a Word form developed in vba and when a specific textbox is empty a message box appears to tell the user to enter some data before they can proceed. When they click ok to continue the cursor places itself in textbox4 on the form but I want it to be in the box they have left empty (in this case textbox5). I have used the SetFocus method but that doesn't seem to do anything, it still ends up in textbox4. Any ideas anyone? Thanks.

3/8/2010 2:36:01 PM 1 macroapa <macro...@hotmail.co.uk>
WORD VBA - Obtain windows login name

Hi I have a document opened from a centrally located template which I want to automatically save to the users Sharepoint folder. The path for Sharepoint is: http://sharepoint/personal/LOGINNAME/..... Any ideas as to how to obtain the users windows login name? Many thanks -- Richard

3/8/2010 9:01:01 AM 6 =?Utf-8?B?UmljaGFyZA==?= <Rich...@discussions.microsoft.com>
Trouble with FileDialog(msoFileDialogSaveAs)

Hi, I hope someone can help me. I close a document with the code below. It worked fine on my desktop. It worked fine on other desktops but not all. They would get the error message "Compile error ... can't find project or library" at msoFileDialogSaveAs and I am unable to figure out why. I began experimenting with the document on my desktop and now it won't run on mine either and I don't know what I did to change it. Does anyone have any suggestions as to what I've missed? With Application.FileDialog(msoFileDialogSaveAs) .InitialFileName = "New" & strD

3/7/2010 11:56:01 PM 16 =?Utf-8?B?RWlsZWVu?= <Eil...@discussions.microsoft.com>
VBE Help: Size of code pane

I'm not sure I have the terminology correct so bear with me please. Is there a way to set a default size for all code panes? By code panes, I mean the "windows" that open in the VBE when an existing module or form is double clicked, or when Insert Form or Insert Module is clicked. The reason I'm asking is that I frequently find that the window is so wide that I can't see the x to close a userform or module. I frequently have to click and drag the whole window to the left in order to bring the x into view. These windows open so wide that there are acres of unused white spac

3/6/2010 11:41:01 PM 5 =?Utf-8?B?QWlsaXNo?= <Ail...@discussions.microsoft.com>
Can you teach an 'old dog' new tricks? (Writing Macros)

I'm certainly giving my age away when I say that I started out with Wordstar for CPM. I then moved on to MS Word, in which I found it very easy to write macros. Working with DOS was an excellent prep for writing macros. In fact, after creating a library of macros, you could then write batch files to run them much like invoking a procedure in a computer program. My programming skills are as ancient as I myself feel in today's 'pedal-to-the-metal' technology. In college, I learned the following programming languages: Pascal, FORTRAN, COBOL, BASIC, C, C++, and VAX/PDP-11 Assembly la

3/6/2010 12:50:40 AM 1 =?Utf-8?B?U3RvbmUgQWdlIFRydWNrZXI=?= <Stone Age Truc...@discussions.microsoft.com>
Create DocumentPropertiesPanel in Word 2003

please i want to do a DocumentPropertiesPanel in Word 2003 that simulate the panel at Word 2007 [ word --> prepare --> properties ] any ideas ????

3/5/2010 5:45:01 PM 3 =?Utf-8?B?SXNsYW1HYW1hbA==?= <IslamGa...@discussions.microsoft.com>
Macro Recording Error

Word 2003 (11.8313.8221) SP3 I have run into a (apparently) random, but recurring error while recording macros: The macro records without a Sub line, displays fine in the editor, but crashes Word when I click inside the editor window. Any thoughts? Error Info: AppName: winword.exe AppVer: 11.0.8313.0 AppStamp:4a793d83 ModName: vbe6.dll ModVer: 6.5.10.40 ModStamp:48a4b5d6 fDebug: 0 Offset: 00075b00

3/5/2010 5:34:12 PM 0 Amish <reitanos...@yahoo.com>
macro run error!

I need change the change all the text paragrahp setting as follow: “Paragraph-Indents and Spacing-Spacing-Before:0.5line, line sapcing:At least At:0pt" I make this change and record a macro, and then select the rest of the test, run the marco, but it shows error like this: error in office 2007:" Run-time error'5149': The measurement must be between 0.7 pt and 1584 pt" error in office 2003 : "Run-time error'5362': The measurement must be " how could I fix this problem? I need to set the number as 0.5 instead of 0.7

3/5/2010 3:25:01 PM 5 =?Utf-8?B?Zm9ycmVzdA==?= <forr...@discussions.microsoft.com>
Macro can't run!

I recorded a macro as follows: Sub Macro1() With Selection.ParagraphFormat .LeftIndent = CentimetersToPoints(0) .RightIndent = CentimetersToPoints(0) .SpaceBefore = 2.5 .SpaceBeforeAuto = False .SpaceAfter = 0 .SpaceAfterAuto = False .LineSpacingRule = wdLineSpaceAtLeast .LineSpacing = 0 .Alignment = wdAlignParagraphJustify .WidowControl = False .KeepWithNext = False .KeepTogether = False .PageBreakBefore = False .NoLineNumber = False .Hyphenation = Tru

3/5/2010 2:17:01 PM 0 =?Utf-8?B?RGFteQ==?= <D...@discussions.microsoft.com>
word interfacing with sql server report service

Since I am new to sql server report service 2008, I have the following questions to ask: 1. I have alot of reports that need to have one to 10 paragraphs written prior to when the table is displayed. Thus, I was thinking there would be toolbox items like a 'word' document that you can drop onto a sql server report 2008. However the closest thing I see is a texbox. Thus, is there any feature I could use that will display the paragraphs prior to when the repiort is generated? (The closest item is looks I can use is a textbox. Does the textbox have 'word' document formatting f

3/5/2010 4:55:01 AM 1 =?Utf-8?B?V2VuZHkgRWxpemFiZXRo?= <WendyElizab...@discussions.microsoft.com>
Document Properties & Saving a File

Word 2003/Windows Vista It's my understanding that, when saving a file for the first time, Word looks at the Title document property and uses this to initialise the filename. I also understand (from reading the help topic "Troubleshoot file properties") that if the Title property is blank, Word then "extracts" a pseudo-value for the Title property from the first line of the document and uses this to initialise the filename. This extracted value isn't written into the Title property that's displayed on the Summary tab of the Document Properties dialog box, but it *is* displayed

3/5/2010 3:43:33 AM 2 "Gordon Bentley-Mix" <gor...@NOSPAM.exmvps.org>
OT - Dynamic Menu C# VSTO 2010 - anyone suggest developer small project

I have base code (not sure it is workable) but should be for dynamic menu in Word. Thank you for any interest. Janine

3/4/2010 11:53:41 PM 0 "Janine" <jan...@ribbonspace.com>
Disable remaining formfields in the same row of a table.

Based upon a checkbox value in the form fields I am trying to disable or enable the remaining formfields in the table row. I believe the following code should work. but I am gettting a run-time error '5991' on the for each statement that says 'I cannot access individual rows in this collection because the table has vertically merged cells' Sub EnableActionFields() ' Enable or Disable the Actions formfields Dim ffname As String Dim ActField As FormField ffname = Selection.FormFields(1).Name For Each ActField In ActiveDocument.FormFields(ffname).Range.Rows(1)

3/4/2010 10:13:02 PM 6 =?Utf-8?B?U3R1YXJ0IFBldGVycw==?= <StuartPet...@discussions.microsoft.com>
Date incrimintation

Hello, I want to place a date in header or run a macro to place the date on ever page like this: Thursday, 3.4.2010 and on second page, Friday, 3.5.2010 and on third page Saturday, 3.06.2010 and so on Have anybody an idea how to do it? Thank you!

3/4/2010 9:53:03 PM 2 =?Utf-8?B?RGFtaWFu?= <Dam...@discussions.microsoft.com>
Need an HTML replacement Macro

I need to perform a find/replace in a Word doc so that text encased in a specific html tag is replaced with a style mathing that tag. For instance, this: <em>some text here</em> <em>different text in this one</em> should be replaced with this: some text here <--(image that this is bold/italics) different text in this one <-- (same comment) I'm having trouble figuring this one out. Thanks in advance for any guidance.

3/4/2010 8:24:34 PM 3 rwagner <wagner....@gmail.com>
how can I make yes no option button required?

I have a user form that prompts a user to click yes no option buttons. This form fills out a word document replacing the un-checkedboxes with a windings character that looks like a checked box. The user form has several frames with 1 set of yes no option buttons in each frame for each question. The form works but, I would like to make the user required to answer yes or no to each question. I would really appreciate any help on this.. See my code below. Dim OBYes1 As Bookmark Dim OBNo1 As Bookmark 'App Option Button 1 Yes If UserQues1.OBYes1 = True Then Selection.Go

3/4/2010 6:28:01 PM 2 =?Utf-8?B?ZGVlbnNs?= <dee...@discussions.microsoft.com>
Calculate Checkboxes to average total

I downloaded the Microsoft Word template "Employee performance review form (short)" which has checkboxes that rates the employee performance. Can someone assist in placing a value to each checkbox, then a overall rating that averages the numbers? Example the first category has ratings of 1 = Unsatisfactory and the first row is Job Knowledge and checkbox is clicked 1 = Unsatisfactory. The second row is Work Quality and the checkbox is clicked 4 = Exceeds Expectations. After all rows are rated, then an average would calculate in a box. I am currently using Word 2003.

3/4/2010 4:03:02 PM 2 =?Utf-8?B?U3VlIExlZQ==?= <Sue ...@discussions.microsoft.com>
VBA for sending mail and saving it in a database

HI All, I would really appreciate if any once can assist me: My requirement is: A word document(which is actually a form contains name, country, age, phone number) should have a submit button that when clicked should be attached in a new mail in outlook 2007. This document should also contain an button which when clicked should stored all the information in a database ( preferred MS access) by extracting the content from the document. Your help is highly appreciated. Thanks, puntertips

3/4/2010 3:20:54 PM 2 puntertips <suresh.s...@gmail.com>
Worked in 2003, not in 2007

I have a macro that was in my template which started life as a Word 2003 document. I've created a new template in Word 2007 and transferred all the code into the new document. Everything seems to work except one macro. This is supposed to grab the title of a given attachment, copy it into a new page of the attachment, and include the title. It always crashes on the Selection.Copy line. The only thing I changed was making the word "Attachment" all caps. But even if I change that back and use nothing but the original code, it crashes on that same line. Any ideas? Sub AttachAd

3/4/2010 2:10:02 PM 6 =?Utf-8?B?QXByaWw=?= <Ap...@discussions.microsoft.com>
Counting number of words in a sentence and highlighting or commenting

Hi, I found some old code, from Helmut of Bavaria I believe, that is supposed to find long sentences in a document: Sub test002() Dim rDcm As Range ' the documents main story range Dim oWrd As Object ' a word Dim oSnt As Object ' a sentence Dim oPrg As Paragraph ' a paragraph Dim lWrd As Long ' a counter for words Dim lSnt As Long ' a counter for sentences Dim lPrg As Long ' a counter for paragraphs Set rDcm = ActiveDocument.Range For Each oPrg In rDcm.Paragraphs lPrg = lPrg + 1 lSnt = 0 For Each oSnt In oPrg.Range.Sentences

3/4/2010 1:48:40 PM 7 BHW <brucehu...@gmail.com>
Macro to insert a text box in Word 2007

Does anyone know how I can insert a particular type of text box ("Simple Text Box")into a Word 2007 document using a macro (so that I can add it as a button to the Quick Access Toolbar)? It's easy enough to add a button to the Quick Access Toolbar to open up the Text Box Gallery (by using one of the pre-defined customise commands), but I just want to be able to open the "Simple Text Box" with one click, rather than having to select it from the Text Box Gallery every time. Many thanks.

3/4/2010 12:51:01 PM 9 =?Utf-8?B?R2VvZmYgQnVkZA==?= <GeoffB...@discussions.microsoft.com>
Direct edit of Building Blocks

I know the building blocks saved to MS Word are saved to the file at C:\Documents and Settings\<<username>>\Application Data\Microsoft\Document Building Blocks\1033\Building Blocks.dotx (or Vista C:/Users/<<username>>/AppData/Roaming/Microsoft/Document Building Block). Now I would like to edit the building blocks directly, not their properties, but the building blocks themselves. I would liek to edti them directly, because whenever i need to update one of my building blocks i currently have to delete the old building block entry, then create the updated building block somewhe

3/4/2010 10:25:01 AM 1 =?Utf-8?B?Q2Vs?= <...@discussions.microsoft.com>
continious page nos while inserting pages from 2nd doc to 1st doc

i have 3 pages template in 2nd page from macro i am inserting file doc2 where bookmarks are there for i=0 to 2 Selection.GoTo What:=wdGoToSection, Which:=wdGoToLast Selection.MoveUp Unit:=wdLine, Count:=1 Selection.InsertBreak Type:=wdSectionBreakContinuous Selection.InsertFile Filename:=mstrTemplatePath, Range:="mtaLoop", ConfirmConversions:=False, Link:=False, Attachment:=False For Each frmfld In ActiveDocument.FormFields Select Case frmfld.Name Case "mta070" 'ID

3/4/2010 9:29:02 AM 0 =?Utf-8?B?SGVtYSBOZWVsYWdpcmk=?= <HemaNeelag...@discussions.microsoft.com>
continious page nos while inserting pages from 2nd doc to 1st doc

i have 3 pages template in 2nd page from macro i am inserting file doc2 where bookmarks are there for i=0 to 2 Selection.GoTo What:=wdGoToSection, Which:=wdGoToLast Selection.MoveUp Unit:=wdLine, Count:=1 Selection.InsertBreak Type:=wdSectionBreakContinuous Selection.InsertFile Filename:=mstrTemplatePath, Range:="mtaLoop", ConfirmConversions:=False, Link:=False, Attachment:=False For Each frmfld In ActiveDocument.FormFields Select Case frmfld.Name Case "mta070" 'ID

3/4/2010 9:07:01 AM 0 =?Utf-8?B?SGVtYSBOZWVsYWdpcmk=?= <Hema Neelag...@discussions.microsoft.com>
Need help for macro to add name to several places in a document

I need to run a macro that brings up a dialog box prompting me for a person's name then types the name in 3 places in the document (I usually put an asterisk * where I want the names to be placed in my effort to use find and replace). I tried using find and replace but that does not work in this macro as I can't get it to prompt me for the new name. I assume that I should use a variable but I am not sure how to get it to prompt me for the name then place the name in my document. Thanks for any help on this problem, Mark

3/4/2010 2:57:02 AM 31 =?Utf-8?B?TWFyaw==?= <M...@discussions.microsoft.com>
Bringing different windows to the front

Hello, I'm working with two different documents that I switch back and forth between quite often in my macro. I can activate whichever document I want to be working in. However, after activating one of the two documents I would like to be able to see the document. In essence, bringing one window to the top when it isn't on top. How can this be done in a 2007 Word macro? Thank you. -- G Teachman Soil Scientist

3/3/2010 9:17:01 PM 0 =?Utf-8?B?RyBUZWFjaG1hbg==?= <GTeach...@discussions.microsoft.com>
tiLinking text in WORD

I would like to update a title and have it auto-update else where in my WORD document. IE: Update the title of document and have the TOC title update automatically

3/3/2010 9:00:03 PM 1 =?Utf-8?B?am9obmNpZ25h?= <johnci...@discussions.microsoft.com>
Coding Italics / Bolding into a String

Word 2007: There are times that I would much rather insert a code to toggle bolding (or italics) in a lengthy string of text rather than having to break up the string to do this. Can this be done? How?

3/3/2010 7:19:44 PM 2 "LA Lawyer" <hk...@kapplaw.com>
Extract date only from Windows serial date

I want to compare a user-specified date, such as 3/3/2010, with the date associated with a tracked change. The problem is ActiveDocument.Revisions(1).Date also returns the time of day. I have come up completely empty on the means of referencing the date portion only of the tracked change. Sure hope someone can educate me, as I'm sure I've got to be missing something incredibly obvious.

3/3/2010 7:12:14 PM 2 dedawson <dedawson4...@gmail.com>
Can't exit design mode because Control <ControlName> can not be cr

Hi all, Can't exit design mode because Control <ControlName> can not be created. I am invariably running into the above error message when messing about with my form which contains ActiveX controls (just a few checkboxes & DTPickers). Could anyone shed any light as to why this might be occuring, of course I know that it's my actions (cutting and pasting controls without care) that might've caused it, however I would love to know what is actually going wrong and how to fix it, my googling has born no fruit! Please and thank you!

3/3/2010 4:34:01 PM 0 =?Utf-8?B?c3B1bmt5bXVmZm1vbmtleQ==?= <spunkymuffmon...@discussions.microsoft.com>
Show hidden text

I have a form with form fields. I'm trying to add functionality that will make visible hidden text by saying if "Add Objective" is selected in a dropdown, select bookmark "ShowObj3" and unhide that text. I know a macro will probably be more efficient, but can this also be accomplished using field codes. I'm not too savvy with macros so please make it as simple as possible. Thank you.

3/3/2010 4:26:01 PM 1 =?Utf-8?B?TWlzc0JhcnQ=?= <MissB...@discussions.microsoft.com>
Carriage Return Symbol Text Field Word Form VBA Problem inside Tab

I am trying to insert some text into a protected Word text field with carriage returns for new lines via VBA code. For example, I would like to enter something like the following into a text field called Text1: Test Line 1 Test Line 2 Test Line 3 So my code is: ActiveDocument.FormFields("Text1").Result = "Test Line 1" & Chr(13) & "Test Line 2" & Chr(13) & "Test Line 3" The text field is located inside of a table cell. The problem is that it is inserting the box symbol for chr(13) instead of a new line. So it looks like this: Test Line 1[]Test Line 2[]Test Line 3. I've

3/3/2010 3:35:01 PM 1 =?Utf-8?B?bWF0Y2hvcm5v?= <matcho...@discussions.microsoft.com>
Powerpoint from Word

Hi, Is there a way to open an existing Powerpoint presentation and work with it from within Word VBA? -- Thanks for your help. Karen53

3/3/2010 3:13:01 PM 1 =?Utf-8?B?S2FyZW41Mw==?= <Kare...@discussions.microsoft.com>
Auto generate an index from a style

I am editing a songbook, and I use AutoNum to number each song. Between editions I need add and remove songs, and I want to limit the bookeeping to a minimum. I want to create an index with the song number and title refering to the page its on. However, when I make the XE entry to include the AutoNum field, the AutoNum always turn into "1" in the text. I am completely new to VB, but I figured it would be possible to make a Sub to walk through the doc, find all instanses of my "Song Title" style, add a number and the proper index entry. Can someone help me out here, or poi

3/3/2010 2:08:01 PM 1 =?Utf-8?B?amFsbGJlcmc=?= <jallb...@discussions.microsoft.com>
Help me to create an Armenian Spell Checker

I'm a member of Arak-29 Foundation team in Armenia working on various Armenian language programs (www.arak29.am). Our team-leader is Tom Samuelian, a lawyer and linguist. For some time, we have been working on Armenian orthography and dictionaries. There is no spell-checker for Eastern Armenian in traditional (Classical) orthography. For this reason, we have prepared in hunspell format (1) modified wordlist of over 60,000 base forms and (2) affix file with all declined and conjugated forms, (3) readme file. We wish to make this available under a GPL license as a

3/3/2010 8:48:01 AM 1 =?Utf-8?B?SGFpayBIYWtvcGlhbg==?= <Haik Hakop...@discussions.microsoft.com>
Automating Templates - Another Question

I am working on creating templates for state, federal and bankruptcy court. I have bookmarks set for the district, division, etc. of the pleading forms, but would like to default to the standard information we use most of the time but allow users to change that default text, if and when necessary, when creating the documents from the templates. My question is: can I put "default" information in these bookmarks, such as "Thirteenth" for the district; Montana for the Division - that sort of thing? Thanks very much for your help, in advance. JeanneJo.

3/2/2010 11:43:01 PM 5 =?Utf-8?B?SmVhbm5lSm8=?= <Jeann...@discussions.microsoft.com>
Is it possible store Word 2007 Macros in Normal.doc

I need to store macros with Word nott he Document in order to allow them to be drive indepenent. Is it possible store Word 2007 Macros in Normal.doc

3/2/2010 9:57:01 PM 1 =?Utf-8?B?Um9ubmllIFJ1YmJlcmxlZ3M=?= <Ronnie Rubberl...@discussions.microsoft.com>
Erase Statement

I have been toying with the Erase statement. The VBA Help states that the Erase statement sets each element of a fixed-string array to 0. From the testing that I have done shown below, it appears that it sets each element of a fixed-string array to a zero-length string. Am I misunderstanding "fixed-string" array? Is this the expected behaviour and the Help discussion is wrong, or is this a bug? Sub EraseStatement() Dim i As Long 'Declare array variables. Dim NumArray(0 To 3) As Integer 'Integer array. Dim StrVarArray(0 To 3) As String 'Variable-string array. Dim StrFixArr

3/2/2010 6:14:02 PM 4 "Greg Maxey" <gma...@mIKEvICTORpAPAsIERRA.oSCARrOMEOgOLF>
Determine Length Of Mail Merge Field

Hi, I have a mail merge document that gets its information from an excel file. Is there a function in word that will give me the length of the one of the fields, i.e. mm_name? If not, is there a way to treat a phone number (555) 555-1212 as one word so the (555) is not on one line and 555-1212 on another. The user won't delete the space between after the ) or will the user start the phone number on a separate line. I am currently adding spaces before the phone number and if the mm_name is under 12 characters the letter looks okay, however if it is over 12 characters you som

3/1/2010 9:29:01 PM 3 =?Utf-8?B?TWFyazExMTA=?= <Mark1...@discussions.microsoft.com>
Capture user selection of font

If I put a font combo box on a Ribbonbar is there a way for me to capture the user's font choice? I need to capture that choice and use it in a macro.

3/1/2010 8:34:01 PM 2 =?Utf-8?B?ZHBsYXV0?= <dpl...@discussions.microsoft.com>
Font formatting in VBE

I have some docvariables tied to docvariable fields of which some need to be BOLD fonts but others tied to the same field do not. If I bold the field in the document, then all the docvariables are bold which is not my intent. How can i selectively bold some but not all of the docvariables? I've tried to highlight the specific variable and "control-B" but it doesn't seem to have any affect. tx

3/1/2010 2:36:01 PM 4 =?Utf-8?B?RG91ZyBH?= <Do...@discussions.microsoft.com>
VBA Macro: Word 2003 (FormFields)

Hi, I have a question on how to capture a hyperlink that is inserted behind a checked FormField (type Checkbox). The idea is to create some sort of index page with checkboxes, which will summarize a number of hyperlinks (which point towards several files on the company network). A button will print out all of the CHECKED checkboxes. I'm not able to achieve this. This is my code so far: Private Sub PrintButton_Click() For x = 1 To ActiveDocument.FormFields.Count If ActiveDocument.FormFields(x).Type = wdFieldFormCheckBox Then If ActiveDocument.F

3/1/2010 9:58:01 AM 7 =?Utf-8?B?RGltaXRyaSBCYWNrYWVydA==?= <Dimitri Backa...@discussions.microsoft.com>
after input, IF THEN to compare 2 #s & select answer fm a table

Using Word 2003, I would like to create a cell in a table. I want the user to enter a number in the cell. I want word to reference another table and find the cell or row where that number fits in. Example: I have a table with four cells. Cell A1 has 1-10 in it. Cell A2 has 11-20 in it. Cell B1 has 'YES' in it, and cell B2 has 'NO' in it. Then, I have another table or possibly, I add a row below the first table. It has three cells. In cell A1 I have text reading: Enter a number between 1 and 20. Cell B1 is where the number will be entered. Cell C1 is where the answer

3/1/2010 3:14:01 AM 1 =?Utf-8?B?RGFu?= <...@discussions.microsoft.com>
Preserve the initial scope of a selection on a search operation and re-use it later

Dear Experts: For some specific reasons I am using the Selection Object for a search operation. below macro searches for two or more consecutive tab stops. The trouble is, if an occurrence of two consecutive tab stops is found the initial selection is reduced to the length of the first occurrence. Is it possible to preserve the initial selection and re-activate it after the first occurrence of two or more consecutive tab stops? Help is much appreciated. Thank you very much in advance. Regards, Andreas Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatt

2/28/2010 11:06:31 PM 2 andreas <andreas.her...@gmx.de>
List of fonts used in a Word doc -- the easy way

The VBA scripts that I have found all implement a character-by-character scan throu= gh the document, which can take a long time in later versions of Word. You can blame Wor= d's "formatting" feature for the slowdown. There=E2=80=99s a faster way: Save the document in .rtf format, then open the .rtf fi= le in a text editor such as notepad.exe. The fonts are listed in a font table ( {\fonttb= l ) located at the very beginning of the file. Each font entry looks something like thi= s: = {\f0\froman\fprq2\fcharset0 Times New Roman;} Any entries with a character set other than \fc

2/28/2010 4:03:14 PM 1 "Harry Hondalf"<mald_guy...@yahoo.co.in>
Combine Multiple Documents

I send a wors document template with a set number of subject headings to several reviewers, and each reviewer returns the document with their comments on the topic added under each subject heading. I need to combine a dozen or so of these documents from various users into one final document. I have been using the compare and combine option in Word 2007 but I am looking to automate this procedure. I need to write a macro that will automate this. Any hints or suggestions would be greatly appreciated.

2/28/2010 11:47:01 AM 0 =?Utf-8?B?bXljYnRtZW1v?= <mycbtm...@discussions.microsoft.com>
FilePrint Intercept 2010 - is it obsolete?

Hi, Is Ctrl P obsolete in 2010 as it is the old FilePrint screen that was intercepted? Ctrl P moves to Print and Preview screen (now one dialogue) (same as Ctrl F2). Sub FilePrint() intercepts old vba Print Screen - Is Ctrl P therefore obsolete in 2010 because FilePrint screen is for previous versions? All one can do in Print and Print Preview is press PRINT button there is no OK button. So how does one automate the PRINT button execution for old FilePrint() intercept macros when using Ctrl P to print? 'ActiveDocument.PrintOut Background:=False Can someone please c

2/28/2010 2:40:49 AM 2 "Janine" <jan...@ribbonspace.com>
send and close

Word 2003 Hi , When you send a Word doc as an e-mail, there is a button for "Send a Copy". How can I get Word to close automatically after I click that button. Do I have to do it via code or is there another button that I can put in the tool bar. Thanks, Joel

2/26/2010 4:23:29 PM 0 "Joel Allen" <joelallen...@hotmail.com>
Fill in fields with parameters values from macro?!

Hello, I have three letters that I need to send out on a regular basis. I want to have an Office application (Excel) call the word document and fill in the Company name and address. I need to have a Word VBA macro that can receive parameters and then substitute them in a document. I know Excel VBA very well, but not sure how to do this in Word. Question ====== How do you write a Word VBA Macro that can receive parameters and then subtitute fields in a document with the parameter values? For example: (Word VBA) Sub ChangeAddress(byRef CompanyName as string, Address

2/26/2010 4:14:01 PM 1 =?Utf-8?B?V2VidGVjaGll?= <Webtec...@discussions.microsoft.com>
Repeating (or Looping?) an Action with VBA in Word 2007

Hello, I am very new to VBA. I am trying to create a macro for a Word 2007 document that finds a graphic, then resizes it to original size (Reset in Format Picture dialog box). I have recorded the following, which produces the result I want for one graphic. How do I make it loop so that it will perform the action on ALL the graphics in my document? When responding, please keep in mind that I am a novice with VBA. :) Sub ResizeSlide() ' ' ResizeSlide Macro ' ' Selection.Find.ClearFormatting With Selection.Find .Text = "^g" .Replacement.Text = "

2/26/2010 3:41:01 PM 2 =?Utf-8?B?TmluYQ==?= <N...@discussions.microsoft.com>
Sorting Tables in Order

Greetings all, I would love some advice/pointers on the following problem please! Our users use a Word Document to record Contact Session details, each contact session takes place on a different day and various detail about these sessions are recorded in a table. For every new session that takes place a new table within the document is created. Within this document, I have previously created a macro which will automatically create a new table and format it as with specific questions for the end user to complete. Within this automatically created table is an ActiveX DTpic

2/26/2010 11:32:01 AM 0 =?Utf-8?B?c3B1bmt5bXVmZm1vbmtleQ==?= <spunkymuffmon...@discussions.microsoft.com>
How to update values in message boxes from within VBA?

I have a macro (in VB) as shown down below invoked by F11 - I created it initially with record macro. It allows me to type in a name for an invoice and increment the invoice number. When I first press F11 it invokes two consecutive message boxes to accept input to update two fields on the invoice. The first message box comes up with the current value of the field from the invoice template (Client Name). I change the name in the this first message box and press OK on the message box. The second message box comes up with the current value of the field from the invoice templat

2/26/2010 8:35:38 AM 4 "Michael T" <micha...@dsl.pipex.com>
page number

Hi, I insert page number but It doesn't appear(in print preview). It is word 2003. Thanks

2/26/2010 1:53:01 AM 1 =?Utf-8?B?QWxpIEFzZ2hhciBTYWhlYmk=?= <Ali Asghar Sah...@discussions.microsoft.com>
ANTIVIRUS FREE DOWNLOAD 8955

Many problems with performance and safety of your computer can be solved easily with an updated antivirus and recognized. Antivirus Free Download Microsoft best practices in: http://yourantivirusfreedownloadonthissite.blogspot.com/ Content Site Links: http://yourantivirusfreedownloadonthissite.blogspot.com/ http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/what-is-antivirus.html http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/free-download-antivirus-recommended-by.html http://yourantivirusfreedownloadonthissite.blogspot.com/2010/01/antivirus-o

2/26/2010 12:25:01 AM 0 =?Utf-8?B?YW50aXZpcnVzIGdyYXRpcw==?= <antivirusgra...@discussions.microsoft.com>
Word 2007 VBA Tables & Dates

Hello, I have an empty word document that only has 1 table that has 2 columns & 5 rows. In cell(1,1), I have: January 1,2010 and all I am trying to do in VBA is convert that to a date so that I can do some date math functions, but I can't seem to convert it to date. In the VBA code, i have: Private Sub Document_New() Dim tbl As Table Dim day1 As String Dim day2 As Date Set tbl = ActiveDocument.Tables(1) day1 = (tbl.Cell(1, 1).Range.Text) day2 = (tbl.Cell(1, 1).Range.Text) End Sub However, "day2 = (tbl.Cell(1, 1).Range.Text)" gives me a type

2/25/2010 11:28:10 PM 2 Brian Lanehart <brian.laneh...@gmail.com>
Writing a Macro

I am creating a form in Microsoft Word 2003. There is an area that requests a physical company information, including; Address: City, State, Zip: Phone: Fax: Primary Contact: Email: I would like to make it so that when a box labeled 'same as physical address' is checked that the information that has been entered will autofill to corresponding fields labeled Billing Information, with the following fields: Address: City, State, Zip: Phone: Fax: Primary Contact: Email: Can anyone help me with this?

2/25/2010 10:53:02 PM 4 =?Utf-8?B?QnJpdHQ=?= <Br...@discussions.microsoft.com>
Automating Templates - Continued

Word 2007: have been working to build user form which is used to insert information into company letterhead: specifically name, email address and, when requested, the user's direct telephone number. I created a table in Word containing employee complete names, their email addresses and the direct phone numbers. The phone numbers aren't always included in the letter, but the users want an option to select it depending on who they are writing to. I have created the userform, have inserted code from the "Populate UserForm Listbox" instructions, which has gotten me to the part whe

2/25/2010 8:57:01 PM 10 =?Utf-8?B?SmVhbm5lSm8=?= <Jeann...@discussions.microsoft.com>
Using InsertFile and Page Numbering 'Restart' behaves unexpectedly

Hi, I am automating Word 2007 (have tried with VBA and C#) to append several documents together. These documents can have different margins, headers/footers, etc. I have followed the procedure described by http://word.mvps.org/faqs/Formatting/WorkWithSections.htm and am not getting the desired output. Given the following documents: Document 1 - No headers, footers without page numbers Document 2 - Different margins from Document 1, has no headers, but has footers without page numbers. Document 3 - Same margins as Document 2, has no headers, but has footers *with*

2/25/2010 8:50:01 PM 2 =?Utf-8?B?VGVycnkgQW5leQ==?= <TerryA...@discussions.microsoft.com>
Making a macro "auto open"

Hello, I have the following macro, which lets me set the zoom level for a document to 75%: Sub View75percent() ' ' View75percent Macro ' ' ActiveWindow.ActivePane.View.Zoom.Percentage = 75 End Sub My question is: how can I edit this to make it an "autoopen" macro, so that it will automatically open all existing documents to this zoom level? Many thanks, Josh Mandel

2/25/2010 8:39:01 PM 3 =?Utf-8?B?Sm9zaE1hbmRlbA==?= <JoshMan...@discussions.microsoft.com>
Extract just footer macro for Word!

Hi Everyone! Can anyone help me with the macro below? I would like it to simply extract all the footers in the document and paste them into a new word document??? Each footer would be a new line, essentially assembling a list of all the footers. What I have so far unfortunately does not work and complains about syntax errors.....can anyone please help me ??? Sub PullMe() Dim lCount As Long Dim sEnd As String Dim oDoc As Document sEnd = "Endnotes" & vbCrLf For lCount = 1 To ActiveDocument.Endnotes.Count sEnd = sEnd & lCount & vbTab & ActiveDocument.Endnotes(lCount).Rang

2/25/2010 5:28:19 PM 4 =?Utf-8?B?dW1jaGVtaXN0?= <umchem...@discussions.microsoft.com>
Switching between documents and windows

Hello, I want to cut and paste from one active document to another and keep the first document window on top. Code I'm working with: Dialogs(wdDialogFileOpen).Show ' user selects the Main.docx file ' Main.docx is activated by default ' select and copy stuff from Main.docx ' open Target.docx via Documents.Open FileName:="""Target.docx""" 'etcetera ' Target.docx is now active and it's window is on top ' paste stuff Now I want to make Main.docx activated and it's window on top. I can activate it easily enough by Windows("Main.docx").Activate But I can't figure out how to m

2/25/2010 5:05:02 PM 1 =?Utf-8?B?RyBUZWFjaG1hbg==?= <GTeach...@discussions.microsoft.com>
Error 5947 - Could Not Change Document Template

I have a Word 2003 template (*.dot) that contains the following line of code to attach the normal template (for the purpose of removing the link between the source template and the resulting document): ActiveDocument.AttachedTemplate = NormalTemplate When I use this template in Word 2007, this line gives a Run-time Error: 5947 'Could not change document template.' This happens if the template resides on my Windows Desktop or in another nontrusted location. If I place the file in my Templates folder (a trusted location), then this line seems to work without a problem.

2/25/2010 4:59:01 PM 0 =?Utf-8?B?TXJUb2Rk?= <MrT...@discussions.microsoft.com>
Name Directory

How do I forward a directory of names.

2/25/2010 4:47:01 PM 2 =?Utf-8?B?R3JhbW15?= <Gra...@discussions.microsoft.com>
Userform/FormFields

Greetings, I have a userform with a lisbox on it that allows multiple selections. I would like to add FormFields for each of the selected items and add the selected items text as the form field result property following a button click event. Is this possible and any Ideas how to accomplish this? TIA.

2/25/2010 4:24:04 PM 2 =?Utf-8?B?SmVmZg==?= <J...@discussions.microsoft.com>
File in Use problem - again

I was having this problem a few days ago and posted here. Then, almost immediately, I solved it. Or thought I had. Now it's back and the steps I took the last time aren't fixing it this time. I have to believe this is something fairly fundamental and is caused by simply forgetting almost everything about the art of writing Word Macros. Here is the original post again. If anyone can help with this, I'd really appreciate it!! -- I'm revisiting some VBS scripts that I wrote several years ago to generate resumes for me (via Word macros) and would like some guidance. My VBS script

2/25/2010 2:22:15 PM 1 "Rhino" <no.offline.contact.ple...@example.com>
Subscript problem

I'm just getting back into Word Macros after a long absence in which I feel like I've forgotten almost everything. My macros worked perfectly in Word 2002 but I've upgraded to Word 2007 and now I'm having a problem or two. The one that concerns me most right now is a subscript error. This is the macro that is giving me trouble: ================== Public Function exportMacros(exportedMacrosFile As String) As Long If doesPathExist(exportedMacrosFile) = False Then MsgBox "The path to which you want to write the macros, " & exportedMacrosFile & ", does not exist. " & vbCr

2/25/2010 2:18:53 PM 0 "Rhino" <no.offline.contact.ple...@example.com>
General Question about Macros

Can someone kindly remind me where macros are supposed to be put in Word 2007? Several years ago, I had to learn quite a lot about Word macros (for Word 2002) in the space of only a few days. I put together a bunch of them and got them all working satisfactorily. Unfortunately, I haven't had to touch them since and I feel like I've forgotten almost everything. I've also upgraded to Word 2007, which looks quite different in many respects to Word 2002. So I'm feeling rather clueless right now. I want to use these macros in Word 2007. Most of them still seem to work but I'm ha

2/25/2010 2:11:25 PM 1 "Rhino" <no.offline.contact.ple...@example.com>
how to change text of a part of a sentence automatically

Hi, I would like to know, how can I select part of a sentence Range object and change it's text automatically.

2/25/2010 7:24:01 AM 3 =?Utf-8?B?bWpsYWFsaQ==?= <mjla...@discussions.microsoft.com>
Removing External Data

I have a spreadsheet that retrieves external data from a SQL Server database. The user clicks a button that executes a macro. The table returned has a named range. I want to provide a button to REMOVE the data. Can someone point me to an example of how to remove the data (ideally using the named range, but will be happy with any example completing the task). Thanks, MEG

2/25/2010 3:37:01 AM 1 =?Utf-8?B?TUVH?= <...@discussions.microsoft.com>
Error: Programmatic Access is not trusted

I am revisiting an old VBScript that I wrote several years ago. It basically opens an existing Word document, then exports the macros associated with that document. This is the script: =========================== ' Get arguments into variables If WScript.Arguments.Count < 1 Then MsgBox "Too few arguments; expecting one." WScript.Quit Elseif WScript.Arguments.Count > 1 then MsgBox "Too many arguments; expecting one." WScript.Quit Else strArg1 = WScript.Arguments.Item(0) End If ' Find path for MyDocuments folder Set objShell = CreateObject("Shell.Application") Set obj

2/24/2010 10:03:14 PM 2 "Rhino" <no.offline.contact.ple...@example.com>
user form that retrieves data from Microsoft Access query

I created a word document that displays a userform when the template is opened, when you click on the ok button on the userform the template should display data that comes from a microsoft access query. The thing is that this works perfectly for me with my non-administrators account. The problem is that whenever another user is trying to open this template no data is being displayed. I checked the permissions on the folder where the template is located and that looks fine. Anyone has any idea what I might be doing wrong here? Thanks in advance.

2/24/2010 7:40:01 PM 8 =?Utf-8?B?RXJpYw==?= <E...@discussions.microsoft.com>

Pages: 2 3 4 5 6 7











Newest Articles

Multi-Column Report
3 min. 43 sec. ago

addressing mail
5 min. 17 sec. ago

Drop down list in Microsoft Word 2007
9 min. 17 sec. ago

How do I find out why? Error 3251
12 min. 44 sec. ago

Path.GetInvalidPathChars "Visual Basic 6.0 Classic" equivalent
15 min. 18 sec. ago