Loopin through files in a directory

Tutorials Win: Microsoft Windows Forum

- Previous
  - 1
    - Print to selected port, instead of selected printer? Each of our departments have a different label printer, but they are all set up on lpt3. We have a label macro that is used by these departments and we would like to have that macro automatically print to lpt3. Is there a way to set the activeprinter to the lpt3 port without using the printer name? Tag: Loopin through files in a directory Tag: 112030
  - 2
    - Getting Spell Check to work in Text Form Fields Hi, I have a form that includes many text form fields in which people fill in with a lot of text...how do I tell the users who fill in the form with text to run the spell checker to check for spelling errors on what they typed within those form fields? Thank you Craig Tag: Loopin through files in a directory Tag: 112020
  - 3
    - WildCard Hi. I have a problem with wildcard. I use Ms Word 2003 and use to Find and replace dialog. I have current text: text [[ text [[ name [ text ]] text ]] text I want to find this [[ text [[ name [ text ]] text ]] I use wildcard and this \[\[*\]\] but Word find this [[ name [ text ]] Plecae help me how I can find [[ text [[ name [ text ]] text ]] thank you Tag: Loopin through files in a directory Tag: 112017
  - 4
    - Word 2007 should allow floating toolbars w/ custom text & icons Word 2007 is an absolute disappointment for this power user. You have removed the most useful tools for customization: (a) floating toolbars, and (b) fully customizable icons. Here are two other people whose feelings are nearly identical to mine: http://www.tutorials-win.com/WordDoc/Safely-Uninstall/ "I like Word 2007 not. MY productivity has crashed. My clients expect quick turnaround on their work, but operations now take me twice as long." "Trying to use it is eating into my time with my family. I have to make two or more mouse clicks to attain functios I used to with a single click. Ribbons disappear when I need them, just because I move the cursor outside some region in the document. I cannot create custom toolbars to remain in sight at all times. I can't insert formatting and other functions into the toolbars in a logical position. I cannot dock toolbars to the side or the bottom, or have them float I am forced to add operations to this "quick access" toolbar...which now holds everything possible because I need the operations handy. I even bought the addin tool to give me back my menus and such, but my ability to keep my work on pace has been eroded considerably." http://www.awomantoldme.com/women/how-to/29510935/cutom-toolbars-in-2007.aspx "I just got Office 2007 and I want to cry. I used to have several custom toolbars for my Macros (about 30 macros on 3 different toolbars). Now I only have the Quick Access toolbar and there is no way to tell which macro is which without hovering over the button. On the toolbar, I could use text, but that doesn't seem to be an option now. Plus, I don't want to have to put all 30 macros on the Quick Access Toolbar. Is there anything I am missing here?" ---------------- 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=545cbb3f-3c98-43d2-97c8-abeeaa4f9be0&dg=microsoft.public.word.vba.general Tag: Loopin through files in a directory Tag: 112015
  - 5
    - Finding for lowered or raised character Hi, I am trying to find a raised character in Word. I have the following code: Dim MWord As Word.Application With MWord.Selection.Find .Text = "" .Font.Position = 5 End With This code works fine but if the value I used for ".Font.Position" is a decimal like below: .Font.Position = 0.5 , it cannot find what I am looking for.Was this a bug or was I missing something? If I manually searched for the raised character using the Find and Repalce dialog box, it can actually find the character whether it is a decimal or a non-decimal. The info in the dialog box has: "Format: Raised by 0.5 pt." but when done programmatically, it wasn't found. Please enlighten me. Thanks. Tag: Loopin through files in a directory Tag: 112013
  - 6
    - First page with company logo, bookmarks, other pages only bookmarks I have a template which my program adjusts via vba for the various companies that use it. I need to have a first page with company logo followed by data which is inserted at bookmarks. Later pages would repeat only the inserted data at the top of the page. I'm not sure how to do this. Seems like the company logo etc and the data that's inserted at bookmarks must be in the header, but how to not repeat the company logo? Before the doc is delivered to users as a finished product the dot that contains the custom code is defreferenced, so I can't use any vba tricks to show or hide in the final doc (at least that's what I understand). Currently the header with company logo etc repeats for every page. The bookmarks and the data that gets inserted into them are immediately below the header in the body of the doc and show only on the first page. I need the data that's inserted at the bookmarks to repeat at the head of every page, but no the company logo etc. I know there is a page setup option for 'different first page' but I'm not sure what it does, I'll be reading up on that. Tag: Loopin through files in a directory Tag: 112004
  - 7
    - Client receives blank word documents from me This may have been covered before, but please help. One of my clients works from a mac. I have a pc and a mac. She's using office 2008, I'm using office 2003 on my pc and 2004 on my mac. Every word document I send her is blank - regardless of what computer I'm using or what version of word. I don't have this problem with any of my other clients and she doesn't have this problem with anyone else who attaches word docs to emails. She can open rtf files from me, but if I need to track changes, she can't see them in rtf. To make this even more mysterious, I can open all of the word docs she sends me and see her tracked changes - on both of my computers.... Anyone know what the heck is going on? Many thanks in advance if someone can help me solve this very strange and annoying problem! Susan Tag: Loopin through files in a directory Tag: 111999
  - 8
    - Printing Doc Sections to PDF Hi, I'm using the following macro to print a mailmerged document's sections to PDF Files. How do I call a text value from each section, e.g. the 65th word (the last word on the fifth row of the table) and depending whether i = an Odd or Even number call the document "Report" or "Appendix A" respectively? So that the filename is something like "11125 Report.PDF", or "11125 Appendix A.PDF" Sub PrintSections() Dim i As Long For i = 1 To ActiveDocument.Sections.Count ActiveDocument.PrintOut Range:=wdPrintFromTo, From:="s" & i, To:="s" & i, _ OutputFileName:=(i & ".jpg") Next i End Sub Thank you DDawson Tag: Loopin through files in a directory Tag: 111997
  - 9
    - add checkbox to table programatically Any coding out there that would automatically add checkboxes to a table field if a new line is created? I have a table that has checkboxes in 3 fields. If the user is on the last line of the table and tabs, a new line is added as is the way with a Word table. What I want to do is be abel to have the checkboxes added automaticallyt. TIA, -- Cyberwolf Finder of Paths, Hunter of Prey Ghost of the Night, Shadow of Day The Wolf Tag: Loopin through files in a directory Tag: 111994
  - 10
    - Creating a directory from within Word VBA Hi all, I'm creating a little VBA script within Ms Word, wanting the script to change directory before writing a file, using the ChangeFileOpenDirectory method. It works fine. But what if the directory does not exist? Then I want the script to create it. Can you please tell me how I make it do so? Thank you very much in advance. Jo Tag: Loopin through files in a directory Tag: 111991
  - 11
    - Is there any way to convert table from character graphics to normal There is the table made by from character graphics (sample of the document: http://wordexpert.ru/wp-content/uploads/_0/temp_table.doc). Is there any way to convert this pseudo-table to normal table (for Word)? Thank you. Tag: Loopin through files in a directory Tag: 111990
  - 12
    - =?Utf-8?Q?=E2=80=9CFormatting_..._Too_Complex_...=E2=80=9D?= Iâ??m developing a macro which takes information from an active document and opens two new documents and modifies the data from the active document and places the modified information into the two new documents. Everything seems to work fine until I start working with larger files. At that point I received a Microsoft Word msgbox message saying: â??The formatting in this document is too complex. Please full save the document now.â?? And its has an â??OKâ?? button. (And it wouldn't let me save either document.) I assume that Iâ??m running up against a memory problem, the larger the file, the more memory it takes, yes? Will saving these documents while the macro is running help with the memory problem? How can I find out when I need to save these documents? And what names should I save them as? (I was going to leave that to the user to decide after the macro was run.) And what is â??full saveâ??? Any help will be greatly appreciated, Iâ??m way over my head on this. (I'm using Word 2000.) Steven Craig Miller New Lenox, IL (USA) Tag: Loopin through files in a directory Tag: 111989
  - 13
    - how to track which section it's at Hi, I have a question i need to ask of you in regards to word 03. In the report word document, I have a button called "insert picture". What it does is it will bring up the insert picture windows dialog box and then prompt user for the text message for the picture. for example, somewhere in the word report, we have something like as follows Section 2. Light Bulb Prices some texts ........................ picture Figure 2.1 List of Light Bulb prices some texts ........................ The number "2" in the Figure comes from the Section number. If the Section is 3, then it should show Figure 3.1 Section 2 - this section is generated by Bullets and Numbering. My question here is how do i know which Section it is now at? I have the following code but it gives the wrong answer. The answer should be 2 but it says 8 (which i think, is the page number) Sub InsertPicture() Dim srange As Range Dim ssection As Section Dim i As Long i = Selection.Information(wdActiveEndSectionNumber) Set srange = Selection.Sections(1).Range srange.Collapse wdCollapseEnd Set srange = ActiveDocument.Sections(i + 1).Range srange.Collapse wdCollapseStart Selection.TypeParagraph Selection.ParagraphFormat.Alignment = wdAlignParagraphCenter Dialogs(wdDialogInsertPicture).Show Selection.TypeParagraph Selection.TypeText ("Figure " & srange.Information(wdActiveEndSectionNumber) & "." & pictureCounter & " - " & pictureText) Selection.TypeParagraph Selection.TypeParagraph Selection.ParagraphFormat.Alignment = wdAlignParagraphLeft End Sub Thank you in advance Tag: Loopin through files in a directory Tag: 111985
  - 14
    - Help - Find And Replace - one word at a time 'Hi experts, I need your help please! I have written a number of find and replace' macros in Word, but I need one to interact with me and ask me every time whether or not I wish to replace the word that has been found. 1. First, I want to run thru a word document and for every instance of "his" ask me if I want to replace it with "her". Preferably the normal "Find and Replace dialog box should open so I could just click on "Replace" or "Find Next", but I can't work out how to make the box appear each time the macro finds "his". 2. Also it would be nice if the dialog box were out of the way so I could see the sentence in question. (but this isn't critical.) 3. Then I want to expand the macro to include a list of other words to run the same steps - eg "him" to be replaced sometimes with "her", "mine" with "ours" etc. Any ideas, anyone, please? Tag: Loopin through files in a directory Tag: 111977
  - 15
    - Help with a teaching assignment needed Hi, Hope that somebody can help me with the following: I need a macro to create a cloze (or fill-in the gaps) assignment for my language class. I have a pre-formatted documents with the following structure: <heading 1> <heading 2> <story 1> <heading 1> <heading 2> <story 2> Now, each story has some words or phrases marked with, say, character style â??InlineVocabularyâ??. I have to: 1. select all these words and phrases 2. move them to the end of the <story 1> 3. format them as a list, style â??WordsToInsertâ?? 4. sort the list 5. convert the list to two columns 6. remove these words and phrases from the story 1, substituting them by â??1 _____â?? element 7. do the same to the second story, the third story, etc. This should look something like this: 1.1 CALLING TECH SUPPORT I recently (1). _________ for a new (2). _________ for my office, using (3). _________. 1. DSL 2. ISP 3. Singed up Actually, I have a macro, but it just doesnâ??t work as expected and something is wrong with the sorting part: Sub Vocabulary() ' ' AutoExit.MAIN Macro ' ' Dim rDcm As Range Dim LCnt As Long Set rDcm = ActiveDocument.Range rDcm.InsertAfter vbCrLf With rDcm.Find .Style = "InlineVocabulary" While .Execute rDcm.Select ' for testing ActiveDocument.Range.InsertAfter rDcm.Text & vbCrLf ActiveDocument.Paragraphs.Last.Previous.Range.Style = "WordsToInsert" Wend End With Set rDcm = ActiveDocument.Range 'With rDcm.Find ' .Style = "WordsToInsert" ' If .Execute Then ' rDcm.Select ' Selection.End = ActiveDocument.Range.End - 1 ' Selection.Sort ' End If 'End With Set rDcm = ActiveDocument.Range With rDcm.Find .Style = "InlineVocabulary" While .Execute LCnt = LCnt + 1 rDcm.Select ' for testing rDcm.Text = "(" & CStr(LCnt) & ") _________" rDcm.Collapse Direction:=wdCollapseEnd Wend End With End Sub Thanks in advance, Arthur N Tag: Loopin through files in a directory Tag: 111972
  - 16
    - is it possiable text on the photo at all?? I actually have my wedding invitation i can bring it up but for some reason i cant text the wedding info on it .please help i have 12 weeks till my wedding. Thanks a Million Tag: Loopin through files in a directory Tag: 111967
  - 17
    - How to do copy-and-paste easily between a userform and a blank Word Hi, I have created a userform which takes input of information. When I move the mouse out of the userform and click on another Word document to copy some information, it forbids me to do so. I can't copy any information on that Word document which I want to paste to the userform. May I ask how I can switch to another Word document from a userform, copy information from there and paste it to the userfom conveniently? Thank you. Mike Tag: Loopin through files in a directory Tag: 111965
  - 18
    - HyperLink editing in Word VBA - Hyperlinks.Item(Index) value not r Hello; First my purpose.....to help a friend with an office automation problem (see other posts I have made) with updating the text that is displayed in hyperlinks. It may be that using some other field or tag may work better..opinions and solutions please... NOTE: Some of the below code is from other posts/contributors in this forum (Thank You macropod!). The problem is in legal pleading type pages, there needs to be a table with a column of crossreferences that list the page and linenumber (that may not be possible to do automatically I am finding) or section/heading/numbering. Some type of fields will automatically update on F9 like page number using the PAGE or PAGEREF field code. Same thing with almost everything except line number. In order to exploit if a line number solution is possible I am enumerating the various properties of the fields. At the moment (having never used the office automation but having C#/Ansi C/ and some VB5-6 experience) I am struggling to get the included below code to do the following (it seems pertinent to do, but if I am in error please advise me so): Cycle through all the fields in the ActiveDocument <seems to work> If the field is a hyperlink, display the Text to display, target, address, subaddress, index number. <does not work> Then using the index number, access the hyperlink object from the hyperlinks collection using the index number to get/display the properties. <note coded yet> If the field is a bookmark, display the Title of the bookmark, display the page it is located on, most importantly (I think) is get the character range (ie start and end) so that I might be able to get the linenumber from one of the properties of the range object after setting the range object to the bookmarks start and end position. <note coded yet> For each hyperlink, change the Text to display to the following format:Page/LineNumber or Page,LineNumber <seems to work> Count total of HyperLinks in document Please advise where I have improperly coded or assumed the schema. I am working in Office 2002 SP3. References are: Visual Basic for Applications Microsoft Word 10.0 Object Library OLE Automation Normal Microsoft Office 10.0 Object Library Do I have to Dimension a hyperlink object and then if the field.type is hyperlink, then do hyperlink=field in order to get the Address? Or is the way I am trying below the better approach? Sub HLinkTest() Dim oFld As Field Dim oCount As Integer Dim oRange As Word.Range With ActiveDocument .Range.AutoFormat For Each oRange In .StoryRanges Do For Each oFld In oRange.Fields If oFld.Type = wdFieldHyperlink Then If Left(oFld.Result, 7) = "mailto:" Then MsgBox "oFld.Result= " & oFld.Result, vbOKOnly, "oFld.Result" If Left(oFld.Result, 7) = "mailto:" Then MsgBox "oFld.Kind= " & oFld.Kind, vbOKOnly, "oFld.Kind" If Left(oFld.Result, 7) = "mailto:" Then MsgBox "oFld.Code= " & oFld.Code, vbOKOnly, "oFld.Code" If Left(oFld.Result, 7) = "mailto:" Then MsgBox "oFld.ShowCodes= " & oFld.ShowCodes, vbOKOnly, "oFld.ShowCodes" If Left(oFld.Result, 7) = "mailto:" Then MsgBox "oFld.Index= " & oFld.Index, vbOKOnly, "oFld.Index" If Left(oFld.Result, 7) = "mailto:" Then MsgBox ActiveDocument.Hyperlinks.Item(oFld.Index).Target, vbOKOnly, "ActiveDocument.Hyperlinks.Item(oFld.Index).Target" If Left(oFld.Result, 7) = "mailto:" Then MsgBox ActiveDocument.Hyperlinks.Item(oFld.Index).Address, vbOKOnly, "ActiveDocument.Hyperlinks.Item(oFld.Index).Address" If Left(oFld.Result, 7) = "mailto:" Then MsgBox ActiveDocument.Hyperlinks.Item(oFld.Index).SubAddress, vbOKOnly, "ActiveDocument.Hyperlinks.Item(oFld.Index).SubAddress" If Left(oFld.Result, 7) = "mailto:" Then MsgBox ActiveDocument.Hyperlinks.Item(oFld.Index).TextToDisplay, vbOKOnly, "ActiveDocument.Hyperlinks.Item(oFld.Index).TextToDisplay" oCount = oCount + 1 End If If oFld.Type = wdBookmark Then MsgBox "BM oFld.Result= " & oFld.Result, vbOKOnly, "oFld.Result" End If Next oFld Set oRange = oRange.NextStoryRange Loop Until oRange Is Nothing Next oRange MsgBox "Total Detected HyperLinks=" & oCount End With End Sub Thanks...I feel the programming pain, where is the gain? Rob Tag: Loopin through files in a directory Tag: 111964
  - 19
    - =?ISO-8859-1?Q?Insertion_of_nonbreaking_space_between_a_number_and_?= Dear Experts: I would like to be able to automatically insert a nonbreaking space between all instances of a number and the character set =B0C (ANSII Value of 176) using VBA. For example: 40 =B0C or 5 =B0C I know how to do it using the Find And Replace Dialog Field. But I also would like to be able to do it programmatically. The "Find.Text" Line is enough. Help is appreciated. Thank you very much in advance. Regards, Andreas Tag: Loopin through files in a directory Tag: 111960
  - 20
    - LINEREF ...Where is it? Help, It is easy enough to discover the page number of a bookmark using PAGE or PAGEREF (w/o even programming). If Line Number is turned on for the active document how does one find the line number of the bookmark on a given line? On several proposal documents we must show the page and line reference of the related item. To do this, we place a bookmark attached to the selected text or object, then use the PAGE or PAGEREF field to get the page#, but we have to type the line number in manually......isnt this supposed to be helping us to not crane our necks at a monitor...? Sincerely cross(eyed) Rob Tag: Loopin through files in a directory Tag: 111953
  - 21
    - macro for Office 2007 good afternoon, i'm using Office 2007 on Vista and would like to make a macro for a template. the template uses building blocks (date calander and select from drop down list) in multiple locations. i would like the macro to save using the date that was selected from the calander and the text that was entered into one of the fields (the person's name.) if this was in excel, i could do this because the file name could be referenced via the cell values, i could save the file and email it and leave the template intact. In word, i have no idea where to start... any suggestions, hints or ideas? thank you, jat Tag: Loopin through files in a directory Tag: 111947
  - 22
    - Extract Address from existing document I've been trying to update some old WordBasic code (written by someone else) that no longer works in Word 2003. We have an label macro for our users that lets the user pick what type of mailing label they need (USPS, UPS, FedEx, etc.) then asks if they want to hand input the address, pull an address from our database, or pull the address from an open document. While the rest of the code has been updated for some time, this piece worked, so we just left it alone (the "if it's isn't broke, don't fix it" attitude!) I've tried several things using the Wordbasic conversion tables in Word, but haven't had any luck. I'm hoping someone here can help. The code that DID work at one time is: Dim dlg3 As Object: Set dlg3 = WordBasic.DialogRecord.ToolsCreateEnvelope(False) WordBasic.CurValues.ToolsCreateEnvelope dlg3 LabelAddr$ = dlg3.EnvAddress Everything I try comes up with a blank address. I've tried the below code with both showing the dialog box and not showing it, (and I do not want to show it) and either way, LabelAddr$ always comes up blank, even though when it does show the box, the address is in the dialog box. Set myDialog = Dialogs(wdDialogToolsCreateEnvelope) With myDialog .extractaddress = True ' .Show End With LabelAddr$ = myDialog.EnvAddress Anyone have any ideas on how to either convert the WordBasic Code above or how to extract the address from a letter without using the dialog box at all? Tag: Loopin through files in a directory Tag: 111942
  - 23
    - Visual Basic Macro I got MS Word to write a macro for me. It didn't work. The macro should perform the following tasks on a merged document. The document is merged with an Excel spreadsheet and an MS Word template. The fields on the Word document are filled-in with the data from Excel. This part works just fine and creates approximately 3,800 letters! The MS Word macro must: 1. Save each letter in a separate file. a. Pull the control number from each document. b. Save each file as "CB xxx.doc" where xxx is the control number. 2. Advance to the next letter in the file. 3. Repeat steps (1) and (2). This is the code that I have so far. If some one could expand on the hard coded line: RESEARCH_BEGINNING_DATE = "101" The number 101 should be a variable not a constant. Roger Sub Macro2() ' ' Macro2 Macro ' Macro recorded 3/28/2008 by Customer Services ' Set myRange = ActiveDocument.Range(Start:=0, End:=1) RESEARCH_BEGINNING_DATE = "101" FileName = "Charge Back" & RESEARCH_BEGINNING_DATE & ".doc" ActiveDocument.SaveAs FileName, FileFormat:= _ wdFormatDocument, LockComments:=False, Password:="", AddToRecentFiles:= _ True, WritePassword:="", ReadOnlyRecommended:=False, EmbedTrueTypeFonts:= _ False, SaveNativePictureFormat:=False, SaveFormsData:=False, _ SaveAsAOCELetter:=False Selection.MoveDown Unit:=wdScreen, Count:=4 Selection.HomeKey Unit:=wdLine End Sub -- Roger Tag: Loopin through files in a directory Tag: 111941
  - 24
    - Can't access Bookmark I am currently working in Words Version 2003. The macro works find. When someone else try to use it with Version 2000, it comes with "Run time error 4605 - This method or property is not available because the object refers to a protected area of the document." It seems to hang up on this: Num = ActiveDocument.Bookmarks("Text24").Range.Text The document is protected and is a form. How can I by pass this to allow it to work in Version 2000? Tag: Loopin through files in a directory Tag: 111938
  - 25
    - Question about Using a Macro from another Template I have a question about being able to use a macro which is located in another Template. (Chess players use text files called PGN files to store and retrieve chess games and chess problems. You can read/understand â??text fileâ?? every place I write â??PGN file.â??) Iâ??ve been: (1) opening a PGN file using Word (1st Word File); (2) opening a new Word file based on my template (2nd Word file); (3) Cutting and pasting the PGN information from the 1st file into the 2nd; (4) running my macro which is located in my template; (5) the macro opens a new document based on my template (a 3rd Word file) and transforms the PGN information in the active document (2nd Word file) into this newly opened document (3rd Word file). I could save time if I could open a text file in Word using my template. But I donâ??t see any option for doing that. Or I could save time if I could use my macro (which is located in my new template) from any other Word file. The only solution which I can come up with is that I could copy my macro from my template into the Normal template. That would cutout steps 2 & 3 (as listed above). Is there any other way of running a macro which is located in another template? Or am I better off simply copying it into the Normal template? Steven Craig Miller New Lenox, IL (USA) Tag: Loopin through files in a directory Tag: 111937
- Next
  - 1
    - Spellcheck only certain form fields in a protected doc Is it possible to spellcheck only certain form fields in a protected Word doc? Below is the Macro I have so far but it runs through all the form fields including the check boxes and I have a 40 page doc which takes almost 5 mins for the spellchecker to run. I have tried to use the macro in the 'on exit' properties but that still doesn't seem to work. Any ideas would be greatly appreciated. ~Thanks, Roxy Sub SpellCheckForm() Dim i As Integer Dim bProtected As Boolean 'Unprotect the file If ActiveDocument.ProtectionType <> wdNoProtection Then bProtected = True ActiveDocument.Unprotect Password:="colleen" End If 'check formfield for spelling For i = 1 To ActiveDocument.FormFields.Count ActiveDocument.FormFields(i).Select #If VBA6 Then Selection.NoProofing = False #End If Selection.LanguageID = wdEnglishUS Selection.Range.CheckSpelling Next 'Reprotect the document. If bProtected = True Then ActiveDocument.Protect _ Type:=wdAllowOnlyFormFields, NoReset:=True, Password:="colleen" End If End Sub Tag: Loopin through files in a directory Tag: 111935
  - 2
    - howto save building blocks.dotx if folder redirection Word 2007 howto save building blocks.dotx if folder redirection, your %appdata% is on a network drive? Word just says that the file is write protected! Tag: Loopin through files in a directory Tag: 111933
  - 3
    - Word 2007 ribbon dynamically adjust at startup Hi, in Word 2007 there is a global template "TEST.DOTM". Within the ribbon of this template I've created the new tab "Test" wich contains 5 button. Depending on user setting, some of these button should be visible and some should not - after TEST.DOTM is loaded as global template. Here is the code: XML code: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui" onLoad="CallbackOnRibbonLoad"> <ribbon startFromScratch="false"> <tabs> <tab id="MyTab" label="Test"> <group id="MyGroup" label="Testgroup"> <buttonGroup id="MyButtonGroup"> <button id="Button1" imageMso="_1" getVisible="CallbackGetVisible" tag="Macro1" /> <button id="Button2" imageMso="_2" getVisible="CallbackGetVisible" tag="Macro2" /> <button id="Button3" imageMso="_3" getVisible="CallbackGetVisible" tag="Macro3" /> <button id="Button4" imageMso="_4" getVisible="CallbackGetVisible" tag="Macro4" /> <button id="Button5" imageMso="_5" getVisible="CallbackGetVisible" tag="Macro5" /> </buttonGroup> </group> </tab> </tabs> </ribbon> </customUI> VBA code: Public gobjRibbon As IRibbonUI Public gbooRibbonButtonVisible As Boolean 'Global variable gobjRibbon intitialize at startup: Public Sub CallbackOnRibbonLoad(ribbon As IRibbonUI) Set gobjRibbon = ribbon gbooRibbonButtonVisible = False 'All button fade out End Sub 'Button visible/not visible: Public Sub CallbackGetVisible(control As IRibbonControl, ByRef visible As Variant) visible = gbooRibbonButtonVisible End Sub Public Sub AutoExec() Dim astrAllMacros(5) As String Dim intI As Integer, strX As String astrAllMacros(1) = "Button1" astrAllMacros(2) = "Button2" astrAllMacros(3) = "Button3" astrAllMacros(4) = "Button4" astrAllMacros(5) = "Button5" gbooRibbonButtonVisible = True strX = "10101" 'Only "Button1", "Button3" and "Button5" should be visible For intI = 1 To 5 If Mid(strX, intI, 1) = "1" Then gobjRibbon.InvalidateControl astrAllMacros(intI) Next intI End Sub After that actually only "Button1", "Button3" and "Button5" should be visible, but there are ALL button visible. Why? I hope someone can help me. Thanks in advance! Axel Tag: Loopin through files in a directory Tag: 111924
  - 4
    - Word fill in form I inherited a Word fill-in form. I was told the yes and no check boxes were not working correctly. Instead of just using the yes, no check boxes, the user wanted the person who fills out the form to only select yes or no. If you select no, yes would be unchecked. I found a macro in the Macros dialog box. Sub MakeCheckBoxesExclusive() ' ' MakeCheckBoxesExclusive Macro ' Dim oField As FormField For Each oField In Selection.Frames(1).Range.FormFields oField.CheckBox.Value = False Next oField Selection.FormFields(1).CheckBox.Value = True End Sub -------------- The problem is there are two fields prior to the yes, no check boxes and when you select yes or no the prior two fields information is removed. The form is setup in a table format. I'm not sure how to fix the VB code. I'm assuming it's the macro causing the problem. Tag: Loopin through files in a directory Tag: 111923
  - 5
    - Delete msoControlPopup and Children Does anyone know the best way to delete a msoControlPopup and all its children which are x levels deep, I've tried deleting the parent, however all the children are still there stored within the Normal.dot file and I cannot seem to find a recursive command. Thanks. Tag: Loopin through files in a directory Tag: 111912
  - 6
    - AppActivate Over the years, I've found AppActivate to be very flaky. Sometimes it works as described. Other times it doesn't. Currently, I'm running Word 2003. I have a Microsoft Office Document Imaging instance open. The document's name is "DIV 1 xxxx.TIFF" (I plan to OCR and save the result). My code: AppActivate "DIV" I get an "invalid procedure" message. I tried appactivating "Microsoft Office Document Imaging" -- or various permutations -- and it still doesn't work. What am I doing wrong? -- JohnTheTemp Tag: Loopin through files in a directory Tag: 111902
  - 7
    - Background instance of Word and Normal.dot Hi all, I am working on an Office add-in for Office 2003 which is used with Excel, PowerPoint, and Word. Of the three applications, I've only encountered this particular issue with Word. What happens is that the add-in will generate the custom menu items that are added and it will work fine...for a while. For some reason, at some point in time, a background, embedded instance of WINWORD.EXE (embedded as in it's parent process is svchost.exe and it's started with the -Embedding switch). What also happens at this time is that the Normal.dot template file is modified. This has the effect of rendering our add-in to not load with the Word application. I've noticed that Outlook 2003, if you choose the option to use Word as your email editor, starts a background instance of WINWORD.EXE when you create a new email. However, I've also observed in my test environment, that when I shutdown Outlook, it does not alter the Normal.dot file and the WINWORD.EXE process that it starts is shut down. Has anyone experienced issue with a background instance of Word which causes the Normal.dot to be modified? Could this be linked to a some anti-virus software? Any insight would be appreciated. Tag: Loopin through files in a directory Tag: 111900
  - 8
    - Closing single word window Hi There I am trying to work out how to close a single word window without closing any other word windows that might be open. I can close the document and I can close all the word windows and I can close the window if there are other word windows open. I have tried the following Me.Application.ActiveWindow.Close Windows("conquest report.doc").Parent.Close SaveChanges:=wdDoNotSaveChanges Windows("A.doc").Application.Quit Non of this code gives me the solution I am looking for. I would really appreciate some assistance. Thanks Tag: Loopin through files in a directory Tag: 111899
  - 9
    - How do I make a document .doc for uploading? I tried "save as". Even thought I had saved it before in the same folder. Would that make a difference? Help. Trying to upload resume. Tag: Loopin through files in a directory Tag: 111894
  - 10
    - Logo in Header of all pages Hi, For printing on paper witch already has the company logo and for e-mailing I use this macro which is triggered manualy. It places the logo in the header of the first page but I would like the logo to be added to the header of all pages. I use Word 2003. Sub logoIneerstePagina() With ActiveDocument .PageSetup.DifferentFirstPageHeaderFooter = True .Sections(1).Headers(wdHeaderFooterFirstPage).Shapes.AddPicture "C:\kanweg\logo copy.gif" With .Sections(1).Headers(wdHeaderFooterFirstPage).Shapes(1) .Height = CentimetersToPoints(3#) .Width = CentimetersToPoints(6) .Left = CentimetersToPoints(10) .Top = CentimetersToPoints(1#) End With End With End Sub Help would be very appreciated. Thanks Jan Tag: Loopin through files in a directory Tag: 111886
  - 11
    - VBA-Find.execute - How do I delete it? Hi, I've created a new document by copying and pasting from other documents. Now, when I am working in it, everything will suddenly disappear. When I select redo, there is a command in there called VBA-Find.execute. If I redo, everyting comes back. When I hit 'CTRL+F', this shows up in the find box: '^?'. While I can work around this, I would perfer not to. Is there some way to get rid of the VBA-Find.execute command that I seem to be invoking by accident about every 15 or 20 minutes? Thanks, Tag: Loopin through files in a directory Tag: 111884
  - 12
    - girls accidentally wetting the bed the powerpuff girls bad mojo jojo http://penis-eenlargement-pill-mobile.careythe.nx.cn/map.html Penis eenlargement pill mobile http://tad-hilgenbrinck-nude.buyzyban.nx.cn/map.html Tad hilgenbrinck nude http://levante-stockings.buywow.nx.cn/map.html Levante stockings http://jake-gylenhaal-free-naked-pictures.withbuy.nx.cn/map.html Jake gylenhaal free naked pictures http://sex-technique-twisting-the-tigers-tail.raybanks.nx.cn/map.html Sex technique twisting the tigers tail http://zanesville-escort.careyphd.nx.cn/map.html Zanesville escort http://jay-cutler-shag-wife.withbuy.nx.cn/map.html Jay cutler shag wife http://israeli-respirators-facial-hair.htmmeter.nx.cn/map.html Israeli respirators facial hair http://transsexaul-teens.metervan.nx.cn/map.html Transsexaul teens http://tag-teamed-soaked-in-cum.aintjive.nx.cn/map.html Tag teamed soaked in cum http://jiffy-lube-coupon-wakefield-ma.withbuy.nx.cn/map.html Jiffy lube coupon wakefield ma http://gettin-fucked-up-mafia.careyfor.nx.cn/map.html Gettin fucked up mafia http://greeley-co-sex-offender-list.buycds.nx.cn/map.html Greeley co sex offender list http://jon-stewart-wife-tracey-mcshane.withbuy.nx.cn/map.html Jon stewart wife tracey mcshane http://big-titty-black-facesitters.eduaint.nx.cn/map.html Big titty black facesitters http://adult-sucking-lollypops-xxx.bankshtm.nx.cn/map.html Adult sucking lollypops xxx http://phat-juciest-ass.deathcnn.nx.cn/map.html Phat juciest ass http://kim-ginny-celebrity.withbuy.nx.cn/map.html Kim ginny celebrity http://king-kamehameha-webcam.withbuy.nx.cn/map.html King kamehameha webcam http://kissing-kyo-tohru.withbuy.nx.cn/map.html Kissing kyo tohru http://matchmaker-xxx-wildlife-studios.withdeath.nx.cn/map.html Matchmaker xxx wildlife studios http://kombucha-and-breast-feeding.withbuy.nx.cn/map.html Kombucha and breast feeding http://late-winslet-topless.withbuy.nx.cn/map.html Late winslet topless http://female-muscle-clips.banksact.nx.cn/map.html Female muscle clips http://lemonparty-fun-anal.withbuy.nx.cn/map.html Lemonparty fun anal http://pink-panther-rubber-stamps.careythe.nx.cn/map.html Pink panther rubber stamps http://playboy-midsummer-night-dream-party.gunsbuy.nx.cn/map.html Playboy midsummer night dream party http://girl-from-g4tv-commercial.mtrdeath.nx.cn/map.html Girl from g4tv commercial http://lesbian-sex-porn-2.withbuy.nx.cn/map.html Lesbian sex porn 2 http://update-hourly-pornstar.banksact.nx.cn/map.html Update hourly pornstar http://saks-hair-and-beauty-covent-garden.downbuy.nx.cn/map.html Saks hair and beauty covent garden http://busty-bea-flora.phpbuy.nx.cn/map.html Busty bea flora http://cameltoe-shaved-zlata.aintjive.nx.cn/map.html Cameltoe shaved zlata http://penis-scab-disease.careyfox.nx.cn/map.html Penis scab disease http://anna-nicole-baby-shocker-tmz-com.pathfrom.nx.cn/map.html Anna nicole baby shocker tmz com http://ltd-betty-jr-girls-snowboard-133.withbuy.nx.cn/map.html Ltd betty jr girls snowboard 133 http://mael-masturbation.meterinc.nx.cn/map.html Mael masturbation http://teen-diaper-sleepovers.frombell.nx.cn/map.html Teen diaper sleepovers http://chubby-checker-never-stopped.buyworld.nx.cn/map.html Chubby checker never stopped http://swinging-party-in-maxwell-texas.htmmeter.nx.cn/map.html Swinging party in maxwell texas the wild girls of mako's, the noth face denali jacket girls, gangsters girls from the roaring twenties, pictures of the gilmore girls hairstyle, the cheetah girls show dates, kick in the groin girls, flapper girls and the 1920s, girls burping the abc's, lyrics to the cheetah girls songs, the spiece girls, lori lansens the girls discussion questions, play the powerpuff girls game, the flapper girls, w h the golden girls dvds, girls death shooting jack-in-the-box cathedral city, calistoga girls day at the spa, soundtrack for the cheetah girls 2, powerpuff girls games on the internet, get out the map indigo girls, the juicy girls phonesex, the girls nexy door, the cheeky girls photos, the hamptons girls preppy, the mighty casey white girls, where do the barlow girls live, what happend to the spice girls, the girls brigade nsw, dream girls the ivie, the lowell girls of the 1800s, lyrics if girls ruled the world, the knack good girls dont, whatever happened to the spice girls, the powerpuff girls movie, the boys girls clubs grand bahama, history of the cheetah girls, the cheeta girls soundtrack, the golden girls sitcoms, the octogon girls, arthur wise the naughty girls, the boys and girls club syracuse, and the colored girls go doot, the girls next door-playboy, girls in the tickle stocks, geeks get the girls mp3, the bad girls club oxygen network, blizz the league girls, the blaker girls, the granite girls and tyler tx, girls geting nailed is the ass, girls peeing in the woods, girls of the hawaiian islands, the cheetah girls history, anna friel the land girls, you tube the powerpuff girls, gunther and the sunshine girls pictures, pics of girls using the restroom, girls freaking in the club, the powerpuff girls anime, the brazilain girls, the hottest barley legal girls fucking, the gilmore girls series finale, outline of mean girls the movie, girls with junk in the trunk, the shins those bold city girls, the cheetah girls soundtracks, meet the bk girls nz, girls rule the inferno 1, the boys and girls herodotus, the gaia girls blog november, the smallest petite teen girls, history of the lowell mill girls, luther vandross and the spice girls, the girls next door kendra wilkinson, the campfire girls music ebook ringtone, andre cymone the girls, girls winnie the pooh crib bedding, the uptown girls losing you, playboy the girls of hooters, powerpuff girls nano of the north, the texting song-the slumber party girls, the cheetah girls i won, raven the cheetah girls, the cheetah girls concert, names of the girls of penthouse, the powerpuff girls blossom, the cheetah girls clothes, do girls chave the pussy, girls at the alamo in 1836, the world's sexiest girls, the powerpuff girls webring, the powerpuff girls sex, landesman the girls next door, tilly and the wall lost girls, the girls from olmo 2, santa barbara ceramics the girls collection, the wb's gilmore girls, girls of the acc 2004 pictures, the idiot hot girls and marketing, arsonists get all the girls merch, mickey gilley don't the girls, the cheetah girls cast, kissonline the girls of kiss, the australian girls choir, girls aloud see the day lyrics, kill the powerpuff girls, consolidated and the yeastie girls, limp bizkit fuck the spice girls, playboy real girls of the oc, the lowell girls of 1821, the cheetah girls 2 torrent download, the girls next dooor, the gilmore girls soundtrack, the saggy bottom girls, girls of the playboy mansion naked, goes out to the girls wyclef, hot nube girls at the beach, girls fucking on the biches, gilmore girls written in the stars, the slumber party girls bubblegum lyrics, girls of the hawaiin island calendar, pictures of the camp confidential girls, kendra of the girls next door, names of the brady girls, elisabeth sladen send in the girls, bubbles from the powerpuff girls, the latest faction for girls, girls doing the splits, girls of the sec playboy pics, girls on the toilet pooping, unto the breach gilmore girls, tales of the abyss naked girls, girls of the big xii pictures, guotes for the girls, girls clothing in the 1920s, girls mating with the beasts dog, spice girls wikipedia the free encyclopedia, gunter and the sunshine girls video, ode to the nice girls, calvin harris all the girls lryics, the cheetah girls cinderella, hairsyles for girls in the 80s, the gilmer girls, deidre gallagher of the johnson girls, the gastineau girls, the girls next door pictoral, naked girls pooping on the toilet, the chuch of dead girls, umami tsunami where the girls are, girls jioning the mile high clib, literotica girls fucking in the hay, grits girls raised in the south, beauty and the geek girls jennylee, seventh season of the gilmore girls, lyrics form the harvey girls, girls of the taj mahal dvd, the glam girls dresses, the girls yoga bookgirl zone, holly the girls next door dress, beautify and the geek girls, girls in the hower, girls kneeing guys in the balls, sporty spice from the spice girls, fhm girls on the couch, lyrics music the colored girls go, the suicide girls first tour soundtrack, viv thomas-the office girls, dark haired girls at the bech, and the colored girls go doo, the most beautiful cg girls, the girls lori lansens, fruit of the loom girls panties, girls peeing on the ground, the girls of wayne's world 2, the truth about hue heffner girls, patterson kiss the girls quotes, gilmore girls the long morrow, girls riding the sybian video, girls raised in the south nude, spice girls leader of the gang, the girls of the voyeurweb, viv thomas film the office girls, the powerpuff girls ending theme, good girls don't the knack, girls of the oc leah luv, pauline murray and the invisible girls, the cheetah girls lyrics strut lyrics, julia alvarez how the garcia girls, castaway and the island girls, gunthar and the sunshine girls, disney channel movie the cheetah girls, the fratellis music video girls lingerae, gunter the sunshine girls golddigger, phat bottom girls make the, zshare girls gone wild the office, the powerpuff girls bad mojo jojo, girls jumping on the trampoline, pictures of the dlt girls, james patterson kiss the girls snake, a boy in the girls lockeroom, the cheetah girls step up zshare, blake hooters girls of the carolinas, spycam in the girls dressing room, lay-out of the girls softball field, gilmore girls ep unto the breach, girls kick peniss in the testicles, dvd the amati girls, maxim the girls from the apprentice, the godfather don's edition hiring girls, the cheetah girls cindrella, the girls harris kelvin, posters of the cheetah girls, girls raised in the south sticker, girls grinding in the club videos, the boys girls club saskatoon, bambara the johnson girls date published, girls scouts of the colonial coast, draw the powerpuff girls, why is the gilmore girls canceled, this ones for the girls martinamcbride, listen to the cheetah girls, girls of the gulch, ver imagines de the cheethan girls, pinup girls of the 1930 s, the power puff girls movie soundtrack, girls pissing running of the bulls, cbs the bachelor 2007 girls, the hairy girls blog thumblogger com, girls from the group xcape, girls getting testicles in the face, drawings of the vargas girls, the rich girls are weeping, girls in the hude, tomik of the bad girls club, the girls of twist's, maxim girls of the apprentice, the best ninn worx girls, girls accidentally wetting the bed, the cw website gilmore girls, fucking indian girls up the arse, all the youg girls love alice, the girls of miss hawiian tropic, jam amp beanz the girls room, the golden girls tv sitcom episodes, the cheetha girls, girls kicking men in the testicles, girls aloud wikipedia the free encyclopedia, kentucky girls of the bluegrass, geeks get the girls lyrics, cheetah sisters by the cheetah girls, twisted sister girls fuck the boys, bridget the girls next door, girls punished with the slipper, abbraxa the girls must pee v, the cheetah girls 2 transcript, virgin girls feel the lash, girls from the movie dhoom2, the lumberyard girls, cw the gilmore girls, girls using the fuckmachine, pretty girls make graves the number, the powerpuff girls playstation, sound of the underground girls aloud, richard clapton girls on the avenue, cast of the chettah girls 2, the busch girls beer, church girls in the buff, the apprentice girls maxim, the campfire girls music ebook, girls masterbating in the shower, nude girls of the acc, henri de montherlant the girls, the gastenau girls, girls of the playboy mansion holly, the girls of mcn, the slumber party girls count down, the girls next door daily niner, girls gone wild at the grail, the prodigy-girls lyrics, girls flashing the camer, the girls placemats, the powerpuff girls porn, the spice girls wannabe, caada girls in the boondocks, laura klinker the fantastic girls club, fuck the girls in lahore, the girls lockeroom, about the cootamundra girls home, quest riot girls rock the boys, the feul girls, the cheetah girls disney channel movie, bloodiest girls in the world, the boys like girls hero heroine, hooters girls carried over the shoulder, the girls of nakedness, not like the other girls rasmus, strut the cheetah girls, the gossip jealous girls, the cheetah girls lyrics strut, the wedding crashers nude girls, the girls next door pictorial, the girls aat, its over by the cheetah girls, the girls next door calender2006, cartoon network the powerpuff girls, girls stripping in the woods, girls of the acc playboy pics, jennifer playboy girls of the acc, girls of the playboy mansion sundtrack, girls getting fucked up the arse, girls of the mercery, bad girls wax the beaver, girls like boys-the great escape, songs by the cheetah girls, the calico girls, the w b gilmore girls, naked girls in the bathtub, the exploited girls shirt, the cheetah girls route 66, the fort wayne derby girls, the gilmore girls cw, stereotypes from the movie mean girls, pissing girls on the stairs, the girls next door season premire, the powerpuff girls grown up, sond from the movie dream girls, the cheetah girls in denver, various artists the cheetah girls, the working girls cassandra peterson, calvin harris-the girls, the cheetah girls 2 movie script, boys girls club-the harbor, cheetah girls endof the line, girls in the lavoratory, the girls boarding school spanking, girls useing the bathroom, free girls striping on the pole, the beautiful girls boudist photos, gilmore girls the morning call online, the king's academy girls uniform, america's motor girls in the 1920s, girls bouncing in the saddle, the cheetah girls amigas cheetahs 2, playboy girls of the sec kentucky, the year in moons campfire girls, the girls next door tube socks, girls pissing in the winter, the laker girls, e's the girls next door, girls of the playboy mansion nude, girls eating the fuck ut pussies, young girls at the piano renoir, the powerpuff girls wallpaper, kendra and the girls next, listen to the cheatah girls songs, posh from the spic girls, disney channel the cheetah girls, girls geting fucked in the shower, the girls next door kendra pictures, the cheeda girls, pics of girls on the beac, girls of the navajo nation, the girls next doors tity, anatomy for artist the usual girls, the girls next door kendra nude, girls grab peniss by the testicles, annie the broadway musical little girls, arsonist get all the girls, the bad girls glub, the sugar cake girls chutney music, the brazilian girls verve, pavarotti and the spice girls, playboy's girls of the pac 10, the cheeky girls gallery, hid the hiccup girls hiccups stop, this one's for the girls chords, who were the grimes girls, karen girls from the typing pool, meaning of the girls name isabella, behind the scenes of gilmore girls, girls of the panty raid, cbs the slumber party girls, the girls of summer billy thorpe, playboy girls of the acc clemson, the chettah girls souindtrack, renoir girls at the piano, picture of the jamaica sunshine girls, singer giorgi and the bad girls, flapper girls from the 1920s, wannabe lyrics by the spice girls, howard stern stomp the bui girls, viv thomas the office girls, girls of the playboy mansion bridjet, prom dresses for the poor girls, the dice k girls fan club, animated pictures of the cheetah girls, girls in the army gaiting fucked, powerpuff girls episode meet the bottles, check the map lyrics indigo girls, for the girls the fratellis, gunther the sunshine girls golddigger, lori larsen the girls, the girls of el rey blanco, girls of revenge of the nerds, pretty girls make graves the smiths, girls gone wild the seized, indigo girls the wood song mp3, hot girls in the nudged, the gingham girls paper dolls, snl skit about the gardening girls, girls kicking men in the balls, girls amp sports for the fans, booksellers the golden girls dvds, girls who laydown on the job, girls of the sec playboy, the powerpuff girls movie soundtrack, the gilden girls, gamespy the girls of paradise cove, sea-gull the girls camp, the power puff girls vhs, pin up girls from the fifties, girls getting the shocker, the olly girls, glamour girls of the silver screen, the sunblock girls, girls in bikinis on the oval, gilmore girls the complete fifth season, sorority girls in the shower, sexiest girls on the planet, the cheetah girls lyrixs, the geeks get the girls mp3, girls of the sec alabama, the amoeba boys powerpuff girls, holly the girls next door centerfold, fhm the girls of myspace, girls in the shower pleasing, girls on droopy the cartoon, pinup girls of the 1940 s, the cutest girls allie cash, girls from the olden times, glamourgirls best girls on the net, unedited the girls next door, girls geting fuck in the ass, girls using the shocker, measurments the girls nextdoor, it's over by the cheetah girls, arsonists get all the girls lyrics, the powerpuff girls doujinshi, life before the flapper girls, all the girls in france diddy, the cheeta girls lyrics, the bicycles two girls from montreal, hotter than the sun girls, welcome to the pep squad girls, the girls next door centerfold, cherish the moment cheetah girls, tribute to the beautyof asian girls, ugliest girls in the world, where are the winkler girls now, soapy girls in the shower, girls kicking boys in the testicles, girls that love the lorf, the cheetah girls naked, flappers girls of the 1920s, the girls next door peter landesman, negima pictures of the girls, the cover girls custom stall curtains, girls in the shower togeather, gilmore girls allusions to the twilight, girls of the taj mahal 3, best incall service meet the girls, the leather girls gay pittsburgh, the ceetah girls lyrics, gilmore girls the third season, gunther and the sunshine girls video, step up by the cheetah girls, 1999 girls of the pac 10, blossom bubbles buttercup the powerpuff girls, the nude usc song girls, girls in the camel clutch, the bacardi girls, origination of the girls name rola, the cheetah girls 2 song lyrics, good girls dont lyrics the knack, the cheetah girls wikipedia, the girls vinyl placemats, the cheetah girls on tutor, gilmore girls the prodigal daughter returns, girls from the bahamas fucking, the beastie boys-girls, whick country has the prettiest girls, you tube the cheeky girls song, penthouse girls of the zodiac, the popsickle girls, girls on the toilet vid, the babysitters club california girls, the fittest girls in the world, the cheeatah girls album lyrics, the powerpuff girls rap, step up by the heetah girls, gloryhole sex xtube, Tag: Loopin through files in a directory Tag: 111877
  - 13
    - How to get some word and characters? Hello. There is TextBox1 (on UserForm) which composed of three-words (russian family name). First word is the surname (e.g. Nabokov), second word - patronymic (e.g. Vladimirovich) and third word - first name (e.g. Vladimir). Thereby we have full russian family name - Vladimir Vladimirovich Nabokov. I need get from it two results of the following types: 1: Nabokov V.V. (surname with initials) 2: Vladimir Vladimirovich (without surname) How to do this? Thank you! Tag: Loopin through files in a directory Tag: 111874
  - 14
    - Word fields set by Dsofile not updating I've got an old asp.net app that populates some custom fields on a word document it generates. These fields are embeded in the text so that the values are inserted into the letter (things like addressee_name etc) and can be seen when the document is opened. To do some maintenance we have moved the app onto a new (virtual) development server but now the text doesn't get updated immediately when the properties are written - yet this does happen on our production system. If you Select All and Update Fields (Ctl-A, F9) the values appear so the properties are being written OK. Does anyone know what I am missing? (The original developer has left the company, hence my confusion). R Tag: Loopin through files in a directory Tag: 111867
  - 15
    - Cross reference a text form field? I have a document and I'm trying to figure out how it was created. I'm not sure it's cross referencing a form field or not. When I open the document there are 2 form fields. When text is added to the fields it auto-populates fields in the header. When I toggle the field codes in the header the code is either REF PON \h \* MERGEFORMAT* or REF LotNo \h \* MERGEFORMAT*. Can someone explain how this works. Thanks, Mickey Tag: Loopin through files in a directory Tag: 111857
  - 16
    - Locking form fields in a protected Word template (Word 2003) I am setting up a performance review form where the supervisor selects a rating from a dropdown and can add comments in a table cell directly below based on the performance criteria. There is a section for the employees responses. Is there a way to programatically lock down the fields in the supervisor section so the employee cannot change any of the comments or ratings? I have section breaks dividing the various inputs into protected and unprotected sections to allow for the use of spell check. Best regards... Lenny Tag: Loopin through files in a directory Tag: 111853
  - 17
    - Sharing templates on a Shared Network Drive Hi, I've read the article "Distributing macros to other users" by Jonathan West. My IT Dept. informs me that we don't use login scripts. They suggested that I save the template to a folder on the shared drive. The folder would be "read only" to the users. Does anyone see a problem with that approach? Thanks, Mickey Tag: Loopin through files in a directory Tag: 111852
  - 18
    - clicking in protected forms: MS knowledge base article ID: 839950 Hello, I inherited a protected template that has a really obnoxious idiosyncrasy related to form fields; I found the idiosyncrasy listed in the MS knowledge base as article ID: 839950. In summary, the user must click or tab from one form field into another form field on a protected document or Word does not run the form field's 'on entry' and 'on exit' macros. Note that in this template the 'on exit' macro does data validation and therefore when the user clicks into some other area of the document the data is not validated at that time (this template uses text and checkbox form fields). Although another form field in the template calls a macro that identifies form fields that have not been validated properly, overall this comes across as a poor design and depending on the user, can be very frustrating/confusing. It has been suggested that we use some type of timer to trigger a validation of the data before the user removes the focus. However, that idea seems to be insufficient, because how do we trigger the timer if the 'on entry' macro was bypassed. Also, it would be tricky to know how long to wait before forcing the data to be validated (assuming that it could even be done, since the user has not necessarily removed focus from the control). After that suggestion, I started thinking about keeping track of the "current" form field with an index counter and validating the data if the counter does not match the selected form field's name (the names all have an imbedded index that can be identified for processing). This idea seems limited becuase if the user leaves several form fields "improperly" how would I know which ones to validate. I've also been looking for some way to capture a click event in the protected non-form field areas, but apparently the click events are always tied to a form field. An obtuse 'solution' that I proposed is to include in the template an explanation of how to enter/exit the form fields 'properly' (obviously not the desired path). Any suggestions would be greatly appreciated! -- James III, Sincere VBA Newbie! Tag: Loopin through files in a directory Tag: 111850
  - 19
    - VBA question Hi everybody, What is the difference between these two codes dim sec as section if sec.Range.Paragraphs(1).Range.Style="..." then and dim sec as section if sec.Range.Paragraphs(1).Style="..." then the first version which is a amll pert of my code sometimes generates error when paragraph marker if off but when I turn on the paragraph marker it works! so I wonder what does that addition .Range do in the code. -- Best regards, Edward Tag: Loopin through files in a directory Tag: 111844
  - 20
    - Resize Find Dialog Box I would like a smaller Find (and Replace) dialog box rather than the standard Word 2003 Find (and Replace). Can anyone tell me how to resize it? Tag: Loopin through files in a directory Tag: 111843
  - 21
    - VBA code won't run I have the following (I found it in another post). I am trying to use it to duplicate pages. When I run it, it just simply goes to a page that already exists and does not dupliate and add pages. Word will only ask me a page to "go to" and won't do anything else. Any ideas? Page1 = InputBox("Please Enter First Page Number") Page2 = InputBox("Please Enter Last Page Number") Count = InputBox("Please Enter Number of times to duplicate") With ActiveDocument.Range .Start = .GoTo(wdGoToPage, wdGoToAbsolute, , Page1).Start .End = .GoTo(wdGoToPage, wdGoToAbsolute, , Page2 + 1).Start .Copy End With With ActiveDocument.Range For i = 1 To Count .Collapse wdCollapseEnd .Paste Next End With Tag: Loopin through files in a directory Tag: 111842
  - 22
    - Formatting via a macro Hi, I have an A3 page that has a single 3 x 3 table as its contents. 5 of the 9 table cells contain Excel charts imported as pictures using a macro built into the source XL workbook. This bit works :-) What I now want to do is record a macro (within Word) that captures the final formatting of each of these pictures (so that I can embed this code into the XL workbook). The problem I have is that as soon as I start to record the macro I can't grab any of the objects :-( I get the pointer with the little cassette icon indicating recording is taking place, but can't actually do anything. If I don't try to record my actions as a macro, there is no problem with doing the formatting on the objects. Any suggestions on how to resolve this would be gratefully recveived. TIA Dave Tag: Loopin through files in a directory Tag: 111831
  - 23
    - Send User Information to SQL Server On Open I have a number of training documents on a server (some may end up in a sharepoint document library) and I need to know when a document is opened and who opened it in an effort to track employee training records. I would like to include some vba code in the documents that sends the document name, the user name, computer name, and the date to a SQL Server database whenever the document is opened. Can anyone help me with getting the username and computer name? I can use all the help I can get. I'm also open to other suggestions on how to handle training records. Thanks, Raul Tag: Loopin through files in a directory Tag: 111830
  - 24
    - Text replacement in Textboxes I thought I'd seen this covered but can't find it now... I have a mass of old docs full of little typing errors like not using the Ã? character but writing A', or double-spces and weird stuff before or after commas, colons and brackets. I've written a chain of text replacement subs that check through the text one after another and put all these things right (from a userform where I have "replace" and "skip" buttons). This works fine but now I've come across a whole load of these docs that contain textboxes too. Lots of them, some used as labels for pictures, some as callouts or comments. How can I run my string of routines for all the textboxes ? -- David M WinXP - Office2003 (Italian) Tag: Loopin through files in a directory Tag: 111828
  - 25
    - Normal.dot Growing in Size I have created a Macro to run at startup, so I have put the template in the Word 2003 startup folder and have named the macro AutoExec, everything is good, but I notice the Normal.dot continiously grows in size at a rapid rate. All the VBA does is create a menu which is defnied as temporary and the second time it runs it checks for the menu and creates it if its not already there. Why would the Normal.dot seem to cache these functions (searching inside the Normal.dot I can find many copies of the menu not the code), and how can I stop this from happening? Thanks in advance. Tag: Loopin through files in a directory Tag: 111822

Hi

I need to open a set of files 1 ant a time process the file by running a
macro (already Written) then move on to the next file in the list can anyone
help i am using word 2003 and 2007

Thanks in advance

Mark Reid

Top

RE: Loopin through files in a directory by ryguy7272

ryguy7272
Tue Apr 01 11:41:02 PDT 2008

http://word.mvps.org/faqs/macrosvba/BatchFR.htm

General Link (permits searching for various resources):
http://word.mvps.org/

Regards,
Ryan--
--
RyGuy

"Mark Reid" wrote:

> Hi
>
> I need to open a set of files 1 ant a time process the file by running a
> macro (already Written) then move on to the next file in the list can anyone
> help i am using word 2003 and 2007
>
> Thanks in advance
>
> Mark Reid
>
>

Top

Re: Loopin through files in a directory by Graham

Graham
Wed Apr 02 01:39:15 PDT 2008

Dim myFile As String
Dim PathToUse As String
Dim myDoc As Document
Dim fDialog As FileDialog
Set fDialog = Application.FileDialog(msoFileDialogFolderPicker)

With fDialog
.Title = "Select Folder containing the documents to be modifed and click
OK"
.AllowMultiSelect = False
.InitialView = msoFileDialogViewList
If .Show <> -1 Then
MsgBox "Cancelled By User"
Exit Sub
End If
PathToUse = fDialog.SelectedItems.Item(1)
If Right(PathToUse, 1) <> "\" Then PathToUse = PathToUse + "\"
End With

If Documents.Count > 0 Then
Documents.Close SaveChanges:=wdPromptToSaveChanges
End If
myFile = Dir$(PathToUse & "*.do?")

While myFile <> ""
Set myDoc = Documents.Open(PathToUse & myFile)

'*******************************************
'do your stuff
'*******************************************
myDoc.Close SaveChanges:=wdSaveChanges
myFile = Dir$()
Wend

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

Mark Reid wrote:
> Hi
>
> I need to open a set of files 1 ant a time process the file by
> running a macro (already Written) then move on to the next file in
> the list can anyone help i am using word 2003 and 2007
>
> Thanks in advance
>
> Mark Reid

Top