Table formatting code extremely slow

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Search for grouped clipart and text I am looking for assistance on searching on shape objects. I have grouped clipart and a textbox that I am trying to search on. The code below works when I manually search, but I would like to automate this process. I have the grouped images anchored to text. I want to align all of these "icons". Can someone steer me in the right direction? Once The search is complete I want to align with the following: Selection.ShapeRange.RelativeHorizontalPosition = _ wdRelativeHorizontalPositionColumn Selection.ShapeRange.RelativeVerticalPosition = _ wdRelativeVerticalPositionParagraph Selection.ShapeRange.Left = InchesToPoints(0.5) Selection.ShapeRange.Top = InchesToPoints(0.1) Selection.ShapeRange.LockAnchor = False Selection.ShapeRange.WrapFormat.AllowOverlap = False Then cycle through to the end. Any help would be great. TIA Geoff Tag: Table formatting code extremely slow Tag: 71891
  - 2
    - Merge Documents in Memory I have a project that involves opening several Word documents in memory, making changes to the text, merging them into one master document, and printing it to one file. The problem I'm facing is that I can't figure out how to merge the document objects without saving them first. Word appears to have no problem merging documents from file, but I would rather avoid this. Writing the changed document to file first would cause unnecessary overhead. I considered programmatically using cut and paste operations to accomplish the merge, but this seems like a hack. Can anyone suggest a better way? Many thanks in advance, -Tim Tag: Table formatting code extremely slow Tag: 71885
  - 3
    - Custom App Ok, so I'm building this form that will cycle through a range of documents. The range may vary depending on user selection. That is, the module that processes the information may cycle through as little as 5 documents (sets values from the text fields into the fields on the documents) to as many as maybe 20 documents. What is the fastest way to get this done? Some documents do not have any fields in them so they don't require any information to be added to them but they do need to be copied over to another folder for the user to browse. I have attached the code that I have used for this below. My problem I believe that this code can run faster I just don't know how. Is there any way to tell if a document has bookmarks without opening it? That would definitely cut down on the processing time I think. Any suggestions are welcome!!!! Code: (startList & endList are defined in a separate module: current range is 5-16) For i = startList To endList ' Opens, saves, and closes each document Set oDoc = Documents.Open(templateDir + Template$(i) + ".dot", Visible:=False) oDoc.ActiveWindow.SetFocus oDoc.ActiveWindow.View.Type = wdPrintView If oDoc.Bookmarks.Count >= 1 Then Application.Run MacroName:="SetFormFieldInfo" oDocSaveName = Template$(i) + ".doc" oDoc.SaveAs FileName:=saveDir + oDocSaveName, AddToRecentFiles:=False Else: WordBasic.CopyFileA templateDir + rifTemplate$(i) + ".dot", saveDir + Template$(i) + ".doc" End If oDoc.Close Next i Tag: Table formatting code extremely slow Tag: 71884
  - 4
    - wdDialogFileOpen folder problem We've just upgraded our system to W2k3 terminal server with Word 2k3 SP1. Macros which worked fine in Word97 are now a little flaky! In a couple of places we have code as follows: ChangeFileOpenDirectory UserDir Dialogs(wdDialogFileOpen).Show The Open dialog always appears but sometimes the "look in" folder is "My Documents" not the directory set in UserDir. The directory in UserDir does exist - we get an error if it doesn't. There is no pattern to when the right directory appears, it can work correctly fifteen times or more and then fail, alternatively it can fail fifteen times and then work once. Tag: Table formatting code extremely slow Tag: 71882
  - 5
    - English-Danish and German-Danish translation I am very satisfied with the English-Norwegian automatical translation and would like to have English-Danish translation. Would it be possible or have you any plans for establishing this feature. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=45b1dbb1-35c7-4bbb-a5bf-d2de09900c13&dg=microsoft.public.word.vba.general Tag: Table formatting code extremely slow Tag: 71876
  - 6
    - Word2003 stops responding My users have a problem with word2003, it stops responding with no apparent reason. They will be working fine opening and editing word documents and after a while the cursor in the word document would freeze and they no longer able to edit the document. The only way thus far to correct this is to shut down and restart the application. Has anybody ever seen this. Thanks for any help. Tag: Table formatting code extremely slow Tag: 71875
  - 7
    - Datei automat. als pdf speichern Hallo Newsgroup, ich mÃ¶chte aus Word die Datei mit einem Makro automatisch als pdf-drucken. Normaler Drucker funktioniert einwandfrei. Gebe ich Adobe als Drucker ein funkrtioniert es bis zu dem Punkt, dass Word Dateinamen und Speicherort des pdf-Dokuments wissen mÃ¶chte. Wie kann ich diese MenÃ¼abfrage ebenfalls in das Makro einbinden, so dass ich dieses nicht jedesmal noch manuell machen muss? Danke und viele GrÃ¼Ã?e, Nuray Kalis Tag: Table formatting code extremely slow Tag: 71872
  - 8
    - Attached Template Issue I have a master template which contains quite a bit of VBA code. We send this master template to department adminstrators who tweak and create sub templates from the master. These sub templates are then distributed to the staff who create their end documents. In the save event I programmatically detach the "attached template" and re-attach the master template so at any stage of the process the template and/or end docuement uses the VBA code from the master. This has worked great (about two years) untill recently. Although, the master is still attached to the end document (which I have verfied by stepping through the code) it can not seem to find it. After some research, I found MSDN article 823372 which describes mt issue perfectly. This article provides a work around and a hotfix (hotfix not avaible to general public until full regression testing has been completed but can get it by calling microsoft) but neither one works as well as I hoped. After days of testing I have come to beleive that an Office Security patch is the culprit (KB887979). My question is: Has anyone else had this issue? And does anyone know if this Office Patch is in fact the culprit. I would perfer to leave it out of any new ghost images we send to the field if it is infact the problem. I know with several tests I would be able to answer my own question but I thought I would ask to save some time. Thanks Jim F Tag: Table formatting code extremely slow Tag: 71865
  - 9
    - how to select text in active cell? how to select text in active cell? sometimes the cell has more than one line so it needs to be able to select that aswell thanks Tag: Table formatting code extremely slow Tag: 71863
  - 10
    - compile error - named arguement already specified - Selection.EndK I keep getting this error and i dont know why. It comes from this line of code and its because of be when i change the unit to wdstory (previously i left it out) ps i want it to select everything within a cell , will wdstory do this? Selection.EndKey , unit:=wdStory, Extend:=wdExtend 'code which is causing problem If Selection.Find.Found = True Then Selection.Move unit:=wdCell, Count:=12 Selection.EndKey unit:=wdColumn, Extend:=wdExtend Selection.MoveRight unit:=wdCharacter, Count:=1, Extend:=wdExtend ' Selection.Copy Selection.Move unit:=wdCell, Count:=-13 Selection.Paste Selection.EndKey unit:=wdColumn Selection.HomeKey 'Selection.ClearFormatting Selection.EndKey , unit:=wdStory, Extend:=wdExtend ' error line Tag: Table formatting code extremely slow Tag: 71861
  - 11
    - How do I make only periods on my screen appear bigger? For ease of reading on my screen, I want only the periods a lot larger and bolder, i.e., Lucinda Console, etc. We use Times New Roman 12 at work, and the periods colons are so faint I can barely see them. I do not want to enlarge everything. I'm trying to find an autocorrect option to do this. I created a macro to do after the fact, but I'm not thrilled with this option. There has to be an autocorrect option that when a period is typed it is changed to another bolder font. Thank you for your help! Tag: Table formatting code extremely slow Tag: 71855
  - 12
    - Searching multiple, though similar documents, for specific text. I am attempting to create an Access database that will populate table fields based on the search results of current and potential employee resumes. For example, capturing X # of characters either side of words like "Master's Degree", or "Military." I already have a similar question out to the Access group, but started thinking that this would probably need to be a two step process, starting with seaching a Word or RTF document, somehow saving the results as *.txt and then importing that into Access. Tag: Table formatting code extremely slow Tag: 71846
  - 13
    - Change text color I have a blue that I have to change throughout several documents to a specific blue with RGB colors values. Is there a way to do this through VBA? Tag: Table formatting code extremely slow Tag: 71844
  - 14
    - HELP - Why is my whole menu disabled???? I am programmatically opening a mailmerge document and bringing it up in PREVIEW mode. When I look at the document, I would like to close the document but leave WORD open. But the entire menu seems to be disabled as well as the box to just close the current document. The only thing that is enabled is the upper right corner box to close WORD altogether. Is there a command that I need in order to have the menu enabled? Thanks. Here is most of my code to preview the document: *************************** oDoc.MailMerge.MainDocumentType = 0 oDoc.MailMerge.OpenDataSource; (dsname,wformat,wconfirmconv,wreadonly,wlinktosource,; waddtofilelist,wpassworddoc,wpasswordtemp,wrevert,; wprotectdoc,wprotecttemp,wconn,wsqlstatement) oDoc.MailMerge.Destination = 0 oDoc.MailMerge.Execute oWord.Documents(1).Activate oWord.WindowState = 1 oWord.Visible = .T. Tag: Table formatting code extremely slow Tag: 71843
  - 15
    - Range of a field [Word 2000 on Windows XP] This is about creating page number prefixes of the form C.9, where C is the SEQ nubmer of the chapter. I can do it all manually through the UI, but I'm trying to do it programatically. I can iterate through the fields collection in each header and footer and find any PAGE fields, BUT I can't figure out how to establish a range object that lets me insert stuff just before this field. objRange = objField.Result just doesn't work reliably -- things get inserted in the middle of the field code, when they get inserted at all. It works when you use selections in the active document, but not when you use range objects. Any clues? Bear Tag: Table formatting code extremely slow Tag: 71841
  - 16
    - VBA references Hi everyone! Is there a way to tick or untick the references from the tools menu not manually but with a command? I found in VBA help a command like this: VBE.ActiveVBProject.References.Count and tried to display in a msgbox the references of my project but I got no result although I ckecked that when I opened the references from the tools menu there where 5 references ticked. Tag: Table formatting code extremely slow Tag: 71840
  - 17
    - Range Character Count is off....can't figure this out. Hi All, Below is a macro followed by a document that I am running through looking for instances of a Test. The Tests are marked by [~Test ID=xxxx~], (xxxx is a variable number). I need to select the range from [~Test ID=xxxx~] to the beginning of the next Test tag. When I use the macro below, I do not get the results I'm looking for and I can't figure it out. I think it has something to do with the hyperlinks I have in the document. When I delete them or make them non hyperlinks, I get the range selection that I need. Can you offer any help? Sub SelectIt() Dim rng As Range Dim SearchRange As Range Dim iTestCharCount As Integer Set rng = ActiveDocument.Range With rng iTestCharCount = rng.Characters.Count .Start = InStr(rng.Text, "[~Test ID=" & 9463 & "~]") - 1 iCurrentTestTag = .Start .End = InStr(.Start + 1, rng.Text, "[~Test ID=") iNextTestTag = .End If iNextTestTag = 0 Then .Start = iCurrentTestTag .MoveEnd Word.WdUnits.wdCharacter, iTestCharCount Else .Start = iCurrentTestTag .End = (iNextTestTag + iCurrentTestTag) - 1 End If .Select '.Delete End With End Sub -----------------DOCUMENT----------------------- [~Exam ID=856~]97-TUT -[~ExamName~] Practice Import [~Vendor~]Microsoft [~ExamVersion~]Internal Version: 1.0.3 [~ExamDescription~]test [~ExamInstructions~] [~ExamResources~]test 'RANGE SHOULD START HERE [~Test ID=9463~] Test for Import [~TestType~]Practice Test [~ItemCount~]Item Count: 0 [~Objective ID=66428~]Here is the house [~ObjSeq~]Objective Sequence: 1 [~SubObjective ID=274124~]Where it all happened [~SubObjSeq~]1 [~SubShow~]False [~Item~] [~ItemType~]Single Answer Multiple Choice [~ItemATID~]70-057.1.1.1 [~ItemText~]You are developing a Web site infrastructure for your Web site, and you must meet the following requirements: The required result is to be able to add VBScript functionality to the Web pages. The first optional result is to have the ability to run scripts on the server for purposes of retrieving database information. The second optional result is to be able to output this information in HTML format so the majority of Web browsers can view this information. The proposed solution is to implement Active Server Pages on a Windows NT Server 4.0 computer that is running Site Server 3.0. What does the proposed solution provide? [~Item~] [~ItemType~]Single Answer Multiple Choice [~ItemATID~]70-057.1.1.2 [~ItemText~] You are developing a Web site infrastructure for your Web site, and you must meet the following requirements: The required result is to be able to add VBScript functionality to the Web pages. The first optional result is to have the ability to run scripts on the server for purposes of retrieving database information. The second optional result is to be able to output this information in HTML format so the majority of Web browsers can view this information. The proposed solution is to implement a COM component. What does the proposed solution provide? [~RemediationText~] COM components allow software to be written in components that perform separate functions. This allows several procedures to call the same components. None of the results are met by implementing a COM component. To meet the results, you should use Active Server Pages. www.yahoo.com www.cnn.com [~ReferenceText~] 1. General Knowledge and Experience - <none> Here is more '<-- THE RANGE IS ENDING RIGHT AROUND HERE www.kaplanit.com www.erert.com www.yahoo.com www.cnn.com 'THIS IS WHERE I NEED TO RANGE TO END [~Test ID=9466~] Flash Card Test import [~TestType~]Flash Card [~ItemCount~]Item Count: 0 ---------------------DOCUMENT END--------------------- Thanks for any help. David Tag: Table formatting code extremely slow Tag: 71837
  - 18
    - macros disabled in protected form I have created a word-2002 form that captures student name, operating system, email address, etc. I want to create a macro that saves the completed form as 'form data' only and saves the file as a normal word document. I will then have the student email both files back to me. I have created a macro using 'recorder' to change tools/option/save to save the file as form data only. To create the macro, I had to disable form protection. When I re-enable form protection, I can not run the macro. How do I avoid this conflict? Thanks, Tag: Table formatting code extremely slow Tag: 71826
  - 19
    - Insert Symbol into table cell How do I insert symbols into a table cell? The follwoing code fails because its not a simple selection. Thanks hals_left With ActiveDocument.Tables(2).Rows(1) .Cells(j).Select Selection.InsertSymbol Font:="Wingdings", CharacterNumber:=-3842, Unicode:=True End With Tag: Table formatting code extremely slow Tag: 71825
  - 20
    - global variables - shared subroutines I have the following problem, I have two modules, that means two macros, in my application and there are some subroutines which are common and I was trying to have them in only one module and to call them by module1.sub_name. These subs change the value of a global variable which has purposely the same name in both modules but I noticed that when I call them by that way the value of the global variables do not change. Does anyone know if I am doing something wrong or why is this happening? It should be another way except of copying the subroutines in both modules, right? Tag: Table formatting code extremely slow Tag: 71824
  - 21
    - How to create a shortcut on my desktop to print a Word document? I would like to create a link on my Mom's desktop that she can click to print her schedule. I'd like to be able to set the path and filename, and all she has to do is click the link and put in how many copies she wants of the Word document, and it will automatically open up word (if needed) and print the document. I'm not sure if its best to do this with a script, a program, or if it can just be done with options in a shortcut link? Tag: Table formatting code extremely slow Tag: 71816
  - 22
    - Merge fields in footers I have a template with a footer with merge fields in it i.e. property address. When other users select this template the merge field populates on the first page only, on any other pages it only brings up the merge field, not the populated field like the first page. In my template under view header/footer the "same as previous" icon is not highlighted. How do i get this footer field to populate on more than the first page? Tag: Table formatting code extremely slow Tag: 71813
  - 23
    - record a macro to open a folder, not a file Dear folks: Is it possible to record, or create, a macro that opens a folder only (Word 2003)? I tried to record all the necessary steps but it didn't allow me to stop recording unless I chose a specific file within the folder. Can anyone please teach me on this? Thank you! Tag: Table formatting code extremely slow Tag: 71810
  - 24
    - Paste Special Macro -- how to place cursor at end of paste? In my paste special macro, I wish that the cursor would appear at the end of the paste rather than at the beginning. The "placement" variant in the PasteSpecial method doesn't seem to do the trick. So, for now, I'm inserting dummy text ("&&") as a work around. I suspect there is a much better way than what I'm doing. Any thoughts? Here's my work-around. Sub paste_special() ' ' paste_special Macro ' Macro recorded 7/27/2005 by Todd E. Marlette ' ' INSERT DUMMY TEXT ("&&") Selection.TypeText Text:="&&" Selection.MoveLeft Unit:=wdCharacter, Count:=2 ' PASTE SPECIAL Selection.Range.PasteSpecial DataType:=wdPasteText ' SEARCH FOR DUMMY TEXT AND THEN DELETE ' TO PLACE CURSOR AT END OF PASTED TEXT Selection.Find.ClearFormatting With Selection.Find .Text = "&&" .Replacement.Text = "" .Forward = True .Wrap = wdFindContinue .Format = False .MatchCase = False .MatchWholeWord = False .MatchWildcards = False .MatchSoundsLike = False .MatchAllWordForms = False End With Selection.Find.Execute Selection.Delete Unit:=wdCharacter, Count:=1 Selection.MoveLeft Unit:=wdCharacter, Count:=1 End Sub -- Message posted via http://www.officekb.com Tag: Table formatting code extremely slow Tag: 71809
  - 25
    - Can VBA count how many macros I have? I have collected quite an assortment of macros over the last 2 years. Is there a VBA method for counting how macros there are, with several modules holding five or more macros? Ed Tag: Table formatting code extremely slow Tag: 71805
- Next
  - 1
    - reference to the rigth instance of Access I need to get a reference to an already open instance of Access if it is running or open it if not. I'm using GetObject. If no other instances of Access are open I have no problem. But I have no guarantee to point to the rigth one if the user has already opened one. I found an half solution with a strange behavior: Set oAccApp = GetObject(MyFileName, "Access.Application") oAccApp.Visible = True works fine (it open a new instance if it is not open or open and "magically" merge it with the old one if already exists) if I don't have a StartUp Form. if I have a StartUp form, I tried to use: Set oAccApp = GetObject(MyFileName, "Access.Application") oAccApp.Visible = True oAccApp.DoCmd.Close acForm, "Welcome Form" But I get a run time error 2455 . If I delete oAccApp.Visible = True I get multiple instances of my database. Why? Any Suggestions? Thanks Lauro Tag: Table formatting code extremely slow Tag: 71804
  - 2
    - error handler with error line number Hi, I have a function in Word-VBA with error handler writing some info to log file. There are strange errors occuring from time to time which I can't trace. It would be very helpful for me to have information about line in which error has occured. Is this possible? For example: sub foo() on error goto ErrorHandler 'some code here exit sub ErrorHandler: ErrNumber = Err.Number ErrDesc = Err.Description LineNumber = ??? AddToLog "ERROR:foo:" & LineNumber & ":" & ErrNumber & " " & ErrDesc 'resume or resume next - doesn't matter now... end sub I don't want to examine my specific function, I just would like to now in general, if it is possible to read line number in which last error occured. Regards, Tomek Tag: Table formatting code extremely slow Tag: 71803
  - 3
    - accessing outlook contact information in word Hi, I'm using Word and Outlook 2003. In previous versions, I was able to use the code: WordBasic.GetAddress, in a Word user form to access the Outlook contacts to choose an address. This code is not recognized by Word/Outlook 2003. Does anyone know the equivalent of the code, WordBasic.GetAddress, for Office 2003? THANKS! -- kurt Tag: Table formatting code extremely slow Tag: 71802
  - 4
    - copy word form field contents into excel spreadsheet Can someone help me with the code to open a word document that is a survey form with 6 form fields. I want to open the document, copy the contents of the form fields (name_txt, email_txt, check1_checkbox, etc) to my excel spreadsheet. I am having my college math students complete a word-form document and want to capture all of the responses into a single worksheet with a row for each students information. Thanks, Dave Was this post helpful to you? Tag: Table formatting code extremely slow Tag: 71798
  - 5
    - problems with code in thisOutlookSession (error 438) Hallo! In Outlook 2002 I've got following code in ThisOutlookSession: Sub RufeBriefSchreibenAuf() AufrufAusWord = True Call BriefSchreiben End Sub In Word 2002 I wrote Sub Test() Dim oOutAppl As Outlook.Application Set oOutAppl = GetObject(, "Outlook.Application") oOutAppl.RufeBriefSchreibenAuf End Sub Error 438 apears. What's wrong? Thanks and regards Heike Pertzel / DATA 5 GmbH Tag: Table formatting code extremely slow Tag: 71785
  - 6
    - start Outlook 2002 via Word 2002 macro Hallo! I would like to check in a Word 2002 macro wether Outlook 2002 is running and if not to start it. I've tried a lot of code I've found via internet but nothing worked correctly. Has somebody any hint for me? Thanks and regards Heike Pertzel / DATA 5 GmbH Tag: Table formatting code extremely slow Tag: 71784
  - 7
    - Hidden Text Using Checkbox Hello, I'm trying to write a macro that will toggle text in a bookmark between hidden and unhidden using a checkbox. I still need the text visible on screen, but I just don't want the text to print. I managed to make it work one time, but something must have gone wrong in my code. Does anyone have a better suggestion or can spot what I'm doing wrong. My macro is below. Sub mcr1A() ActiveDocument.Unprotect Password:="" Set vCheck1 = ActiveDocument.FormFields("chk1A").Range If vCheck1 = False Then ActiveDocument.Bookmarks("bk1A").Select With Selection.Font .Hidden = True End With End If ActiveDocument.Protect Password:="", NoReset:=True, Type:= _ wdAllowOnlyFormFields End Sub Tag: Table formatting code extremely slow Tag: 71780
  - 8
    - make form automation recognize the boolean state of a check box When automating a form, it would be helpful if I could make the exit macro of a check box dependent on the boolean state of that check box. It would be even better if I could enter a command such as "if check1=1 then check2=enabled" or something similar. The current method of using macros is cumbersome in many situations. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/office/community/en-us/default.mspx?mid=f5a5febb-b019-46e3-9fe3-1c6f831509d7&dg=microsoft.public.word.vba.general Tag: Table formatting code extremely slow Tag: 71774
  - 9
    - HTTP Posting Document I am new to VBA and Word macros in general and have a question. Is it possible to HTTP Post the ActiveDocument to a URL after it has been closed or saved? Perhaps in the autoClose method? Since I am new to Word automation I am having a hard time finding the answer from the Document object docs. I have found examples of how to POST arbitrary data from the Document, but not the entire binary Document itself. Any help would be appreciated. Cheers! -- Jeff Tag: Table formatting code extremely slow Tag: 71773
  - 10
    - Fractions and Autoformatting Sometimes my program will automatically shrink the fractions. I have gone into the tools menu and checked and it should occur but it does not. Is there a way for me to customize the fractions so they appear like the others that do shrink? Please and Thank-you Tag: Table formatting code extremely slow Tag: 71770
  - 11
    - Search for a variable array of numbers in word I am looking at writing a macro in word vba that searches the word document for an array of numeric characters with a fixed length of 14 characters but the characters can be anything numeric ie 0-9. Can anyone help Tag: Table formatting code extremely slow Tag: 71769
  - 12
    - Select from insertion point to text string, and then do it all over again I am creating 850 static HTML Web pages by using Mail Merge in Microsoft Word. (The static Web pages are then compiled into one metafile.) After I merge the Web page data into Word, I have one, long document that is separated by 850 section marks. I have VBA code that allows me to cut a selection from the one, long document and to paste the selection into individual .htm files. I have not figured out, however, how to define the 850 separate selections in the one, long document. I also need help returning to the one, long document and moving the the next section in it. Specifically, I need VBA code to do the following things: 1. To use the current insertion point as the beginning of the selection or range. 2. To extend the selection or range so that it includes everything up to the next occurrence of the text string "</html>". 3. To call the cut-and-paste VBA sub that I already have. (This VBA sub creates, saves, and closes the individual file.) 4. To return to the one, long document as the ActiveDocument. 5. To move the insertion point to the beginning of the next section. 6. To repeat this action as long as another "</html>" text string exists in the one, long document. Thank you, --K Tag: Table formatting code extremely slow Tag: 71768
  - 13
    - Letter printing I work with an application that is used by several (50) users. As part of their work they print letters to send to clients. A parameter is passed to request the number of copies of each letter to print on the network printer. The problem is 90% of the time the correct number of letters is printed, but 10% of the time some letters would not print or the number would be incorrect. I put a log file to check what is being sent to the printer and the parameters are always correct, but I ,sometimes get the wrong number of copies. Any help will be appreciated. The application is VB.net and we are using Office 2003. Tag: Table formatting code extremely slow Tag: 71765
  - 14
    - Formfields in a table Hello, Using VBA with Word 2002, I'm using the code below to add a calculating formfield to a table. Strangely it only works some of the time depending on the range value. When the range is "Cell(3, 1).Range" is works fine, but when the range is "Cell(3, 4).Range" the code stops running without an error. Has anyone every seen this before or have a work around. This is part of a larger sub. "doc" is the active document. With doc.FormFields.Add(Range:=.Cell(3, 4).Range, Type:=wdFieldFormTextInput) .TextInput.EditType Type:=wdCalculationText, _ Default:="=sum(above)", _ Format:="0.00", _ Enabled:=False .Range.Fields.Update End With Thanks Tag: Table formatting code extremely slow Tag: 71761
  - 15
    - Customizing the toolbar with macros Hi, Thank you for your help. I'm on Word 03. I have created a toolbar with menus and submenus. Wondering if you can use icons/pictures to identify menus or submenus the same way you use them to identify features, macros, etc. on the toolbars. It won't let me but I wanted to verify that it can't be done. Thanks much. Tag: Table formatting code extremely slow Tag: 71760
  - 16
    - Normal.dot gets renamed Hi there, Any ideas why [normal.dot] gets renamed to [normal.dot.old] when an instance of word is called from another application. Situation: Powerbuilder application calls MS Word as automation server with general, out-of-the-books automation code. Extra info: OS: Windows XP MS Office XP UK with a Dutch language pack. Word startup folder (in this enterprise setting) located in user's profile. Problem seems to occur with a virgin/clean user's profile (in other words: first enterprise login session or first MS Office/Word session ... MS Office FirstRun entry in registry = true) We've noticed that the problem occurs once: during first MS Word session. Once the normal.dot's owner file (~$) has been properly deleted (by MS Word after this first session) the problem seems to disappear. What is forcing MS Word to rename [normal.dot] to [normal.dot.old]?? or What is set during this first MS Word session in the user's profile? (can't see anything being set in user's profile ...) ------------------------------------- Krgrds, Perry System parameters: POS: WinXP x64 MSO: MSOffice System DEV: VS7 (dotnet) ------------------------------------- Tag: Table formatting code extremely slow Tag: 71758
  - 17
    - VBA error 4605 accessing SaveInterval property while Find dialog o I have a macro that wakes up periodically and checks the SaveInterval property. When there is a Find/Replace dialog open, it gets error 4605 and is unable to obtain the value of the property. Is there any way around this? In other words, any way to obtain the value of SaveInterval or other Word options while the Find/Replace dialog is open? Thanks! Tag: Table formatting code extremely slow Tag: 71755
  - 18
    - Warning Word6.0/95 converter Hello, I have a warning when a macro is saving my word document with the word6.0/95 converter. How could I disable this warning? Thanks for answers Regards Maurice Tag: Table formatting code extremely slow Tag: 71754
  - 19
    - Display a message box I just want to display a simple message box, how do I do that? I tried searching for Option Box, Message Box, everything I could think of and only get something about dialog boxes, none of which have a message box. Thanks for you rhelp. Tag: Table formatting code extremely slow Tag: 71749
  - 20
    - How do I enable a macro I recorded a macro in word. When I run it, the pop-up message tells me the macro is not enabled. I have also come out of word and tried again. Can anyone tell me how to enable the macro? Tag: Table formatting code extremely slow Tag: 71747
  - 21
    - Unsafe ActiveX Initialization Hello, I use an ActiveX in a word document (InkPicture), and I have a warning about "unsafe activeX". How can I hide this warning? I tried to activate the "Unsafe ActiveX Initialization" to the value "Initialize using control defaults" in the Security Settings of Administrative Templates, but with no result. Thanks for answers Regards Maurice Tag: Table formatting code extremely slow Tag: 71746
  - 22
    - Copy Paste Special Challenge Is it possible to copy a word document page but leave the first 3 space behind on every line for the whole document I need to do this for over 3000 pages so do not want to by line by line I am trying to achieve: 001 dsfdsfsd 002 sdfdsfsdf 003 sdfdsfsdf to becomes dsfdsfsd sdfdsfsdf sdfdsfsdf is this possible Many thanks Marcus Marcus Tag: Table formatting code extremely slow Tag: 71742
  - 23
    - Including mail merge filtering in a macro in Word I am currently using Merge to Directory in Word 2003 to pick up details of our staff vacancies from an Excel 2003 spreadsheet and place them in an HTML-ready document. To date, I have been filtering for each division and merging to the relevant document manually. I want to create a macro to do them all automatically but, when I record a macro to do so, it does not change the filtering of the source data and merely produces identical output when I run it, even though doing it manually produces 4 different documents. How do I include the filtering instructions to get output relevant to the selected division? Tag: Table formatting code extremely slow Tag: 71741
  - 24
    - How can I print a letter for each record in my mailmerge table? I am trying to rewrite some code from word.basic to use word.application b/c some of it is not working in XP. I have had some luck with another program but this one is not working properly. It is only printing a letter for the first record in the table instead of a letter for each record in the table. Here is most of the code. Does anyone see something that I am missing?? Thank you. ***** oDoc = oWord.Documents.Open("test.doc") oDoc.MailMerge.MainDocumentType = 0 oDoc.MailMerge.OpenDataSource; (dsname,wformat,wconfirmconv,wreadonly,wlinktosource,; waddtofilelist,wpassworddoc,wpasswordtemp,wrevert,; wprotectdoc,wprotecttemp,wconn,wsqlstatement) oWord.Documents(1).Activate oWord.Printout() oDoc.Close ****** Tag: Table formatting code extremely slow Tag: 71740
  - 25
    - Trim/Split Filename and insert as text field Hi there, hopefully you guys guide me... Im not familiar with VB. I want to add the filename of a special format in the footer of a word doc, automatically everytime I save the doc. This is what I want in detail: 1. When file gets saved - set file name (document property) to the name of the file, trimmed down to the characters before the first underscore (_). E.g. Filename is "myfile_sometxt.doc" -> will get "myfile" 2. Automatically set the filename variable (trimmed down in step 1) into the footer of the document. Any help would be reaaaally appreciated. Tank you! reiner PS: This is what I've done so far... Macro to get the trimmed down filename: Sub InsertFnameOnly() Dim fname, fname2 As String ActiveDocument.Save fname2 = Selection.Document.Name fname = Left(fname2, (InStr(fname2, "_") - 1)) Selection.TypeText fname End Sub Problems: - how to set the filename in document properties? - how to paste the trimmed filename into the footer? - how to do this automatically (ie without the need of explicitely execute any macro)? Tag: Table formatting code extremely slow Tag: 71730

I have some code that develops tables in excel and then pastes them into a
Word document. There may be as many as 150 tables, all identical but for the
data values.

After pasting them into Word, I execute a Word macro that loops through the
tables in the document and for each of those I have just pasted in, executes
numerous formatting commands. As each subsequent table is processed, the
code gets slower and slower.

Why is this and is there anything I can do? I have turned off screen
updating, but to no avail.

Top

Re: Table formatting code extremely slow by Jay

Jay
Fri Jul 29 19:35:58 CDT 2005

On Fri, 29 Jul 2005 13:42:06 -0700, Bill Sturdevant
<BillSturdevant@discussions.microsoft.com> wrote:

>I have some code that develops tables in excel and then pastes them into a
>Word document. There may be as many as 150 tables, all identical but for the
>data values.
>
>After pasting them into Word, I execute a Word macro that loops through the
>tables in the document and for each of those I have just pasted in, executes
>numerous formatting commands. As each subsequent table is processed, the
>code gets slower and slower.
>
>Why is this and is there anything I can do? I have turned off screen
>updating, but to no avail.

Hi Bill,

See http://www.word.mvps.org/FAQs/TblsFldsFms/FastTables.htm for some
tips.

--
Regards,
Jay Freedman
Microsoft Word MVP FAQ: http://word.mvps.org

Top