macro

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Section Break Changes on File Insert with Global Template Iâ??ve created a few functions and procedures in a template loaded via options/file locations/start up to enable users in a workgroup to insert letterheads and footers to new or pre-existing documents. The letterheads and footers are stored in individual templates (though Iâ??ve also tested with plain .doc). In each of the templates, a continuous section break follows each of the letterheads. The purpose of the section break is to preserve the formatting of the destination document, since the letterheads are fairly wide, and I donâ??. Version of Word is 2003. While I was in the startup-to-be template, I created and tested the functions and procedures to make all this happen. No problems. When I saved it to the start up directory and restarted word to load from it, I ran into a problem. When a letterhead is inserted now, the section break is no longer continuous but causes a page break. Iâ??ve tried this a few different ways, but the end result is always the same. Hereâ??s a look: Select Case intMethod Case 1 ' FIELD EMPTY Dim strIncludeText As String strIncludeText = Replace(PathToTemplates, "\", "\\") & strLetterhead strIncludeText = "INCLUDETEXT """ & strIncludeText & """" & " bmkLetterhead" Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldEmpty, _ Text:=strIncludeText, PreserveFormatting:=True Case 2 ' FIELD: INCLUDE TEXT Dim strIncludeText As String strIncludeText = Replace(PathToTemplates, "\", "\\") & strLetterhead strIncludeText = """" & strIncludeText & """" & " bmkLetterhead" Selection.Fields.Add Range:=Selection.Range, Type:=wdFieldIncludeText, _ Text:=strIncludeText, PreserveFormatting:=True Case 3 ' INSERT FILE: Linked Selection.InsertFile FileName:=strLetterhead, Range:="bmkLetterhead", Link:=True Case 4 ' INSERT FILE: Not Linked Selection.InsertFile FileName:=strLetterhead, Range:="bmkLetterhead", Link:=False Case 5 ' COPY & PASTE Documents.Open FileName:=strLetterhead, ConfirmConversions:=False, _ ReadOnly:=True, AddToRecentFiles:=False, PasswordDocument:="", _ PasswordTemplate:="", Revert:=False, WritePasswordDocument:="", _ WritePasswordTemplate:="", Format:=wdOpenFormatAuto, XMLTransform:="", _ Visible:=False Documents(strLetterhead).Bookmarks("bmkLetterhead").Select Selection.Copy Documents(strLetterhead).Close False Selection.PasteAndFormat (wdPasteDefault) End Select One other thing that I tried was inserting the section break before inserting the document. That also didnâ??t work. Hereâ??s the code: Selection.HomeKey Unit:=wdStory Selection.InsertBreak Type:=wdSectionBreakContinuous Selection.HomeKey Unit:=wdStory My requirement is to actually insert the letterhead rather than link to it, but I tried these other methods as alternatives hoping that one would work. Any ideas what is causing this or how I can work around it? Tag: macro Tag: 68004
  - 2
    - Cannot programmatically insert code on document from form I am trying to insert a button onto the document from a click event a button on a user form. I can do that sucessfully, but I am unable to add the code to "ThisDocument" to handle the click event of the newly created button. I am getting an error that says "the object invoked has disconnected from its clients". This error occurs on the following line: ActiveDocument.VBProject.VBComponents(1).CodeModule.AddFromString (sCode) The sCode variable contains another variable sCMDName (txt1.Text). I can make it work if I leave out the sCMDName and feed the AddFromString method only string information, but as soon as I add another variable Word give me the error above and crashes. Any suggestions would be a help. Thanks! Tag: macro Tag: 68002
  - 3
    - Why is ActiveX invisible in Design mode When embedding certain ActiveX controls in word document ( not in a form ) the control is invisible in design mode. It works fine and shows up when I toggle to Run mode but can't be found in Design mode except by moving the mouse around very slowly and waiting for cursor to change when over the border of the control. Anyone have any ideas what might be the problem, or more importantly what might be solution - how to make the control show up in design mode? Tag: macro Tag: 68001
  - 4
    - Saving formatting Hello, How can do the following programmatically (in a macro or add-in): 1. Go to given position in the document 2. save the current formatting used (character, paragraph, etc.) 3. Inset several lines of text, formatted with a given style. 4. Restore the saved formatting and add some more text. Best wishes, Alex. --=20 Address email to user "response" at domain "alexoren" with suffix "com" Tag: macro Tag: 67999
  - 5
    - word count in Endnotes and Footnotes Hello, Does anyone know how to grab the word count from endnotes or footnotes in VC++? I have gotten this far: endNoteObject = m_oDoc.GetEndnotes(); int counter = endNoteObject.GetCount(); // returns correct value But I don't see an option to get the word count. I tried setting a range with the Range object, but I cannot figure out how to get a word count out of that either. Thank you, Rob K Tag: macro Tag: 67996
  - 6
    - Field code to calculate number of years I need to insert a field code that can take the current date and then subtract a certain year and display the result. For instance I have a person who started working in 1970 and today is May 10 2005 so he has 35 years of service. If I could also calculate the exact start day mm/dd/yyyy and have the current date subtract, that may be helpful but not necessary - I don't need to break it down to months. Thanks! Tag: macro Tag: 67993
  - 7
    - Why Version modified internally on Each modification in the Master Document? hi! Why the Version is modified internally on Each modification in the Actuall Document. I am doing the following Steps: 1: Create a new document named MyDoc.doc. 2: Save a Version named "ver1" into the MyDoc.doc. 3: Open Version "ver1". 4: Save this version at some place i.e. V1-1.doc. 5: Again open Version "ver1". 6: Save this version at some place i.e. V1-2.doc. 7: Compare both saved Version files using WinDiff.exe utility which shows a difference in both files. I have also tested the above procedure programmatically by setting the RemoveDateAndTime property to TRUE before saving the versions but the difference is still there. Anybody there to tell me the reason why it so happens? Anything to avoid this? Thanks in advance. Ahmad Jalil Qarshi Tag: macro Tag: 67990
  - 8
    - How to Convert Document to Tiff Using MS Office Document Image Writer? hi! I want to convert Word document to Tiff using the Printer driver (MS Office Document Image Writer) installed with MS Office using VBA code. Is it possible? Any Solution? Thanks in advance. Ahmad Jalil Qarshi Tag: macro Tag: 67989
  - 9
    - Need help accessing BuiltInDocumentProperties from C# I have a series of tasks to perform, some of which involve working with Word using the COM interface from C#.NET. I have one problem I have not solved yet: How to access individual elements of the BuiltInDocumentProperties in a document. BuiltInDocumentProperties is defined as an abstract object according to the COM object browser. But I have not yet found what concrete objects are derived from this, or how to access them from C#. From VBA or vbScript it is pretty straight forward: (vbScript) docTitle = doc.Builtindocumentproperties (wdTitleField) Where wdTitleField is a constant defined in the script file. However, in C# this won't compile. Any ideas will be most appreciated. Jason For example, I need to get the Title field. Tag: macro Tag: 67978
  - 10
    - how can be good typing in the word ineed to training on typing and format in word program. Tag: macro Tag: 67973
  - 11
    - How to determine cursor position within a document I have to create a document which is divided into "chapters". Each of these "chapters" starts with a numbered style - say SpecialH1 and therefore occurs once only in each chapter. Within each chapter the user can add sections at random and as many as needed if they require to turn pages landscape for maps, diagrams and the like. If the user is in "chapter" 2 I can allow him to add a new chapter before the existing chapter 2 (which then becomes chapter 3). However, if the user's cursor is anywhere within chapter one, irrespective of the number of sections it may contain I must prevent them from adding a new chapter ***before*** chapter 1. At present I'm using the following to tell me in which section the cursor is in: thisSection = Selection.Information(wdActiveEndSectionNumber) This works OK provided there are a finite number of sections within chapter 1 and by manipulating the information I can prevent users from inserting a chapter before number 1. The problem arises when the sections within chapter 1 are varied, perhaps 2 or 4 or whatever. Is there a way, perhaps, of selecting the numbered style at the top of each chapter and identifying at which number it is? If it was at 1 then prevent user from adding another one before it. Can anyone point me in the right direction, please? My head is going into "fuzzy mode" trying to identify the way around this! Regards Roderick Tag: macro Tag: 67971
  - 12
    - help on forms hey everyone, i'm now starting to use forms and i need some pointers. what i'm trying to create is a template that as a couple of fields and dropdowns, then i want to come up with a way to: 1. copy the value that a text field is inputed with (fill in text field) to another point in my template; 2. i have a drop down menu that either assumes numeric values (from 0 to 10). what i need is: if that field is greater than 0 then i want my template to insert aditional lines for user imput information. it's sort of number of relatives living with you. if the guy filling in the info inputs 1, then a couple extra lines should appear (Name, Age, Ph number) if you find troublesome answering it all, just point out a few websites or so. thanks in adv, Miguel Tag: macro Tag: 67968
  - 13
    - dynamic instance of word should open a document, but not load any Hi folks ... I would like to open a document with a dynamic instance of word. Unfortunately a lot of plugins are installed and the creation of the dynamic instance takes up to 10-15 seconds on a 3GHz machine. Is there a way to "just open" the document and not loading/staring any plugins? Thanks for your help. Marco Tag: macro Tag: 67967
  - 14
    - Aligning table cell contents based on style Hello. I'm trying to align all table cell contents to the bottom of the cell if they are "Table Heading Style". I've written the following macro to do this. Sub AlignTables() 'Aligns table headings Dim Table, aRow, aCell, myRange For Each Table In ActiveDocument.Tables For Each aRow In Table.Rows For Each aCell In aRow.Cells myRange = aCell If myRange.Style = "Table Heading" Then aCell.VerticalAlignment = wdAlignVerticalBottom End If Next aCell Next aRow Next Table End Sub This doesn't work though. I get an error - "Object variable or With block variable not set". Any ideas how I can get this working. Thanks in advance. Dave. Tag: macro Tag: 67966
  - 15
    - Can't use 'optinal' when using Application.Run Hi I can't use references in my VBA code, so instead I use Application.Run to call subs and functions in my global addin. But when I do that, I cant use 'optional' in my sub/function. Ex. Sub CallMe (Byval Arg1 as string, Optional Byval Arg2 as string = "Local Arg2", Optional Byval Arg3 as string = "Local Arg3" Debug.print Arg1, Arg2, Arg3 End sub Calling the sub with CallMe "Arg1", , "Arg3" would result in "Arg1", "Local Arg2", "Arg3", just as expected. Calling the sub using Application.Run "CallMe", "Arg1", "Arg2" results in "Arg1", "Arg2", "Local Arg3". But when I call the sub using Application.Run "CallMe", "Arg1", , "Arg3" I get the result "Arg1", "Local Arg2", "Local Arg3". Why is the sub ignoring the third parameter, and instead using the local data, when i skip the second parameter?? Iâ??m using Office 2003 Thanks in advance Jan Amdi letvad Tag: macro Tag: 67963
  - 16
    - language and 'format' Hi included in a vba-module I need to find out when a certain file is modified. I use the code: date1 = Format("file.doc".datelastmodified, "mmmm yyyy") the variable is now giving the date 'Maj 2005' in danish as my Windows is in Danish. I need to translate this date into different languages: English 'January 2005', Swedish 'Januari 2005' etc. How can I do this in vba? Tag: macro Tag: 67962
  - 17
    - Load and Use Classes from another template Hi Group I'm in the process of building a bunch of templates for various use (report, fax, memo...). Once finished, the templates will be distributed through local network shares to my co-workers. Now the different templates have many things that they have in common (e.g. phone number, address etc.), which I would like to store in a central place. Also, I'd need some macros in all of the templates, which I would like to store in a central place, too. I have thought about using a reference in C:\Documents and Settings\...\Application Data\Microsoft\Word\STARTUP that points to a resource .dot file on the network. That file can now hold all the stuff that needs to be centralized. So far the resource template gets properly loaded on startup of word, but I'm unable (or don't know how) to access the information within (through VBA code in the document template, say on document_new). So, these are my questions: 1) Is this whole stuff a good idea or should I drop it and "hard-code" the information into each template? 2) How can I access those classes from within the document template's VBA code? Any help greatly appreciated! Thx, Bernhard Tag: macro Tag: 67961
  - 18
    - Word Object model does not recognize ".," dot followed by comma Hi, I am trying to read ThisDocument.Range.Sentences, to process all the sentences in a document. But when the text contains a ".," that is a full stop followed by a comma, as in the following situations - "ABC & Co.," Word object model does not recognize the text properly. For example, Thank you for contacting ABC &Co., and we hope that our association will be mutually profitable and beneficial. Now when I read the sentences, I find that "," and ", and we hope that our association will be mutually profitable and beneficial." are returned as the two sentences contained. I presume this is a bug with the Object model. Have anybody else encountered a similar situation?? Can somebody help me out here. Note: I am using Word 2003. Thanks in advance, Thanks and Regards, Laks Tag: macro Tag: 67957
  - 19
    - adding caption to a photo I have a bunch of .htm files created by Word with embedded pictures (photos - inserted as picture from file). These photos are set to square wrap and left justified. I'm working on a macro that will let me add a comment below each photo and leave it in a square wrap, left justified in the same original position. I have this macro mostly completed but a couple things don't work quite right so I would be interested if someone has any insight. First, I created a transparent text box and aligned it so that it was centered just under the picture. This works fine but as soon as I group the picture and text box, the text box gets shifted from just below the photo to the center of the picture, messing up my careful alignment. Next, the act of grouping the picture and text box also undoes the square wrap of the original photo. So I was hoping that I could restore the original setup by re-setting a square wrap along with the top and left values of the photo/text group to that of the original photo. Unfortunately, while this almost gets it right, it appears that this shifts the final result to the beginning of the paragraph whereas the original picture was inserted somewhere inside the paragraph. Attached is the script using Word 2003. Denis --------------------------------------------------------------- Sub AddText() ' Picture must already be selected (add error checking here) Set pict = Selection ' Save picture name, height, and top and left positions With pict.ShapeRange pictname = .Name pictht = .Height pictrvp = .RelativeVerticalPosition picttop = .Top pictrhp = .RelativeHorizontalPosition pictleft = .Left End With ' Create text box the width of picture, set fill and outline to transparent ActiveDocument.Shapes.AddTextbox(msoTextOrientationHorizontal, _ 197.6, 368.35, pict.ShapeRange.Width, 10).Select Set tbox = Selection With Selection.ShapeRange .Fill.Visible = msoFalse .Fill.Visible = msoFalse .Fill.Transparency = 0# .Line.Weight = 0.75 .Line.DashStyle = msoLineSolid .Line.Style = msoLineSingle .Line.Transparency = 0# .Line.Visible = msoFalse .Height = 26# End With ' Insert text in bold format in text box tbox.Font.Bold = wdToggle tbox.TypeText Text:="Text" tbox.ParagraphFormat.Alignment = wdAlignParagraphCenter ' Make ShapeRange out of picture and text box, align text box with center ' of picture, shift text box down to just below picture, then group vertshift = (pictht + tbox.ShapeRange.Height) / 2 ActiveDocument.Shapes.Range(Array(pictname, tbox.ShapeRange.Name)).Select Set pictext = Selection pictext.ShapeRange.Align msoAlignLefts, False pictext.ShapeRange.Align msoAlignMiddles, False tbox.ShapeRange.IncrementTop vertshift ---> pictext.ShapeRange.Group.Select <---- this messes up alignment ' Set to square wrap with previous position of picture With Selection.ShapeRange .RelativeVerticalPosition = pictrvp .Top = picttop .RelativeHorizontalPosition = pictrhp .Left = pictleft .LockAnchor = False .LayoutInCell = True .WrapFormat.AllowOverlap = True .WrapFormat.Side = wdWrapBoth .WrapFormat.DistanceTop = InchesToPoints(0) .WrapFormat.DistanceBottom = InchesToPoints(0) .WrapFormat.DistanceLeft = InchesToPoints(0.13) .WrapFormat.DistanceRight = InchesToPoints(0.13) .WrapFormat.Type = wdWrapSquare .TextFrame.AutoSize = False End With End Sub Tag: macro Tag: 67947
  - 20
    - Auto install button at startup - different computers - same user? Hi Folks, I have a little program that I have written and send to various users on my network. The program is installed by the user by running a batch file that I attached to an email - the batch file installs the various .dot files in the users /templates/ menu. All good so far. The batch file also copies a file to the users /Application Data/word/startup menu to install the button automatically when word is started up. Now here the problem : we have heaps of computers at work and more often than not a user will log on to a different computer each time - the startup folder is specific to each machine their fore it means the user must run the batch file for each different computer that they use - a real pain in the ass. I see one possible solution - howabout including in the batch file a file that copies another batch file to the /Documents & Settings/All Users/Startup folder - this second batch file copies the word file that installs the button everytime a user logs on? Anybody else have any better ideas? -Al Tag: macro Tag: 67945
  - 21
    - Can the (") delimiter be changed to another character? Hi, I have the need to replace many pairs of strings that have the (") in them. These pairs of strings are read from a file. Listed below is part of my code: ========================================= Open "myfile.txt" For Input As #1 Do While Not EOF(1) Input #1, sFirst, sLast Selection.Find.ClearFormatting Selection.Find.Replacement.ClearFormatting With Selection.Find .Text = sFirst .Replacement.Text = sLast .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = True .MatchWholeWord = True .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Replace:=wdReplaceAll Loop Close #1 ========================================= Is it possible to change the (") delimiter character in Word/VBA - to, let's say - (¬) or (¢) ? Or, does anybody have a better idea? Thanks so much for your help. JS Tag: macro Tag: 67938
  - 22
    - msoPropertyTypeString too short I'm writing a series of macros in VBA for Word. I need to set aside some text so that a subsequent macro can look at it. I want to store it in a custom document property, but msoPropertyTypeString is limited to 255 characters, and the text I want to store is sometimes longer than that. Is there any other custom property type that I can use, or any other way that I can store a bit of text outside of a running macro? Thanks for your help. Martin Tag: macro Tag: 67937
  - 23
    - Code for closing Word I have been attempting to get a macro together that will do the following: 1.Unprotect a document (if protected) 2.Select the document 3. Copy the document 4.Close the document 5.Supress the save prompt and will several individual's assistance from this discussion board I have gotten that macro. The question I have now is, Can I close Word as the last step of the macro (not just close the document.) Here is the code that I have been using: (thank you all for your help!) Dim oDoc As Document Set oDoc = ActiveDocument If oDoc.ProtectionType <> wdNoProtection Then oDoc.Unprotect End If oDoc.Content.Copy oDoc.Close SaveChanges:=wdDoNotSaveChanges -- Thanks for your help! H Dodson Tag: macro Tag: 67935
  - 24
    - Can VBA set row height to present value I have a wide table that I need to print on two landscape pages. I delete the right half and print the left side; then delete the left side and print the right side. However, the rows will not align between the two pages, since they collapse to the size necessary for the remaining cells. Can I freeze each row height to the present value by VBA when I have the whole table, so when I delete half the columns the rows will not collapse. Then each independently printed half will line up with its other half. I am using WORD 2003 Tag: macro Tag: 67933
  - 25
    - Determine visible text on screen Is it possible with the Word object model to determine what text is visible onscreen at any particular time? Thanks, John Tag: macro Tag: 67929
- Next
  - 1
    - Macro for sending Word doc via e-mail If I want to send a word document via e-mail (as an attachment) I know I can use the following code: ActiveDocument.SendMail This opens a new Outlook box and attaches the active word document -- this is good, but.. How can I specify the name of who this is to be sent to. I don't want to use the routing slip approach since that seems to include verbiage in the actual text section of the mail indicating that the document needs to be routed further -- I have only one recipient that the file is to go to. Is there also a way of specifying the subject field verbiage as well as being able to specify any text associated with the body of the mail message?? I tried using the same code that works well in doing this for Excel but this does not work for Word (using the recipient's name etc..) Tag: macro Tag: 67925
  - 2
    - "Highlight" selected text boxes I may have seen the solution to my problem a while back but of course I cannot located it now. Sorry if this is a duplicate question. Word 2003 Form with default text in text boxes. I would like to have the selected text box text highlighted in blue like it does in windows. The user could just overtype the default text. Thank-you, -- Thank-you and all suggestions are appreciated. Tag: macro Tag: 67920
  - 3
    - ActivePrinter not working in macro. We've got an application that invokes Word, executes a macro, does a merge with data pulled from a text file extracted from a database, etc, and then prints the merged document to a specific printer. For years we've been having to manually set the Windows default printer on the workstations to use the specific printer that's needed because even though the macro has the command: ActivePrinter = "SPECPRINT" this printer never gets used unless it is the default for the user session upon the workstation before the macro ever gets run. The SPECPRINT printer is defined upon each workstation and is an LPR network printer which prints to a special print queue hostsed on a unix system which "broadcasts" the print jobs out to about half a dozen HP laserjet printers scattered about our network. We'd like to get away from having to make the SPECPRINT printer be the default printer on all the workstations becuase the users are continually forgetting to manually pick another printer whenever they print ordinary print jobs, and inadvertantly broadcast out those jobs to all the special broadcast printers and waste a lot of paper. The problem is that the "ActivePrinter" setting in the macro is getting ignored and it doesn't seem to matter what value it's set to... the print output just always goes to whatever the default printer is set to. Is this a common issue with ActivePrinter? Is there a better way to programatically direct the output to a specific print queue? Tag: macro Tag: 67915
  - 4
    - DocVariable Fields Hey I am pretty new to VBA and am trying to set up a macro that will update all of the fields in a document that are DocVariables. Some are in the body of the document and in the header/footer. I have one set up that will update all fields, but that is doing more than it needs to as it does the TOC and all the inclused text. Also anyone know of a good reference for object naming conventions in Word VBA, I program in other languages so the language structure is easy to pick up, just shakey on accessing the objects I want to. Thanks Tag: macro Tag: 67914
  - 5
    - Template errors I had a template which was created with Word 2000 and now we have Word 2003. Everything was working fine until I wanted to add a new button to the template. Now any document that was created with the 2000 version template errors when it's opened in Word 2003 because it see's the code for the new button I created but it doesn't see the button. This must be something new with Word 2003 where it stays connected to the template and any new code that is added to then template is added to an existing document. Does anyone have any ideas?? Tag: macro Tag: 67907
  - 6
    - Reading tabs stops Hi Folks, I'm looking for some help on reading Tab Stop information for every style from a template (more than 100 styles many of which has more then 2 tabstops set). Any help appreciated. Cheers J Tag: macro Tag: 67900
  - 7
    - reffering to a template the right way? Hey, I'm using word to create a referation to a template. But It seems to fail, because it when the template loads it only shows the editing part. It originally use to create a new document witch used the template macro's. It wont seem to work with a simple reference to the template.dot I hope someone could help me out. Thanks. Tag: macro Tag: 67893
  - 8
    - identifying lists in a selection Hello, I am trying to identify any lists within a selection. The user will selected some text in a word document (word 2002), then press the button to launch my macro which should convert the text selected into HTML :-) But I can't seem to grab hold of any lists within the selection - if I don't select any text I can use ActiveDocument.lists but there doesn't seem to be an equilivent command for selection.range. What I need to be able to do is find a list in the selected text, enter text before and after the list, and then work through each list item and do the same e.g. <ol> <li>item 1</li> <li>List 2</li> </ol> But if I can't even get hold of my list in the first place, this is going to be a triffle difficult! Any help, advice or pointers greatfully received. Many thanks Amy - still in the ooo, what does this command do phase of VBA p.s. yes I know word and HTML don't go together, but this really is the best solution to my particular problem - at the moment! Tag: macro Tag: 67892
  - 9
    - Automating steps to copy URL from IE into Word This seemed like a Windows question more than a Word question, I sent it to a Windows newsgroup, and was told it was a Word question. So here goes. Here's the kind of thing I do a million times. I've just copied some text from a web page into Word. Now I want to copy the URL of that web page into Word. I do Alt+Tab to switch back to the Internet Exporer page. I press Alt+D to place cursor in address bar. I press Ctrl+C to copy the address. I use Alt+Tab switch back to Word. I press Ctrl+V to paste the url into Word. Would there be a way to automate these five steps into one action, whether done by a .vbs file or some other means? Tag: macro Tag: 67887
  - 10
    - Is "Document Recovery" a toolbar? hi! I have seen that sometimes there is a document Opened into Word and Word Crashes due to any reason and when I run a new instance of Word I can see a Docable window with Caption "Document Recovery" displayed on left hand side of the document. I want to know: 1: What type of window is this? 2: Can I access it? 3: Can I create my own docable window like this one using VBA. any Help????? Thanks, Ahmad Jalil Qarshi Tag: macro Tag: 67886
  - 11
    - Using DAO from Microsoft Word There seems to be no VBA help topics showing the Objects, Methods, and Properties need to use DAO from a Microsoft Word VBA program and I get no results when search MSDN. Where can I find documentation???? Specifically, I need to know the syntax for passing a query string to the OpenRecordset method. Thanks in advance for any help you can offer. Thanks, Keith Tag: macro Tag: 67881
  - 12
    - Can I use a macro to break up doc into separate files? Hi All, I have a long document (a user's manual) that I want to break up into a number of separate HTML files. Ultimately, these will become my online help (compiled HTML). I don't know of any way to simply convert from a Word dco to a .chm file, so I'm wondering about a macro to break the document up for me. At least that much of the conversion will be done for me. Each section of the doc has a number of Headings of various levels included. Ultimately, I'd like to select all the text from each Heading 1 to the next Heading 2, or Heading 1 if no Heading 2 exists. If a Heading 2 exists, I want to select all the text from it to the next Heading 2, or Heading one if there isn't another one. Once the text is selected, I want to save it to an HTML file, named whatever the Heading text is. I know my way around Visual Basic, but know mext to nothing about Word. Is what I want to do a reasonable thing? Is it possible that this has been done before, and some macro code is already out there somewhere? - Max Tag: macro Tag: 67880
  - 13
    - Adding a range object to a Mail Merge field Result Any assistence for the following problem will be most appreciated. I am writing a macro that takes codes and text from one document, called Structure.doc and inserts the text, and text associated with several codes [which are stored in tables in several other word documents] into an existing report. The codes are stored in a word document that contains 1 table with 2 columns. The first column hads the code, the second column has the text [which may include numbering, formating, tables etc] This macro works fine. However, in the Strucutre document, I need to be able to toggle the codes on and off where on displays just the codes, and off displays the full text assosated with the code, just as in the Mail Merge preview. However, as the codes are stored in several documents, and only certain codes from each document are selected, I do not think I can use the in-built Mail-merge function. My thought was to use a mail merge field that the user could enter the code in the field, and then use a macro to insert the field Result from the appropriate document. I found this will work if using the fields(i).Result.text except that tables and all the formating is lost. From my understanding, the fields(i).Result is a range object and so I should be able to insert a Selection.Range object into the fields(i).Result. However, whenever I use the code: ReportDoc.fields(i).Result = Selection.Range word crashes. Can anyone explain what I am doing wrong? If the above is not clear enough, let me know and I will try to reword. Thanks, Simon Tag: macro Tag: 67878
  - 14
    - Need Help With Wildcaed Search Hi, I have a table with alphabetic entries in it. I want to search the table for all entries beginning with a selected letter. I need to add a NOT to the search but I haven't been able to construct a string for the NOT. As an Example: Table ... Argentina Argentina - Buenos Aires ... So far I have <A{1} which seems to pick all the "A" entries. However, what do I add to the string so that the word "Aires" is NOT selected. Any help or suggestions would be appreciated. Jerry Bodoff Tag: macro Tag: 67872
  - 15
    - how do you input a signature in word? Hi i am currently designing a template for engineers to print and give to customers once they have completed their job. However i need the customer to input a signature and for it to show on the worksheet template that has been filled in with the work carried out. I have a signature pad for customers to use but i dont know how to link it to the word template? Can anyone help please? Tag: macro Tag: 67869
  - 16
    - find and copy all highlights of a particular color Hi all. I'm working with a long document in which "glossary" words have all been highlighted bright green. I would like to copy all of these words into a separate document so that I can create the glossary. I'm sure that Word has built-in features that would be a better choice for this task, but I have to remain within this particular scheme, so I'm just trying to make my job a little easier. I have an old WordBasic macro that finds all the occurences of a particular text string and appends them into a text document, one by one, but I can't quite figure out how to do the same in VBA and then modify the search, and I don't think WordBasic supports a search for a particular highlight color. Can anyone point me in the right direction? Thanks. Rodney Tag: macro Tag: 67863
  - 17
    - Word 2003 XML documents as plain text (unicode) I write a macro to manipulate some tags in XML documents. In previous versions of MS Word it wasn't a problem to insert XML-documents automatically in plain text format. How can I either set the MS-Word defaults in order not to have XML documents opened as XML documents or alter the following code to have the files inserted as plain text (unicode) files? Selection.InsertFile FileName:= myfile$, Range:="", _ ConfirmConversions:=False, Link:=False, Attachment:=False (of course I want to avoid having to confirm each conversion manually) Any help is much appreciated. Francois Tag: macro Tag: 67862
  - 18
    - Can I set the tab order in a form created in Word 2003? I created a form in word using tables and form fields and I need to set the tabs to move vertically instead of horizontally. Is there a way to tell the tab key where to go next? It is a great form with this one exception!! Thanks for your help. Brittany Tag: macro Tag: 67859
  - 19
    - Button in word doc Hi there i was just wondering if it is possible to have a command in a word document in the form of a button, to insert a new line in a table and to have texxt boxes in there aswell placed automatically.. Mat thanks in advance Tag: macro Tag: 67844
  - 20
    - I need to create an index from existing document..HELP! Tag: macro Tag: 67840
  - 21
    - Copy Textbox contents to clipboard Dear all, I do a lot of repetitive typing at work. I have a list of templates which I want handy around. I am thinking of having a word document with textboxes which are holding my different templates. I am hoping to have a button beside each textbox so that when I click it, it will automatically copy the textbox's contents to the clipboard. I can then paste these onto the software which I am doing data entry to. I have tried stuff like "textbox1.copy" but this does not work. Nothings goes onto the clipboard. What am I missing? Sorry this is my first attempt at programming, so to speak... anyone can help? Tag: macro Tag: 67837
  - 22
    - what code will unprotect a document. Using Word 2000 and later, I need a code to put in my macro that will unprotect the document. I am using a simple macro as below and the first thing I want it to do is to unprotect the doc. Any ideas? This is what I have thus far: Selection.WholeStory Selection.Copy ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges End Sub -- Thanks for your help! H Dodson Tag: macro Tag: 67828
  - 23
    - SAVE Method How would I code something to say if it someone is closing or saving the document to look at a varable and change things accordingly? I have it changing things accordingly when a person tabs out of a field but if they don't use the tab key it doesn't change what it is supposed to. Tag: macro Tag: 67824
  - 24
    - Where I can find documentation for the commands for DDE and Word? I need find some documentation for the commands to use for interfacing with Word, i.e. "FileExit(2)", etc. Tag: macro Tag: 67817
  - 25
    - Why OnClosing Doc. Containing my ActiveX Ctrl asks me to save. Whereas its already saved!!!!! hi! I have a ActiveX control Written in VC7.1 for Word. when i insert my control into Word and close the doc after saving the document, it again asks me Do you want to save the changes? But on thing to be noted is that I handled the event DocumentBeforeClose and in this i verify that the document is saved or not. and the doc. is not modified but Word warns me. I dont know why? I also pass fClearDirty = TRUE in the following function call. Anybody there to solve my problem. HRESULT IPersistStreamInit_Save(LPSTREAM pStm, BOOL fClearDirty ,ATL_PROPMAP_ENTRY* pMap) Thanks Jack Tag: macro Tag: 67811

i upgraded word from 2000 to office 2003 pro...now i lost my macros...how
do i recover it back?

Re: macro by Jezebel

Jezebel
Tue May 10 16:48:31 CDT 2005

Find the template you saved them in (probably normal.dot) and restore it.

"manny a via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in message
news:2054cc9d37eb4a2fb2e0bf490239639e@OfficeKB.com...
>i upgraded word from 2000 to office 2003 pro...now i lost my macros...how
> do i recover it back?

Top

Re: macro by manny

manny
Wed May 11 10:07:43 CDT 2005

i get invalid procedure! what do i do?
please help!!!!

--
Message posted via http://www.officekb.com

Top

Re: macro by Charles

Charles
Wed May 11 11:23:58 CDT 2005

Your macros were stored in one or more templates or documents, probably in
normal.dot. Find your old normal.dot. Name it normalold.dot and put it in
the Word startup folder on your new computer. Remove any duplicate AutoText
entries. See http://addbalance.com/word/movetotemplate.htm for step-by-step
instructions on moving / sharing / copying / backing-up customizations
including AutoText, AutoCorrect, keyboard assignments, toolbars, macros,
etc.
--

Charles Kenyon

Word New User FAQ & Web Directory: http://addbalance.com/word

Intermediate User's Guide to Microsoft Word (supplemented version of
Microsoft's Legal Users' Guide) http://addbalance.com/usersguide

See also the MVP FAQ: http://www.mvps.org/word which is awesome!
--------- --------- --------- --------- --------- ---------
This message is posted to a newsgroup. Please post replies
and questions to the newsgroup so that others can learn
from my ignorance and your wisdom.

"manny a via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in message
news:2054cc9d37eb4a2fb2e0bf490239639e@OfficeKB.com...
>i upgraded word from 2000 to office 2003 pro...now i lost my macros...how
> do i recover it back?

Top